PHP operation access database method

The example in this article describes how PHP operates the access database. Share it with everyone for your reference, the details are as follows:

In PHP website development, PHP and Mysql are the best combination, but when you want to transplant websites from other platforms to the PHP platform, you must Encountered portability issues, such as how to port the ASP+ACCESS platform? The first problem is that PHP connects to the Access database. How does PHP establish a connection with the Access database without changing the database?

PHP provides a variety of database connection solutions. Here is a detailed code example of how to use PHP ADOdb, PDO, ODBC to establish a connection with the Access database, as a starting point.

Preparation

Use OFFICE tool to create Access database file

1. Use PHP ADOdb to connect to Access database

1. First You need to install the PHP ADOdb library.

2. The code for using PHP ADOdb to connect to the Access database is as follows

<?php
  include(&#39;adodb5/adodb.inc.php&#39;);
  $db =& ADONewConnection(&#39;access&#39;);
  $dsn = "Driver={Microsoft Access Driver (*.mdb)};Dbq=".realpath("access.mdb").";Uid=;Pwd=;";
  $db->Connect($dsn);
  $rs = $db->Execute(&#39;select * from web&#39;);
  print "<pre class="brush:php;toolbar:false">";
  print_r($rs->GetRows());
  print "

"; ?>

Description: Similar to using PHP ADOdb to establish a connection with the Mysql database, first put The ADOdb class library is included, and then ADONewConnection, Connect, and Execute are called to establish a connection with the Access database and perform query operations.

2. Use PHP PDO to connect to Access database

The PDO function requires PHP5 or above support. Before using PDO, you must ensure that the PDO function is installed. How to configure and install PDO? ?

Just find extension_dir in the PHP.INI configuration file, make it point to the extension library directory address, and remove the semicolon (;) before the PDO driver DLL you want to use, restart Apache, and PDO will be installed. . Since we use PDO to connect to the Access database here, at least ensure that php_pdo.dll and php_pdo_odbc.dll can support it.

Use PDO to connect to the Access database code example

<?php
  $db = new PDO("odbc:driver={microsoft access driver (*.mdb)};dbq=".realpath("access.mdb")) or die("Connect Error");
  $rs = $db->query(&#39;select * from web&#39;);
  print "<pre class="brush:php;toolbar:false">";
  print_r($rs->fetchAll());
  print "

"; ?>

Instructions: First initialize the PDO object, establish the connection between PHP and the Access database, and then Query operations are performed through the PDO query function.

3. Use ODBC to connect to the Access database

Code examples for using ODBC to connect to the Access database

<?php
  $dsn = "DRIVER=Microsoft Access Driver (*.mdb);dbq=".realpath("access.mdb");
  $conn = @odbc_connect($dsn,"","",SQL_CUR_USE_ODBC ) or die ("Connect Error!");
  $sql = "select * from web";
  $rs = @odbc_do($conn,$sql);
  while(odbc_fetch_row($rs)){
    echo "网站名称：".odbc_result($rs,"webname");
    echo "<br/>网站地址：".odbc_result($rs,"website");
  }
  odbc_close($conn);
?>

Description: First use odbc_connect to connect to the access database. The first three parameters are: $DSN, database user name, password. The fourth parameter is set to SQL_CUR_USE_ODBC mainly to avoid unexpected errors when connecting to the Access database; then use odbc_do to perform query operations. , and call odbc_fetch_row, odbc_result to output the query content, and finally use odbc_close to close the Access database connection.

This completes the introduction of code examples for using PHP ADOdb, PDO, and ODBC to connect to the Access database and perform operations. Through the above examples, we can see that the methods for connecting to the Access database using PHP are similar. Which method to use depends on The configuration of the PHP environment.

For more articles related to PHP operating access database methods, please pay attention to the PHP Chinese website!