Community Learn Tools Library Leisure

English

Home > Backend Development > PHP Tutorial > How to connect to access database in php

How to connect to access database in php

WBOY

Release： 2016-07-25 09:13:21

Original

1322 people have browsed it

Share an example of PHP code to connect to access database. There are many ways to connect PHP code to access. Master the usage of these methods through examples.

*/
//Use pdo to connect to the access database
$path ="f:fontbbs.it-home.orgspiderresult.mdb";
$conn = new pdo("sqlite:$path");
if( $conn )
{
echo ('connection pdo success');
}
else
{
echo ('cnnection pdo fail ,plase check database server!');
}
//Use odbc_connect to connect to the database
$conn = odbc_connect("dbdsn","admin","123"); //Connect to the data source
$doquery=odbc_exec( $conn,"select * from table name where condition");//Execute query
//Use the com interface to connect to the access database
$conn=new com("adodb.connection");
$dsn="driver ={microsoft access driver (*.mdb)};dbq=".realpath("path/db1.mdb");
$conn->open($dsn);

Copy code

access, database

Related labels：

php怎么连接access数据库

source：php.cn

Previous article：In-depth analysis of PHP parameter passing principle Next article：Php query by time Mysql common statements

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn