How to implement access database operation in PHP

This article mainly introduces the method of using PHP to operate the access database. It also analyzes in detail the specific implementation techniques and related precautions for PHP to connect and operate the access database based on ADOdb, PDO and ODBC in the form of examples. Friends in need can refer to it. Next

The example in this article describes how to operate the access database in PHP. 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 will inevitably encounter transplantation Sexual issues, such as how to transplant 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 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.

The above is the entire content of this article, I hope it will be helpful to everyone's study.

Related recommendations:

ajax non-refresh upload image and image download function in PHP

PHP JavaScript implements uploading images without refreshing

PHP editor PhpStrom slow running problem

The above is the detailed content of How to implement access database operation in PHP. For more information, please follow other related articles on the PHP Chinese website!