PHP access data connection and implementation code for reading, saving and editing data

PHP access data connection and implementation code for reading, saving and editing data_PHP tutorial

WBOY

Release： 2016-07-21 15:38:27

Original

898 people have browsed it

Copy code The 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 access. 
$conn->Open($connstr); 
$rs = new com("ADODB.RecordSet"); 
//Data query and display
$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 to save 
$sql ="insert into szd_t(title)values ('www.jb51.net')"; 
$rs->Open( $sql ); 
echo 'save successfully'; 
//php access database editing
$sql =" Update szd_t set title='jb51.net' where id=".$_GET['id']; 
$rs->Open( $sql ); 
echo 'Edited successfully'; 
/ /Delete data
$sql ="delete from szd_t where id=".$_GET['id']; 

Three ways to connect Access database with php
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.
Thank you party , thank you cctv, thank you search engine, I couldn’t find a good article here, so I will share it with you.
There are three ways to connect to Access in PHP.
(1) Create a system data source and use the ODBC function provided by PHP.
(2) You can also use PHP's ODBC function, but do not create a data source.
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. For different types of databases that the application wants to connect to, an ODBC driver is required. 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.
The ODBC driver manager opens the ODBC driver for the data source and transmits 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. phperz.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: www.phperz.com

Copy code The code is as follows:

 
resourse odbc_connect( string dsn, string user, string password [, int cursor_type]) 
dsn: system dsn name. 
user: username of database server. 
cursor_type: cursor type. 🎜> 
The code is as follows: 

Copy the code

The code is as follows: $connstr="DRIVER=Microsoft Access Driver ( *.mdb);

DBQ=".realpath("bookinfo.mdb");

$connid=odbc_connect($connstr,"","",SQL_CUR_USE_ODBC ); 

 
 (3) Use 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 can be used to access various data sources, including traditional relational databases, email systems, and customized business objects. OLE DB 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 
 ADO technology is based on the Common Object Model (COM), which provides access in multiple languages. Technology. PHP uses the ADO method to manipulate the Access database by pre-defining the class COM. The details of this class are as follows: www.phperz.com 

Copy code

Code 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 
server_name: The name of the DCOM server. 
Codepage: Specify 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: 
[code] 
$conn = new com("ADODB.Connection"); 
$connstr = "DRIVER ={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath("bookinfo.mdb "); 
$conn->Open($connstr); 

This is an article posted by another netizen. After combination, Script House will finally provide a php+access guestbook source code, which you can refer to. Basically, you are familiar with the operation of php access.
Although PHP is rarely used to connect ACCESS, it is quite good to occasionally use it to guide data

Copy the code The code is as follows:

 
/* 
Create ADO connection
*/ 
$conn = @new COM("ADODB.Connection") or die ("ADO Connection failed." ); 
$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath("DATUM/cnbt.mdb"); 
$conn->Open($connstr) ; 
/* 
Create record set query
*/ 
$rs = @new COM("ADODB.RecordSet"); 
$rs->Open("select * from dbo_dirs ",$conn,1,3); 
/* 
Loop to read data
*/ 
while(!$rs->eof){ 
echo "$rs-> ;Fields["title"]->Value; 
echo "
"; 
$rs->Movenext(); //Move the record set pointer down
} 
$rs->close(); 
?> 

Function description and examples
Although PHP is rarely used to link ACCESS, it is occasionally used to guide The data is quite good

PHP ACCESS simple guestbook example source code