PHP和Microsoft Access数据库 - 连接和CRUD [英] PHP and Microsoft Access database - Connection and CRUD
问题描述
我没有访问经验。
如何做更新/插入/删除/选择语句有和没有 $ rs = new com (ADODB.RecordSet);
?
$ rs
行!但如果你想连接& CRUD到使用PHP的MS Access数据库, PDO
。此 PDO简介也值得一看。 <?php
try {
$ dbh = new PDO(odbc:Driver = { Microsoft Access Driver(* .mdb)}; Dbq = C:\accounts.mdb; Uid = Admin);
}
catch(PDOException $ e){
echo $ e-> getMessage();
}
?>
更新:
使用PDO时,可以使您的应用程序更便携,因为它是统一的数据库操作接口,所有你需要做的是提供连接字符串到PDO新实例。因此,您可以连接到MS Access,MySQL,SQLite,Oracle,Informix,DB2等。所有您需要的是安装正确的PDO驱动程序。请看这个例子:
插入操作示例,假设DB文件在 C:\animals.mdb
<?php
try {
// Connect
$ dbh = new PDO(odbc:Driver = { Microsoft Access Driver(* .mdb)}; Dbq = C:\animals.mdb; Uid = Admin);
// INSERT data
$ count = $ dbh-> exec(INSERT INTO animals(animal_type,animal_name)VALUES('kiwi','troy'));
//回显受影响的行数
echo $ count;
//关闭数据库连接
$ dbh = null;
}
catch(PDOException $ e){
echo $ e-> getMessage();
}
?>
我强烈建议您阅读该PDO教程& )如果你不想因为某些原因使用PDO,你可以阅读 ODBC连接
此处。有一个例子:
< html>
< body>
<?php
$ conn = odbc_connect('northwind','','');
if(!$ conn)
exit(Connection Failed:。
$ sql =SELECT * FROM customers;
$ rs = odbc_exec($ conn,$ sql);
if(!$ rs)
exit(SQL中的错误);
echo< table>< tr>;
echo< th>公司名称< / th>;
echo< th>联系人姓名< / th>< / tr>;
while(odbc_fetch_row($ rs)){
$ compname = odbc_result($ rs,CompanyName);
$ conname = odbc_result($ rs,ContactName);
echo< tr>< td> $ compname< / td>;
echo< td> $ conname< / td>< / tr>;
}
odbc_close($ conn);
echo< / table>;
?>
< / body>
< / html>
I have no experience with access.
How to do update/insert/delete/select statement with and without $rs = new com("ADODB.RecordSet");
?
I have no clue about that $rs
line! but if you want to connect & CRUD to a MS Access database using PHP, PDO
is available for you. This PDO Introduction is also worth a look.
<?php
try{
$dbh = new PDO("odbc:Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\accounts.mdb;Uid=Admin");
}
catch(PDOException $e){
echo $e->getMessage();
}
?>
Update:
While using PDO, you can make your application more portable due to it's unified interface for DB operations, All you have to do is providing the Connection String to the PDO new instance. So you can connect to MS Access, MySQL, SQLite, Oracle, Informix, DB2, etc. All you need is to have the correct PDO driver installed. take a look at this examples:
Insert Operation Example, Assuming that the DB file is available in C:\animals.mdb
<?php
try{
// Connect
$dbh = new PDO("odbc:Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\animals.mdb;Uid=Admin");
// INSERT data
$count = $dbh->exec("INSERT INTO animals(animal_type, animal_name) VALUES ('kiwi', 'troy')");
// echo the number of affected rows
echo $count;
// close the database connection
$dbh = null;
}
catch(PDOException $e){
echo $e->getMessage();
}
?>
I strongly recommend you to read that PDO tutorial & you'll be done ;) Also if you don't want to use PDO for some reasons, you can read a guide on ODBC Connections
here. there's an example:
<html>
<body>
<?php
$conn = odbc_connect('northwind','','');
if(!$conn)
exit("Connection Failed: " . $conn);
$sql = "SELECT * FROM customers";
$rs = odbc_exec($conn, $sql);
if(!$rs)
exit("Error in SQL");
echo "<table><tr>";
echo "<th>Companyname</th>";
echo "<th>Contactname</th></tr>";
while(odbc_fetch_row($rs)){
$compname=odbc_result($rs,"CompanyName");
$conname=odbc_result($rs,"ContactName");
echo "<tr><td>$compname</td>";
echo "<td>$conname</td></tr>";
}
odbc_close($conn);
echo "</table>";
?>
</body>
</html>
这篇关于PHP和Microsoft Access数据库 - 连接和CRUD的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!