php 连接odbc数据源并保存,查找数据
发布时间:2022-02-19 12:45:38 所属栏目:PHP教程 来源:互联网
导读:$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 *
$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; //保存数据 $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……") //查询数据www.Cuoxin.com $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);//开源代码Cuoxin.com $a++; odbc_close($conn); } $endtime = time(); echo $begintime."<br>"; echo $endtime."<br>"; echo date('u秒',$endtime-$begintime); echo '<br />'; (编辑:广州站长网) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |