search

Home  >  Article  >  Backend Development  >  PHP使用ODBC连接数据库的方法_php技巧

PHP使用ODBC连接数据库的方法_php技巧

WBOY
WBOYOriginal
2016-05-16 20:10:341382browse

本文实例讲述了PHP使用ODBC连接数据库的方法。分享给大家供大家参考。具体实现方法如下：

<!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>
 <&#63;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>";
 &#63;>
 </body>
</html>

希望本文所述对大家的php程序设计有所帮助。

Statement：
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
Previous article：php生成过去100年下拉列表的方法_php技巧Next article：PHP基于文件存储实现缓存的方法_php技巧

Related articles

See more