Home > Article > Backend Development > Code examples for using adodb to connect to different databases in PHP programs, _PHP tutorial
adodb.inc.php file needs to download an adodb, place it in the corresponding location, and then include it in php Just come in.
Connect to oracle database
<?php include("adodb/adodb.inc.php"); //包含adodb类库文件 $conn = &NewADOConnection('oci8'); $conn->Connect($DBServer,$DBUser,$DBPass); ?>
Connect to PostgreSQL database
<?php include("adodb/adodb.inc.php"); //包含adodb类库文件 $conn = NewADOConnection('postgres'); $conn->Connect('localhost', 'root', 'pass', 'mydb'); ?>
Connect to PostgreSQL database
<?php include("adodb/adodb.inc.php"); //包含adodb类库文件 $conn = NewADOConnection(' postgres '); $conn->Connect('host=localhost port=5432 dbname=mydb'); //连接PostgreSQL数据库 ?>
Connect to Mysql database
<?php include("adodb/adodb.inc.php"); //包含adodb类库文件 $conn = NewADOConnection('mysql://root:1981427@localhost/test'); //连接MySQL数据库 ?>
Connect to MySQL database
<?php include("adodb/adodb.inc.php"); //包含adodb类库文件 $conn = NewADOConnection('mysql'); $conn->Connect('localhost', 'root', '1981427', 'test'); //连接MySQL数据库 ?>
Connect to Access database
<?php include("adodb/adodb.inc.php"); //包含adodb类库文件 $conn = NewADOConnection('access'); //连接Access数据库 $conn->Connect("Driver={Microsoft Access Driver (*.mdb)};Dbq=d://mydb.mdb;Uid=Admin;Pwd=;"); ?>
Connect to SQL Server database via ODBC
<?php include("adodb/adodb.inc.php"); //包含adodb类库文件 $conn=NewADOConnection('odbc_mssql'); //连接SQL Server数据库 $conn->Connect("Driver={SQL Server};Server=localhost;Database=mydb;",'username','password'); ?>
Connect to SQL Server database
<?php include("adodb/adodb.inc.php"); //包含adodb类库文件 $conn=NewADOConnection('mssql'); //连接SQL Server数据库 $conn->Connect("localhost', 'username', 'password', 'mydb'); ?>
Connect to DB2 database
<?php include("adodb/adodb.inc.php"); //包含adodb类库文件 $conn=NewADOConnection('db2'); //连接DB2数据库 $conn->Connect("driver={IBM db2 odbc DRIVER};database=mydb;hostname=localhost;port=50000; protocol=TCPIP;uid=root; pwd=pass"); ?>
Let’s look at an example application in PHP programming:
First define a database connection function, which supports a variety of different databases. Pass in a SQL statement and return the execution result. The code is as follows:
public function DBConnect($DBType,$DBServer,$DBUser,$DBPass,$DBName,$sqlStr) { $StrCon; $result; $conn; $output=""; switch($DBType) { Case 0: //Sql Server //$StrCon ="Driver={SQL Server};Server=$DBServer;Database=$DBName;Uid=$DBUser;Pwd=$DBPass;"; //创建SQL Server数据库连接 $conn= &NewADOConnection('odbc_mssql'); $conn->Connect("Driver={SQL Server};Server=".$DBServer.";Database=".$DBName.";Uid=".$DBuser.";Pwd=".$DBPass.";"); break; Case 1: //Oracle //$StrCon ="Provider=MSDAORA.1;Data Source=$DBServer;Password=$DBPass;User ID=$DBUser;Persist Security Info=True;"; //创建oracle数据库连接 $conn = &NewADOConnection('oci8'); $conn->Connect($DBServer,$DBUser,$DBPass); break; Case 2: //Access //$StrCon ="Driver={Microsoft Access Driver (*.mdb)};Dbq=$DBName;Uid=$DBUser;Pwd=$DBPass;"; //创建Access数据库连接 $conn = &NewADOConnection('access'); $conn->Connect("Driver={Microsoft Access Driver (*.mdb)};Dbq=".$DBName.";Uid=".$DBUser.";Pwd=".$DBPass.";"); break; Case 3: //mysql //创建mysql数据库连接 $conn = NewADOConnection('mysql'); $conn->Connect($DBServer,$DBUser,$DBPass,$DBName); //$conn = &NewADOConnection("mysql://".$DBUser.":".$DBPass."@".$DBServer."/".$DBName); break; default: echo "抱歉,暂不支持此数据库,请检查配置的数据库类型!"; die(); break; } //执行查询操作 $result=$conn->Execute($sqlStr); //数据库查询失败处理 if ($result==false) { die("查询失败"); } //输出查询结果 while(!$result->EOF) { $max=$result->fieldcount(); //$output=array(); for($i=0;$i<$max;$i++) { //echo $result->fields[$i].' '; $res[$i]=$result->fields[$i].' '; $output=$output.$res[$i]; } $result->MoveNext(); } $output=trim($output); //echo $output; //关闭数据库连接 $conn->Close(); return $output; }
Define a function, specify the database type to be used, database user name and password, etc., pass in the SQL statement, call the database connection method defined above, and execute the SQL statement.
public function ExecuteSql($sqlStr) { $DBType=1; $DBServer="arron"; //数据库用户名,不要使用sys这个超级用户 $DBUser="system"; $DBPass="abcde"; $DBName=""; //$sqlStr="SELECT * FROM func;"; $myExpectStr=$this->DBConnect($DBType,$DBServer,$DBUser,$DBPass,$DBName,$sqlStr); return $myExpectStr; } }