note 16919 added to function.odbc-connect
| From: | root at mediamonks dot net | Date: | Mon, 19 Nov 2001 09:03:30 +0000 |
| Subject: | note 16919 added to function.odbc-connect | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-20996@lists.php.net to get a copy of this message | ||
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://www.php.net/manual/en/function.odbc-connect.php
http://master.php.net/manage/user-notes.php?action=edit+16919
http://master.php.net/manage/user-notes.php?action=delete+16919
http://master.php.net/manage/user-notes.php?action=reject+16919