PHP ???? ?? ??? ???? ?? ??
mysql_query()
mysql_query() ? ??? ?? ???? ?????. ??? ?? ?? ? ? ??????? ??? ????. link_identifier? ???? ?? ?? ????? ?? ??? ?????. ?? ?? ??? ??? ? ???? mysql_connect() ?? ? ???? ?? ? ????? ?????. > ? ???? ?????. ?? ??? ?????.
? ??? sql ?? ???? ? ?????.mysql_fetch_array()
?? ??, ?? ?? ?? ? ?? ?? ?? ?? ???? ??? ?? ???? ??? ??? ????? ? ?? ?? ??? false? ?????. ??: mysql_fetch_array (data,array_type )<解> ??? ??: $ SQL = "SQL ?";
$ info = mysql_qury ($ SQL) // SQL ? ??
$ row = mysql_fetch_array ($ info ($ info ); //SQL ??? ?? ??? ??? ? ?? ??? ????.
??? ??? ????.
<!DOCTYPE html> <html> <head> <meta charset="utf-8"> <title>數(shù)據(jù)表操作 查詢</title> </head> <body> <?php $con = mysql_connect('localhost','root','root') or die('連接服務(wù)器失敗'); mysql_select_db('php') or die('連接數(shù)據(jù)庫失敗'); mysql_set_charset('utf8'); $sql = "select * from `user`"; //查詢數(shù)據(jù)庫user這張表的所有內(nèi)容 $info = mysql_query($sql); //執(zhí)行sqL語句 while($row = mysql_fetch_array($info)){ echo "<pre>"; print_r($row); echo "</pre>"; } ?> </body> </html>mysql_fetch_array()? mysql_fetch_row()? ?? ?????. ???? ?? ???? ??? ???? ? ??? ?? ??? ?? ???? ???? ?? ???? ??? ?? ????.
?: mysql_fetch_array()? ???? ?? mysql_fetch_row()? ???? ??? ?? ??? ??? ?? ? ?? ?? ????? ?? ???? ?? ?????. ??
mysql_fetch_row() ??? ?? ???? ?? ??
??? ??? ????.<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>數(shù)據(jù)表操作 查詢</title>
</head>
<body>
<?php
$con = mysql_connect('localhost','root','root') or die('連接服務(wù)器失敗');
mysql_select_db('php') or die('連接數(shù)據(jù)庫失敗');
mysql_set_charset('utf8');
$sql = "select * from `user`"; //查詢數(shù)據(jù)庫user這張表的所有內(nèi)容
$info = mysql_query($sql); //執(zhí)行sqL語句
while($row = mysql_fetch_row($info)){
echo "<pre>";
print_r($row);
echo "</pre>";
}
?>
</body>
</html>
??: mysql_fetch_row()? ?? ??? ???? ??? ?? ???? ??? ?? ???? ??? ?????. ? ?? ?? ??? 0?? ???? ??? ?? ?????.
mysql_fetch_row()? ???? ???? ?? ??? ?? ?? ????, ?? ? ?? ??? FALSE? ?????.
mysql_result() ??
mysql_result() ??? ?? ??? ?? ?? ?????.
???? ??? ?? ?? ?????. ???? false? ??
??: mysql_result(data, row, field)
??? ??? ????.
????