php连接mysql/access
连接mysql:
$conn=@mysql_connect("localhost","root","");//数据库地址,用户名,密码
mysql_query("Set Names 'gbk'");//设置语言
if (!$conn){
echo "Connect Database Error!");
} else {
if(!@mysql_select_db("test", $conn))//选择数据库
echo 'Select Database Error:'.@mysql_error($conn));
}
连接access：
$str="DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath("data/db1.mdb");
$conn=odbc_connect($str,"","",SQL_CUR_USE_ODBC);//dsn,用户名，密码
SQL_CUR_USER_ODBC可避免当使用复杂的资料存取时可能会有类似 "Cannot open a cursor on a stored procedure that has anything other than a single select statement in it" 的错误信息字符串
sky 58.62.103.* 2007-10-21 16:16:19