php ODBC 示例
<html><body>
<?php
$conn=odbc_connect('ktv','','');
if (!$conn){
exit("Connection Failed: " . $conn);
}
$sql="SELECT * FROM tb_authorinfo";
$rs=odbc_exec($conn,$sql);
if (!$rs){
exit("Error in SQL");
}
echo "<table><tr>";
echo "<th>ID</th><th>Name</th><th>Sex</th><th>Birthday</th><th>Genre</th><th>Company</th><th>Recma</th><th>zjm</th><th>DateTime</th>";
echo "</tr>";
while (odbc_fetch_row($rs)){
$id=odbc_result($rs,"authorId");
$name=odbc_result($rs,"authorName");
$sex=odbc_result($rs,"authorSex");
$birthday=odbc_result($rs,"authorbirthday");
$genre=odbc_result($rs,"authorGenre");
$company=odbc_result($rs,"authorcompany");
$recma=odbc_result($rs,"authorRecma");
$zjm=odbc_result($rs,"authorzjm");
$datetime=odbc_result($rs,"RdateTime");
echo "<tr><td>$id</td><td>$name</td><td>$sex</td><td>$birthday</td><td>$genre</td><td>$company</td><td>$recma</td><td>$zjm</td><td>$datetime</td>";
echo "</tr>";
}
odbc_close($conn);
echo "</table>";
?>
</body>
</html>
结果如下：
IDNameSexBirthdayGenreCompanyRecmazjmDateTimeAU-4122007110244张男2007-12-04 11:11:33大陆武打
Z2007-12-04 11:47:45AU-10122007115114小星男1789-12-10 11:51:14海外喜剧无XX2007-12-10 11:51:50AU-10122007131630小李女2007-12-10 13:16:30大陆经典无XL2007-12-10 13:16:44
页:
[1]