Home  >  Article  >  Backend Development  >  Code examples for using adodb to connect to different databases in PHP programs, _PHP tutorial

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

WBOY
WBOYOriginal
2016-07-12 09:02:31771browse

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

Connect to PostgreSQL database

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

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

Connect to Mysql database

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

Connect to MySQL database

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

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

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


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

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

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

Articles you may be interested in:

  • php adodb connects to mssql to solve the garbled problem
  • A collection of commonly used php ADODB usage methods
  • Detailed explanation of the ADODB class in PHP

www.bkjia.comtruehttp: //www.bkjia.com/PHPjc/1084598.htmlTechArticleCode examples of using adodb to connect different databases in PHP programs. The adodb.inc.php file needs to download an adodb, Just put it in the corresponding location and include it in php. Connect...
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn