Usage of php adodb

ADODB is the abbreviation of Active Data Objects Data Base. It is an intermediate function component for PHP to access the database.

Although PHP is a powerful tool for building Web systems, the function of PHP accessing databases has not been standardized. Each database uses a different and incompatible application programming interface (API). ). In order to fill this gap, ADODB appeared. Once the interface for accessing the database is standardized, the differences between various databases can be hidden, and it will be very easy to switch to other different databases.

The latest version of ADODB is currently V5.16, which supports many types of databases, such as: MySQL, PostgreSQL, Interbase, Informix, Oracle, MS SQL 7, Foxpro, Access, ADO, Sybase, DB2 and general ODBC (the drivers for PostgreSQL, Informix, and Sybase are contributed by the development of the free software community).

One of the biggest advantages of using ADODB is that regardless of the back-end database, the way to access the database is the same. Developers and designers do not have to learn another different set of databases for a certain set of databases. Access methods, which greatly reduce the knowledge burden on developers. Past knowledge can still be used in the future. When the database platform is transferred, the program code does not need to be changed too much.

In fact, the development concept of ADODB is not the first. DBI appeared earlier than ADODB. It provides Perl with a consistent API call interface when accessing the database. I believe that friends who have used Perl + DBI will feel familiar when they use ADODB again.

In addition, ADODB should be familiar to those who have used ASP, and such friends should be easily able to accept ADODB.

//假设数据库名字为 a  表名为b

//包含adodb类

include_once("adodb.inc.php");

//链接数据库的类型----------------------链接方式1

$db=NEWADOConnection("mysql");

$db->Connect("localhost","root","my123","a")or die("链接数据库错误");
//------------------------------------------链接方式2
//$db-//>NEWADOConnection("mysql://root:my123@localhost/b")
//设置字符集

$db->Excute("set names 'utf8' ");

//查询

$query=$db->Execute("select *from b");
while($row=$query->FetchRow()){

   print_r($row);
}

//插入

$arr=array(
      
         'name'=>'one',
         'age'   =>'18',
         'sex'   =>'boy',
)
$db->AutoExecute('b',$arr,'INSERT');//insert 大写

//更新

$sql="update b set name='wo' where id='1' ";
$db->Execute($sql);


//ADODB实现分页

include_once("adodb.inc.php");
include_once("adodb-page.inc.php");
session_start; //使用session保存分页;
//以地址的方式链接
$db=NEWADOConnection("mysql://root:my123@localhost/b");
$sql="select *from b";
$page=NEW ADODB_Pager($sql);
$page->reader(3);

// 以表格的形式展现

include_once("tohtml.inc.php");
$db=NewADOConnection("mysql");
$db->Connect("localhost",'root','my123','a');
$query=$db->Execute("select *from b");
echo rs2html($query);

The above is the detailed content of Usage of php adodb. For more information, please follow other related articles on the PHP Chinese website!