php odbc 连接mysql数据库--适用于通达OA2016

最新推荐文章于 2022-04-23 15:28:39 发布

hai7425

最新推荐文章于 2022-04-23 15:28:39 发布

阅读量832

点赞数

分类专栏：通达OA sqlserver php学习研究

本文链接：https://blog.csdn.net/hai7425/article/details/70236455

版权

通达OA 同时被 3 个专栏收录

108 篇文章 14 订阅

订阅专栏

php学习研究

107 篇文章 2 订阅

订阅专栏

sqlserver

6 篇文章 0 订阅

订阅专栏

<!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.asp

http://www.w3school.com.cn/php/php_db_odbc.asp

hai7425

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
打赏
0
评论
php odbc 连接mysql数据库--适用于通达OA2016

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> PHP and ODBC: XHTML Example 1 <?php $conn = odbc_connect( "DRIVER={
复制链接

扫一扫