本文章提供了四种数据库连接程序,都针对于php的,像php mysql,与mssql是比较常用的,至于php access数据连接也有不秒人在用,还有就是利用php pdo来连接数据库代码我是在用火车头采集数据时来用的.
-
-
- 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'");
-
-
-
- conn = @new COM("ADODB.Connection") or die ("ADO Connection faild.");
- $connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . $path;
- $conn->Open($connstr);
-
-
-
- $path ="F: ontSpiderResult.mdb";
- $conn = new PDO("sqlite:$path");
- if( $conn )
- {
- echo ('connection pdo success');
- }
- else
- {
- echo ('cnnection pdo fail ,plase check database server!');
- }
-
-
-
- $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");
|