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

 
  
  
 
 
 <?php
  $conn = odbc_connect(
   "DRIVER={MySQL ODBC 3.51 Driver};Server=localhost;Database=phpodbcdb", 
   "username", "password");
  if (!($conn)) { 
   echo "
Connection to DB via ODBC failed: ";
   echo odbc_errormsg ($conn );
   echo "
\n";
  }
  $sql = "SELECT 1 as test";
  $rs = odbc_exec($conn,$sql);
  echo "";
  echo "";
  while (odbc_fetch_row($rs))
  {
   $result = odbc_result($rs,"test");
   echo "";
  }
  odbc_close($conn);
  echo "
Test
$result
";
 ?>
 

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