php odbc 连接mysql数据库--适用于通达OA2016
来源：互联网 发布：大数据分析和搜索引擎 编辑：程序博客网 时间：2024/05/16 15:52
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"><html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"><head><title>PHP and ODBC: XHTML Example 1</title><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /></head><body><?php$conn = odbc_connect( "DRIVER={MySQL ODBC 3.51 Driver};Server=localhost;Database=phpodbcdb", "username", "password");if (!($conn)) { echo "<p>Connection to DB via ODBC failed: "; echo odbc_errormsg ($conn ); echo "</p>\n";}$sql = "SELECT 1 as test";$rs = odbc_exec($conn,$sql);echo "<table><tr>";echo "<th>Test</th></tr>";while (odbc_fetch_row($rs)) { $result = odbc_result($rs,"test"); echo "<tr><td>$result</td></tr>";}odbc_close($conn);echo "</table>";?></body></html>详细文档介绍：https://www.ibm.com/developerworks/cn/opensource/os-php-odbc/
<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>
http://www.w3school.com.cn/php/php_db_odbc.asphttp://www.w3school.com.cn/php/php_db_odbc.asp 0 0
