PHP mysql_fetch_array() º¯Êý

¶¨ÒåºÍÓ÷¨

mysql_fetch_array() º¯Êý´Ó½á¹û¼¯ÖÐÈ¡µÃÒ»ÐÐ×÷Ϊ¹ØÁªÊý×飬»òÊý×ÖÊý×飬»ò¶þÕß¼æÓÐ

·µ»Ø¸ù¾Ý´Ó½á¹û¼¯È¡µÃµÄÐÐÉú³ÉµÄÊý×飬Èç¹ûûÓиü¶àÐÐÔò·µ»Ø false¡£

Óï·¨

mysql_fetch_array(data,array_type)
²ÎÊý ÃèÊö
data ¿ÉÑ¡¡£¹æ¶¨ÒªÊ¹ÓõÄÊý¾ÝÖ¸Õë¡£¸ÃÊý¾ÝÖ¸ÕëÊÇ mysql_query() º¯Êý²úÉúµÄ½á¹û¡£
array_type

¿ÉÑ¡¡£¹æ¶¨·µ»ØÄÄÖÖ½á¹û¡£¿ÉÄܵÄÖµ£º

  • MYSQL_ASSOC - ¹ØÁªÊý×é
  • MYSQL_NUM - Êý×ÖÊý×é
  • MYSQL_BOTH - ĬÈÏ¡£Í¬Ê±²úÉú¹ØÁªºÍÊý×ÖÊý×é

ÌáʾºÍ×¢ÊÍ

×¢ÊÍ£ºmysql_fetch_array() ÊÇ mysql_fetch_row() µÄÀ©Õ¹°æ±¾¡£³ýÁ˽«Êý¾ÝÒÔÊý×ÖË÷Òý·½Ê½´¢´æÔÚÊý×éÖÐÖ®Í⣬»¹¿ÉÒÔ½«Êý¾Ý×÷Ϊ¹ØÁªË÷Òý´¢´æ£¬ÓÃ×Ö¶ÎÃû×÷Ϊ¼üÃû¡£

Ìáʾ£ºÓкÜÖØÒªµÄÒ»µã±ØÐëÖ¸³ö£¬Óà mysql_fetch_array() ²¢²»Ã÷ÏÔ±ÈÓà mysql_fetch_row() Âý£¬¶øÇÒ»¹Ã÷ÏÔÌṩÁ˸ü¶àµÄÖµ¡£

×¢ÊÍ£º±¾º¯Êý·µ»ØµÄ×Ö¶ÎÃûÊÇÇø·Ö´óСдµÄ¡£

Àý×Ó

<?php
$con = mysql_connect("localhost", "hello", "321");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

$db_selected = mysql_select_db("test_db",$con);
$sql = "SELECT * from Person WHERE Lastname='Adams'";
$result = mysql_query($sql,$con);
print_r(mysql_fetch_array($result));

mysql_close($con);
?>

Êä³öÀàËÆ£º

Array
(
[0] => Adams
[LastName] => Adams
[1] => John
[FirstName] => John
[2] => London
[City] => London
) 
VUE