Home  >  Article  >  Backend Development  >  How to connect odbc data source with php and save and query data, phpodbc_PHP tutorial

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

WBOY
WBOYOriginal
2016-07-13 10:10:451018browse

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.

www.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...
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn