PHP读åMySQLæ°æ®æå¦ä¸æ¹æ³ï¼
æ¹æ³ä¸ï¼
<?
$rs = mysql_query($q, $dbh);
while($row = mysql_fetch_array($rs)) echo "$row[id] $row[name] <br />";
/* idånameå¯ä»¥æ¢ä½ç½® */
@mysql_close($dbh);
/* å
³éå°mysqlæ°æ®åºçè¿æ¥ */
?>
æ¹æ³äºï¼
<?
$rs = mysql_query($q, $dbh);
while($row = mysql_fetch_object($rs)) echo "$row->id $row->name <br />";
/* idånameå¯ä»¥æ¢ä½ç½® */
?>
æ¹æ³ä¸ï¼
<?
$rs = mysql_query($q, $dbh);
/* å®ä¹åé rs ,å½æ°mysql_query()çæææ¯:éåº query åä¸²ä¾ MySQL åç¸å
³çå¤çæè
æ§è¡.ç±äºphpæ¯ä»å³å¾å·¦æ§è¡ç
,æ以,rsçå¼æ¯æå¡å¨è¿è¡mysql_query()å½æ°åè¿åçå¼ */
if(!$rs){die("Valid result!");}
echo "<table>";
echo "<tr><td>ID</td><td>Name</td></tr>";
while($row = mysql_fetch_row($rs)) echo "<tr><td>$row[0]</td><td>$row[1]</td></tr>";
/* å®ä¹éå(æ°ç»)row,并å©ç¨while循ç¯,ææ°æ®ä¸ä¸ååºæ¥.
å½æ°mysql_fetch_row()çæææ¯:å°æ¥è¯¢ç»æ$rsååæå°éµååæ°ä¸.
$row[0] å $row[1] çä½ç½®å¯ä»¥æ¢*/
echo "</table>";
?>
æ»ç»ï¼æ¹æ³ä¸æ¯æçæé«çï¼æ¨èæ¥å¸¸ä½¿ç¨ã
温馨提示:内容为网友见解,仅供参考