How to use ADODB to let PHP operate ACCESS database

How to use ADODB to let PHP operate ACCESS database_PHP tutorial

WBOY

Release： 2016-07-21 15:58:48

Original

898 people have browsed it

I have been studying PHP for the past two days, mainly to cope with some background knowledge required to learn AJAX. I always have an inexplicable affinity for open source things. Everyone loves free things. Because of the general spatial MYSQL database You have to spend money to buy it separately, so I planned to use ACCESS for the time being, but when I checked the information, I was confused. It turned out that PHP operates different methods for different databases... So I searched some blogs and found many links. ACCESS methods, but none of them are satisfactory, and finally I found ADODB. It is a class of PHP that has built-in most of the database operation methods you have seen. For example, when PHP operates a MYSQL, it is usually Like this:

Copy code The code is as follows:

$db = mysql_connect("localhost", "root", "password" ); 
mysql_select_db("mydb",$db); 
$result = mysql_query("SELECT * FROM employees",$db); 
if ($result === false) die("failed "); 
while ($fields = mysql_fetch_row($result)) { 
 for ($i=0, $max=sizeof($fields); $i < $max; $i++) { 
 print $fields[$i].' '; 
 } 
 print "
n"; 
} 

If you use ADODB, the results obtained by the following program are the same as above

Copy code The code is as follows:

include("adodb.inc.php"); 
 $db = NewADOConnection( 'mysql'); 
 $db->Connect("localhost", "root", "password", "mydb"); 
 $result = $db->Execute("SELECT * FROM employees "); 
 if ($result === false) die("failed"); 
 while (!$result->EOF) { 
 for ($i=0, $max=$ result->FieldCount(); $i < $max; $i++) 
 print $result->fields[$i].' '; 
 $result->MoveNext(); 
 print "
n"; 
 } 

Then, if you want to use other databases, just change the connection name of ADOConnection. For ACCESS, use

$db = NewADOConnection ('access');

The complete code is as follows:

Copy code The code is as follows:

< ?php
include("adodb/adodb.inc.php");
$db = ADONewConnection('access');
$dsn = "Driver={Microsoft Access Driver (*.mdb)} ;Dbq=d:selfmyphpbook.mdb;Uid=;Pwd=;";
$db->Connect($dsn);
$result = $db->Execute("SELECT * FROM data" );

if ($result === false) die("failed");
while (!$result->EOF) {
for ($i=0, $max =$result->FieldCount(); $i < $max; $i++)
print "

".$result->fields[ $i]."
";
$result->MoveNext();

}
?>

ADODB can be downloaded here http://phplens.com/phpeverywhere/