This article illustrates how PHP connects to ODBC data sources and saves and queries data. Share to everyone for your reference.
The specific implementation code is as follows:
Copy Code code as follows:
$CONNSTR = "Driver=microsoft Access Driver (*.mdb);d bq=". Realpath ("Db.mdb");
$connid = Odbc_connect ($connstr, "", "", SQL_CUR_USE_ODBC);
$odbc _exec = odbc_exec ($connid, insert INTO tablename (name) VALUES (' name '));
$query = Odbc_do ($connid, "SELECT * from TableName");
$odbc _result_all = Odbc_result_all ($query);
echo $odbc _result_all;
Save data
$CONNSTR = "Driver=microsoft Access Driver (*.mdb);d bq=". Realpath ("Db.mdb");
$connid = Odbc_connect ($connstr, "", "", SQL_CUR_USE_ODBC);
$odbc _exec = odbc_exec ($connid, insert into t ...)
Querying data
$a = 0;
$begintime = time ();
while ($a <100)
{
$conn = Odbc_connect ("forphp", "sa", "sa");
odbc_select_db ("[Testyouhui]", $conn);
$result = Odbc_exec ("SELECT [ID], [name] from [test1].[ DBO]. [Category] ", $conn);
$a + +;
Odbc_close ($conn);
}
$endtime = time ();
echo $begintime. " <br> ";
echo $endtime. " <br> ";
echo Date (' u sec ', $endtime-$begintime);
echo ' <br/> ';
I hope this article will help you with your PHP program design.