Copy CodeThe code is as follows:
$conn = new COM ("ADODB. Connection ");
$connstr = "Driver={microsoft Access DRIVER (*.mdb)}; Dbq= ". Realpath ("Www.jb51.net/db.mdb");
The COM interface is used to connect to the access.
$conn->open ($CONNSTR);
$rs = new COM ("ADODB. RecordSet ");
The data is queried and displayed.
$rs->open ("SELECT * from szd_t", $conn, 1, 1);
while (! $rs->eof) {
$f = $rs->fields (1);
Echo $f->value;
$rs->movenext ();
}
Let's take a look at the PHP Access database tutorial Save
$sql = "INSERT into szd_t (title) VALUES (' www.jb51.net ')";
$rs->open ($sql);
Echo ' Save success ';
PHP Access database editing
$sql = "Update szd_t set title= ' jb51.net ' where id=". $_get[' id '];
$rs->open ($sql);
Echo ' editing success ';
Delete data
$sql = "Delete from szd_t where id=". $_get[' id '];
PHP three ways to connect to an Access database
Recently want to put an ASP Web site to PHP, helpless space does not support MySQL database, had to use Access database, but used to be used php+mysql,php+access database programming really did not do.
Thanks to the party, thanks to CCTV, thanks to the search engine, this does not find a good article, special turn around and share with you.
There are 3 ways to connect to access in PHP.
(1) Create a system data source, using the ODBC function provided by PHP.
(2) You can also use PHP's ODBC functions, but do not create a data source.
Open database Connection (open Datebase Conection,odbc) is one of the windows open Server (open service) API (WOSA) products. A data source is a named connection to the database. An ODBC driver is required for the different types of databases that the application wants to connect to. The ODBC API is designed primarily for client/server RDBMS use, but ODBC drivers can also be used to connect desktop database files, worksheets, and flat files. ODBC uses the Odbcinst.dll library to set up and purge data sources. Odbcad32.exe is a stand-alone 32-bit executable application for establishing an ODBC data source, with its corresponding icon control Panel in the dashboard.
The ODBC Driver Manager opens the ODBC driver for the data source and sends the SQL statement to the driver. After the client/server RDBMS finishes processing 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. Phperz.com
Here's how PHP connects to an Access database using ODBC. Use $connstr= "driver= Microsoft Access DRIVER (*.mdb) to set up data-driven, function Realpath () to get the relative path of the database. Using this method to connect to an Access database is primarily applied to the PHP odbc_connect () function, which is declared as follows: www.phperz.com
Copy CodeThe code is as follows:
Resourse odbc_connect (String dsn, string user, string password [, int cursor_type])
DSN: the System DSN name.
User: The database server has a username.
Password: A user password for the database server.
Cursor_type: Cursor type.
The code is as follows:
Copy CodeThe code is as follows:
$connstr = "Driver=microsoft Access DRIVER (*.mdb);
Dbq= ". Realpath (" Bookinfo.mdb ");
$connid =odbc_connect ($connstr, "", "", SQL_CUR_USE_ODBC);
(3) using Microsoft's ADODB database driver. ActiveX data Objects (ADO) is a 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 provides access to a variety of data sources, including traditional relational databases, e-mail systems, and custom 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, so ADO is a high-level access technology. PHP Programmer Station
ADO technology is based on the Common object Model (COM), which provides access techniques for multiple languages. PHP uses the ADO method to manipulate an Access database by pre-defining class COM. The class is described in detail as follows: www.phperz.com
Copy CodeThe code is as follows:
String com::com (String module_name [, String server_name [, int codepage]])
Module_name: The name or Class-id of the requested component. Www~phperz~com
The name of the server_name:dcom server.
Codepage: Specifies the code page used to convert the PHP string to a Unicode string, and vice versa. The values for 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 access the database using the ADO method is as follows:
[Code]
$conn = new COM ("ADODB. Connection ");
$connstr = "Driver={microsoft Access DRIVER (*.mdb)}; Dbq= ". Realpath ("Bookinfo.mdb");
$conn->open ($CONNSTR);
This is an article sent by other netizens. Combined, the final script home will give a php+access message source code, we can refer to the next. Basically, the operation of PHP access is familiar.
Although it's very rare to use PHP to link to access, it's good to use the occasional guide data.
Copy CodeThe code is as follows:
/*
Create an ADO connection
*/
$conn = @new COM ("ADODB. Connection ") or Die (" ADO Connection faild. ");
$connstr = "Driver={microsoft Access DRIVER (*.mdb)}; Dbq= ". Realpath ("Datum/cnbt.mdb");
$conn->open ($CONNSTR);
/*
Create a recordset query
*/
$rs = @new COM ("ADODB. RecordSet ");
$rs->open ("SELECT * from Dbo_dirs", $conn, 1, 3);
/*
Looping through data
*/
while (! $rs->eof) {
echo "$rs->fields[" title "]->value;
echo "
";
$rs->movenext (); Move the recordset pointer down
}
$rs->close ();
?>
function description and examples
Although it's very rare to use PHP to link to access, it's good to use the occasional guide data.
PHP ACCESS Simple Message This example source code
http://www.bkjia.com/PHPjc/321776.html www.bkjia.com true http://www.bkjia.com/PHPjc/321776.html techarticle Copy the code code as follows: $conn = new COM ("ADODB. Connection "); $connstr = "Driver={microsoft Access DRIVER (*.mdb)}; Dbq= ". Realpath ("Www.jb51.net/db.mdb"); Connect with Access ...
