PHP mysql_fetch_array() º¯Êý
¶¨ÒåºÍÓ÷¨
mysql_fetch_array() º¯Êý´Ó½á¹û¼¯ÖÐÈ¡µÃÒ»ÐÐ×÷Ϊ¹ØÁªÊý×飬»òÊý×ÖÊý×飬»ò¶þÕß¼æÓÐ
·µ»Ø¸ù¾Ý´Ó½á¹û¼¯È¡µÃµÄÐÐÉú³ÉµÄÊý×飬Èç¹ûûÓиü¶àÐÐÔò·µ»Ø false¡£
Óï·¨
mysql_fetch_array(data,array_type)
²ÎÊý | ÃèÊö |
---|---|
data | ¿ÉÑ¡¡£¹æ¶¨ÒªÊ¹ÓõÄÊý¾ÝÖ¸Õë¡£¸ÃÊý¾ÝÖ¸ÕëÊÇ mysql_query() º¯Êý²úÉúµÄ½á¹û¡£ |
array_type |
¿ÉÑ¡¡£¹æ¶¨·µ»ØÄÄÖÖ½á¹û¡£¿ÉÄܵÄÖµ£º
|
ÌáʾºÍ×¢ÊÍ
×¢ÊÍ£º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 )