PHP连接数据库大全

php连接数据库推荐用PHP+MYSQL

PHP+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”)