PHP connection MySQL, MSSQL, ACCESS,PDO, etc. connection database code

//php and MySQL database connection code

The code is as follows	Copy Code
mysql_connect (' localhost ', ' root ', ' root ') or Die (' MySQL server stop or use password error! '); mysql_select_db (' cshouse ') or Die (' datebase error '); mysql_query ("Set Names ' GB2312 '");

PHP connects Access database code

The code is as follows	Copy Code
$conn = @new COM ("ADODB. Connection ") or Die (" ADO Connection faild. "); $connstr = "Driver={microsoft Access DRIVER (*.mdb)}; Dbq= ". $path; $conn->open ($CONNSTR);

//php uses PDO to connect to the MDB database, which is more suitable for the user who collects data from the locomotive

The code is as follows	Copy Code
$path = "F:ontspiderresult.mdb"; $conn = new PDO ("SQLite: $path"); if ($conn) { Echo (' Connection PDO success '); } Else { Echo (' Cnnection PDO fail, plase check Database server! '); }

//PHP and MSSQL database connection code

code is as follows	copy code
$link = Mssql_connect ("127.0.0.1", "sa", "sa") or Die ("Can ' t connect SQL Server");     mssql_select_db ("FRRC", $link) or Die ("Select database Failure");     /*       Good site original article reproduced in the source http://www.111cn.net/phper/php.html  */