php 与access 数据库连接实例
-
原创
-
2016-06-08 17:27:58
838浏览
echo "
";
echo "";
echo "personID | ";
echo "FirstName | ";
echo "LastName | ";
echo "Age | ";
echo "
";
$connstr="DRIVER=Microsoft Access Driver (*.mdb);DBQ=".realpath("SpiderResult.mdb");
$conn=odbc_connect($connstr,"","",SQL_CUR_USE_ODBC );
$query=odbc_do($conn,"select top 10 * from content");
while(odbc_fetch_row($query)) {
echo "";
$personID = odbc_result($query,1);
$FirstName = odbc_result($query,2);
$LastName = odbc_result($query,3);
$Age = odbc_result($query,4);
echo "" . $personID . " | ";
echo "" . $FirstName . " | ";
echo "" . $LastName . " | ";
echo "" . $Age . " | ";
echo "
";
}
echo "
";
odbc_close($conn);
//本站原创www.111cn.net
声明:本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系admin@php.cn核实处理。