R: [PHP-WIN] Using ODBC
| From: | Alberto. Sartori | Date: | Thu, 04 Apr 2002 14:45:12 +0000 |
| Subject: | R: [PHP-WIN] Using ODBC | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-12932@lists.php.net to get a copy of this message | ||
I've used several times an ODBC Connection with Access db. I used the COM object. I found a
simply example:
$dbname="prova.mdb";
$query="SELECT * FROM users";
$connessione=new COM("ADODB.Connection");
$connessione->Open("DRIVER={Microsoft Access Driver (*.mdb)};
DBQ=C:\\inetpub\\wwwroot\\$dbname");
$rs=$connessione->execute($query);
if (!$rs->EOF)
{
while (!$rs->EOF)
{
$campo1=$rs->fields("name");
$campo2=$rs->fields("surname");
$campo3=$rs->fields("email");
echo $campo1->value."<br>";
echo $campo2->value."<br>";
echo $campo3->value."<br><hr>";
$rs->movenext();
}
}
$rs->close;
?>
-----Messaggio originale-----
Da: Someone Somewhere [mailto:cirkitbraker@hotmail.com]
Inviato: giovedì 4 aprile 2002 17.45
A: php-windows@lists.php.net
Oggetto: [PHP-WIN] Using ODBC
Does anyone have any experience using ODBC to connect to an Access database,
I'm runing php and Apache in Windows 2000. Any help will be apreciated.
Thanks
Someone
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php