question in ADODB
| From: | pei_world | Date: | Wed, 19 Feb 2003 21:57:21 +0000 |
| Subject: | question in ADODB | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-25774@lists.php.net to get a copy of this message | ||
I found the following code on the internet. I'd like to know that what I
need to do, if I want to use the actually Access file with out the DSN, how
to use the Microsoft Jet?
thx
---------------------- code --------------------------------
include("adodb.inc.php");
$db = NewADOConnection('mysql');
$db->Connect("localhost", "root", "password", "mydb");
$result = $db->Execute("SELECT * FROM employees");
if ($result === false) die("failed");
while (!$result->EOF) {
for ($i=0, $max=$result->FieldCount(); $i < $max; $i++)
print $result->fields[$i].' ';
$result->MoveNext();
print "<br>\n";
}
--------------------------------------------------------------
--
Sincerely your;
pei_world ( .::IT::. )