Home > Article > Backend Development > Three ways to connect Access database with php_PHP tutorial
Three ways to connect Access database with php_PHP tutorial
- WBOYOriginal
- 2016-07-13 17:38:38991browse
Although it is not the same category, let’s put it here first
Recently I want to change an ASP website to PHP, but unfortunately the space does not support mysql database, so I have to use access database, but I have used php+mysql before, and I have never done php+access database programming.
Thanks to the party, thanks to cctv, and thanks to the search engine. I couldn’t find a good article here, so I’m here to share it with you. //2cto.com
There are the following 3 ways to connect to Access in PHP. php programmer's home
(1) Create a system data source and use the ODBC function provided by PHP.
php programmer’s home
(2) You can also use PHP's ODBC function, but do not create a data source.
Open Database Connection (Open DateBase Connection, ODBC) is one of the Windows Open Server (Open Services) API (WOSA) products. A data source is a named connection to a database. An ODBC driver is required for each type of database that the application wants to connect to. The ODBC API is primarily designed for client/server RDBMS use, but the ODBC driver can also be used to connect to desktop database files, worksheets, and flat files. ODBC uses the Odbcinst.dll library to set up and clear data sources. Odbcad32.exe is an independent 32-bit executable application for establishing ODBC data sources. It has its corresponding icon in the Control Panel.
php programmer station //2cto.com
The ODBC driver manager opens the ODBC driver for the data source and passes SQL statements to the driver. After the client/server RDBMS processes a select query, the ODBC driver returns the value to the application. When an insert, update, or delete statement is executed, the driver returns the number of rows affected by the query. //2cto.com
The following introduces how PHP uses ODBC to connect to the Access database. Use $connstr="DRIVER= Microsoft Access Driver (*.mdb) to set the data driver, and the function realpath() is used to obtain the relative path of the database. Using this method to connect to the Access database mainly applies to PHP's odbc_connect() function. This function The statement is as follows: //2cto.com
The following is the quoted content:
resource odbc_connect( string dsn, string user, string password [, int cursor_type])
dsn: system dsn name
user: a username of the database server.
php programmer station
password: password of a user on the database server. php programmer station
cursor_type: Cursor type.
php programmer’s home
The code is as follows:
The following is the quoted content:
$connstr="DRIVER=Microsoft Access Driver (*.mdb);
DBQ=".realpath("bookinfo.mdb");
$connid=odbc_connect($connstr,"","",SQL_CUR_USE_ODBC );
php programmer’s home
(3) Use Microsoft's ADODB database driver. ActiveX Data Objects (ADO) is the database access technology for Microsoft Open Database Applications. It is designed to work together with the new data access layer OLE DB Provider to provide universal data access (Universal Date Access). OLE DB is a low-level data access interface that can be used to access various data sources, including traditional relational databases, email systems, and customized business objects. ADO technology greatly simplifies the operation of OLE DB. Because ADO encapsulates a large number of COM interfaces used in OLE DB programs, ADO is a high-level access technology. php programmer station //2cto.com
ADO technology is based on the Common Object Model (COM), which provides access technology in multiple languages. PHP uses the ADO method to manipulate the Access database by pre-defining the COM class. The detailed description of this class is as follows:
The following is the quoted content:
string com::com( string module_name [, string server_name [, int codepage]])
module_name: The name or class-id of the requested component.
server_name: The name of the DCOM server.
Codepage: Specifies the code page used to convert PHP strings to UNICODE strings and vice versa. The values of this parameter are CP_ACP, CP_MACCP, CP_OEMCP, CP_SYMBOL, CP_THREAD_ACP, CP_UTF7 and CP_UTF8.
The code for PHP to use the com class and use the ADO method to access the database is as follows:
The following is the quoted content:
$conn = new com("ADODB.Connection");
$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath("bookinfo.mdb ");
$conn->Open($connstr);