PHP Database Universal Engine Class adodb Configuration Usage and Instance Collection

ADODB PHP Database Universal Engine Class Features:
1. You can specify links and use of various types of databases in PHP
2. Help us to provide development efficiency and fast conversion of databases at PHP
3. Relatively simple to use
4. Writing should be more rigorous and case-sensitive
5. Richer built-in functions

How to configure and use ADODB PHP
1. Download the ADODB For PHP library zip
2. Unzip to any folder in the site directory
3. Introduce ADODB configuration file
4. Configure required database connections
5 Use built-in methods to manipulate linked databases

Connect MySql:

<?php 
include_once("adodb5/adodb.inc.php"); // Contain adodb Class Library Files  
$db = NewADOConnection('mysql'); 
$db->Connect('localhost', 'root', 'root', 'test')or die("df"); // Connect MySQL data base  
?>

Connect Access:

<?php 
include_once("adodb/adodb.inc.php"); // Contain adodb Class Library Files  
$conn = NewADOConnection('access'); // Connect Access data base  
$conn->Connect("test.mb")or die("cuowu"); 
?>

Connect DB2:

<?php 
include("adodb/adodb.inc.php"); // Contain adodb Class Library Files  
$conn=NewADOConnection('db2'); // Connect DB2 data base  
$conn->Connect("driver={IBM db2 odbc DRIVER};database=mydb;hostname=localhost;port=50000; 
protocol=TCPIP;uid=root; pwd=pass"); 
?>

Connect PostgreSQL:

<?php 
include("adodb/adodb.inc.php"); // Contain adodb Class Library Files  
$conn = NewADOConnection('postgres'); 
$conn->Connect('localhost', 'root', 'pass', 'mydb'); // Connect PostgreSQL data base  
?>

ADODB PHP for Quick Query

include_once("adodb5/adodb.inc.php");
$db = &NewADOConnection('mysql');
$db->Connect("localhost", "root", "",  " db")or die(" error ");
$db->Execute("set names 'GBK'");
$q=$db->Execute("select * from up_admin_user");
while($row=$q->FetchRow()){
print_r($row);
}

ADODB PHP Implements Intelligent Insert Function

include_once("adodb5/adodb.inc.php");
$db = &NewADOConnection('mysql');
$db->Connect("localhost", "root", "",  " db")or die(" error ");
$db->Execute("set names 'GBK'");
$arr=array('m_id'=>'2','password'=>'333333','33333'=>'4444444 ' );
$db->AutoExecute("up_admin_user",$arr,"INSERT");

Instance Sharing:
Query:

<?php 
include_once("adodb5/adodb.inc.php"); // Contain adodb Class Library Files  
$db = NewADOConnection('mysql'); 
$db->Connect('localhost', 'root', '', 'think_zw')or die("error"); // Connect MySQL data base 
$db->Execute("set names 'GBK'");
$query=$db->Execute("select * from think_zw");
while($row=$query->FetchRow()){
print_r($row);
}
?>

Insert: When inserted, it automatically filters out unused arrays.Exclude unused arrays.
Fields can be inserted inappropriately.

<?php 
include_once("adodb5/adodb.inc.php"); // Contain adodb Class Library Files  
$db = NewADOConnection('mysql'); 
$db->Connect('localhost', 'root', '', 'think_zw')or die("error"); // Connect MySQL data base 
$db->Execute("set names 'GBK'");
$arr=array("id"=>"",
"name"=>" Small Army ",
"details"=>" Jun likes to see beautiful women ");// Be careful not to write double quotes as single quotes 
$db->AutoExecute("think_zw",$arr,"INSERT");
$query=$db->Execute("select * from think_zw");
while($row=$query->FetchRow()){
echo $row[name]."<br>";
}
?> 

===============================

PHP ADODB Address Connection Database:

include_once("adodb5/adodb.inc.php"); 
$db = NewADOConnection('mysql://root:@localhost/upload'); 
$sql="SELECT * FROM `pic`"; 
$db->SetFetchMode(ADODB_FETCH_ASSOC);//ADODB_FETCH_NUM Here and that fetch_array and  fetch_row The difference is a little similar  
//mysql_fetch_array() 
$sr1 = $db->Execute($sql); 
print_r($sr1->fields); 

PHP ADODB Object-based Access to Database Content

$db = NewADOConnection('mysql'); 
$db->PConnect("localhost", "root", "", "upload"); 
$sql="SELECT * FROM `pic`"; 
$rs2=$db->Execute($sql); 
while($row=$rs2->FetchNextObject()){ 
echo $row->NAME; 
} 

PHP ADODB HTML Code Display Content

<?php 
include_once("adodb/adodb.inc.php"); // Contain adodb Class Library Files  
$conn = NewADOConnection('access'); // Connect Access data base  
$conn->Connect("test.mb")or die("cuowu"); 
?>

PHP ADODB Implements Automatic Paging of Content

include_once("adodb5/adodb-pager.inc.php"); 
session_start(); 
$db = NewADOConnection('mysql'); 
$db->Connect("localhost", "root", "", "upload"); 
$db->Execute("set names 'GBK'");
$sql="SELECT * FROM `pic`"; 
$pager=new ADODB_Pager($db,$sql); 
$pager->Render(2);