- <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
- "<a href="http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
- <html xmlns="<a href="http://www.w3.org/1999/xhtml">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>
- //该片段来自于http://www.codesnippet.cn/detail/250420133020.html
来源: http://www.codesnippet.cn/detail/250420133020.html