CODEWITHSUNDEEP
phpoledb
Graviton
Graviton

Reputation: 83264

PHP with Oledb

Can I use PHP with Oledb connection?

As far as I know database connection as provided by PHP extension are all odbc.

Upvotes: 7

Views: 15688

Answers (3)

Andrew Moore
Andrew Moore

Reputation: 95404

You can use ActiveX Data Objects (Microsoft's OLEDB ActiveX layer) in PHP-Win without any third party extension as such:

$conn = new COM("ADODB.Connection") or die("Cannot start ADO"); 

// Microsoft Access connection string.
$conn->Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\inetpub\wwwroot\php\mydb.mdb");

// SQL statement to build recordset.
$rs = $conn->Execute("SELECT myfield FROM mytable");
echo "<p>Below is a list of values in the MYDB.MDB database, MYABLE table, MYFIELD field.</p>";

// Display all the values in the records set
while (!$rs->EOF) { 
    $fv = $rs->Fields("myfield");
    echo "Value: ".$fv->value."<br>\n";
    $rs->MoveNext();
} 
$rs->Close();

Upvotes: 11

Matthew Flaschen
Matthew Flaschen

Reputation: 284876

Look at the ADOdb Library for PHP extension. I've never used it, but it seems to be compatible with OLEDB providers.

Upvotes: 1

Chris Bier
Chris Bier

Reputation: 14447

maybe......

found an article on it.

found the PHP extension for it.

Don't know anything about it. Best of luck.

Upvotes: -1

Related Questions