PHP中MySql函數收集

標籤：

1.array mysql_fetch_assoc ( resource $result ) 從結果集中取得一行作為關聯陣列

說明：

　　 返回對應結果集的關聯陣列，並且繼續移動內部資料指標。

參數：result

　　  resource 型的結果集。此結果集來自對 mysql_query() 的調用。

執行個體：

<?php $conn  =  mysql_connect ( "localhost" ,  "mysql_user" ,  "mysql_password" ); if (! $conn ) {    echo  "Unable to connect to DB: "  .  mysql_error ();    exit;}  if (! mysql_select_db ( "mydbname" )) {     echo  "Unable to select mydbname: "  .  mysql_error ();    exit;} $sql  =  "SELECT id as userid, fullname, userstatus         FROM   sometable        WHERE  userstatus = 1" ; $result  =  mysql_query ( $sql ); if (! $result ) {    echo  "Could not successfully run query ( $sql ) from DB: "  .  mysql_error ();    exit;} if ( mysql_num_rows ( $result ) ==  0 ) {    echo  "No rows found, nothing to print so am exiting" ;    exit;} // While a row of data exists, put that row in $row as an associative array// Note: If you‘re expecting just one row, no need to use a loop// Note: If you put extract($row); inside the following loop, you‘ll//       then create $userid, $fullname, and $userstatus while ( $row  =  mysql_fetch_assoc ( $result )) {    echo  $row [ "userid" ];    echo  $row [ "fullname" ];    echo  $row [ "userstatus" ];} mysql_free_result ( $result ); ?> 

 

PHP中MySql函數收集