note 16919 modified in function.odbc-connect by yannick
| From: | yannick@php.net | Date: | Fri, 08 Aug 2008 07:43:45 +0000 |
| Subject: | note 16919 modified in function.odbc-connect by yannick | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-143296@lists.php.net to get a copy of this message | ||
Due to multiple requests, more for DSN-less connections:
<?php
$db_connection = new COM("ADODB.Connection");
$db_connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=".
realpath("../databases/database.mdb") ." ;DefaultDir=".
realpath("../databases");
$db_connection->open($db_connstr);
$rs = $db_connection->execute("SELECT * FROM Table");
$rs_fld0 = $rs->Fields(0);
$rs_fld1 = $rs->Fields(1);
while (!$rs->EOF) {
print "$rs_fld0->value $rs_fld1->value\n";
$rs->MoveNext(); /* updates fields! */
}
$rs->Close();
$db_connection->Close();
?>
(Prints first 2 columns for each row.)
--was--
Due to multiple requests, more for DSN-less connections:
$db_connection = new COM("ADODB.Connection");
$db_connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=".
realpath("../databases/database.mdb") ." ;DefaultDir=".
realpath("../databases");
$db_connection->open($db_connstr);
$rs = $db_connection->execute("SELECT * FROM Table");
$rs_fld0 = $rs->Fields(0);
$rs_fld1 = $rs->Fields(1);
while (!$rs->EOF) {
print "$rs_fld0->value $rs_fld1->value\n";
$rs->MoveNext(); /* updates fields! */
}
$rs->Close();
$db_connection->Close();
(Prints first 2 columns for each row.)
http://php.net/manual/en/function.odbc-connect.php