PHP连接数据库大全
php连接数据库推荐用PHP+MYSQLPHP+ACCESS
$conn = new com("ADODB.Connection");
$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath("workermove.mdb");
$conn->Open($connstr);
$rs = new com("ADODB.RecordSet");
$rs->Open(SQL语句,$conn,1,1);
PHP+MSSQL
<?
$conn = new com("ADODB.Connection");
$connstr = "DRIVER={SQL SERVER};SERVER=127.0.0.1\GSQL;UID=SA;PWD=ADMIN;DATABASE=WORKMOVE";
$conn->Open($connstr);
?>
PHP+MYSQL
<?
$CONN=mysql_connection(“127.0.0.1”,”root”,””);
?>
PHP+SQLITE
$db=@sqlite_open(“sqlite.db”);
也可调用ODBC方式连接SQLITE
详见PHP手册
PHP+PostgreSQL
$conn_string=@pg_conect(“host=127.0.0.1 port=5432 dbname=test1 user=itnows password=000000”)
页:
[1]