//创建一个mysql连接
if(!$linkID){
echo "<font color=‘red‘>unable to connect!</font>";
}
mysql_select_db($db)or die("unable to select database"); //选择一个数据库
$SQL_SELECT_SYMBOLS="select * from symbols";
$result=mysql_query($SQL_SELECT_SYMBOLS)or die("error in query :$query. ".mysql_errno()); //执行SQL语句
if(mysql_num_rows($result)>0){
echo ‘<table cellpadding="10" border="1">‘;
echo ‘<tr><th>id</th><th>country</th><th>animal</th><th>cname</th></tr>‘;
while($obj=mysql_fetch_object($result)){
echo "<tr>";
echo "<td>".$obj->id."</td>";
echo "<td>".$obj->country."</td>";
echo "<td>".$obj->animal."</td>";
echo "<td>".$obj->cname."</td>";
echo "</tr>";
}
echo "</table>";
}
else{
echo "记录未找到!";
}
mysql_free_result($result); //释放记录集所占用的内存
mysql_close($linkID); //关闭数据库连接
?>
php示例代码之使用mysql_fetch_object函数
标签：