array mysql_fetch_assoc (resource $Result_Set ) |
{-范例代码如下--} |
<?php |
$UserName = 'abc' ; |
$Password = '1234' ; |
$DbHandle = mysql_connect ( 'localhost' , $UserName , $Password ); |
if (! $DbHandle ) { |
die 'No database connection could be established.' ; |
} |
$DBName = 'w3db' ; |
if (!mysql_select_db ( $DBName , $DbHandle )) { |
die 'Database could not be selected.' ; |
} |
$Query = "SELECT ISBN, Title, Author FROM articles" ; |
$articles = mysql_query ( $Query , $DbHandle )); |
while ( $Row = mysql_fetch_assoc ( $articles )) { |
echo "ISBN = $Row['ISBN']<br />\n" ; |
echo "Title = $Row['Title']<br />\n" ; |
echo "Author = $Row['Author']<br />\n" ; |
} |
?> |