PHP query via Datasource name
Posted: Mon Jan 23, 2006 12:05 pm
feyd | Please use
feyd | Please use
Code: Select all
andCode: Select all
tags where appropriate when posting code. Read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url][/color]
Hi I'm trying to make a query in PHP that will let me retrieve information from my Microsoft Acces database via a datasource name. I do not get any error message but it show me a blank page.
I don't know How to display my query result. I a Cold fusion expert but don't know nothing about PHP,Code: Select all
<?
include('adodb.inc.php'); # charge le code deADOdb
$conn = &ADONewConnection('access'); # crée une connexion
$conn->PConnect('dsdatabase'); # se connecte à MS-Access, northwind DSN
$recordSet = &$conn->Execute('select id, name, client from client');
if (!$recordSet)
print $conn->ErrorMsg();
else
while (!$recordSet->EOF) {
print $recordSet->fields[0].' '.$recordSet->fields[1].'<BR>';
$recordSet->MoveNext();
}
$recordSet->Close(); # optionnel
$conn->Close(); # optionnel
?>feyd | Please use
Code: Select all
andCode: Select all
tags where appropriate when posting code. Read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url][/color]