Code examples for using adodb to connect to different databases in PHP programs,

Code examples for using adodb to connect to different databases in PHP programs, _PHP tutorial

WBOY

Release： 2016-07-12 09:02:31

Original

803 people have browsed it

Code examples for using adodb to connect to different databases in PHP programs.

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

 <&#63;php 
  include("adodb/adodb.inc.php");         //包含adodb类库文件 
   $conn = &NewADOConnection('oci8');
   $conn->Connect($DBServer,$DBUser,$DBPass);  
  &#63;>

Copy after login

Connect to PostgreSQL database

  <&#63;php 
  include("adodb/adodb.inc.php");         //包含adodb类库文件 
  $conn = NewADOConnection('postgres'); 
  $conn->Connect('localhost', 'root', 'pass', 'mydb');    
  &#63;>

Copy after login

Connect to PostgreSQL database

  <&#63;php 
  include("adodb/adodb.inc.php");           //包含adodb类库文件 
  $conn = NewADOConnection(' postgres '); 
  $conn->Connect('host=localhost port=5432 dbname=mydb'); //连接PostgreSQL数据库 

  &#63;>

Copy after login

Connect to Mysql database

  <&#63;php 
  include("adodb/adodb.inc.php");                 //包含adodb类库文件 
  $conn = NewADOConnection('mysql://root:1981427@localhost/test');      //连接MySQL数据库 
  &#63;>

Copy after login

Connect to MySQL database

  <&#63;php 
  include("adodb/adodb.inc.php");         //包含adodb类库文件 
  $conn = NewADOConnection('mysql');        
  $conn->Connect('localhost', 'root', '1981427', 'test');   //连接MySQL数据库 
  &#63;>

Copy after login

Connect to Access database

  <&#63;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=;"); 
  &#63;>

Copy after login

Connect to SQL Server database via ODBC

  <&#63;php 
  include("adodb/adodb.inc.php");         //包含adodb类库文件 
  $conn=NewADOConnection('odbc_mssql');      //连接SQL Server数据库 
  $conn->Connect("Driver={SQL Server};Server=localhost;Database=mydb;",'username','password'); 
  &#63;>

Copy after login

Connect to SQL Server database

  <&#63;php 
  include("adodb/adodb.inc.php");         //包含adodb类库文件 
  $conn=NewADOConnection('mssql');        //连接SQL Server数据库 
  $conn->Connect("localhost', 'username', 'password', 'mydb'); 
  &#63;>

Copy after login

Connect to DB2 database

  <&#63;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"); 
  &#63;>

Copy after login

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;
 }

Copy after login

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;
 }
}

Copy after login