How to connect odbc data source with php and save and query data, phpodbc_PHP tutorial

php method to connect odbc data source and save and query data, phpodbc

The example in this article describes the method of connecting odbc data source with php and saving and querying the data. Share it with everyone for your reference.

The specific implementation code is as follows:

Copy code The code is as follows:

$connstr = "driver=microsoft access driver (*.mdb);dbq=".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);dbq=".realpath("db.mdb");
$connid = odbc_connect($connstr,"","",sql_cur_use_odbc);
$odbc_exec = odbc_exec($connid, "insert into t...")
//Query 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);//Open source code phpfensi.com
$a++;
odbc_close($conn);
}
$endtime = time();
echo $begintime."
";
echo $endtime."
";
echo date('u seconds',$endtime-$begintime);
echo '
';

I hope this article will be helpful to everyone’s PHP programming design.

http://www.bkjia.com/PHPjc/932490.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/932490.htmlTechArticleHow to connect odbc data source with php and save and query data, phpodbc This article describes how to connect odbc data source with php and Methods for saving and querying data. Share it with everyone for your reference. Tool...