PHP·ÃÎÊMySQLÊý¾Ý¿â
PHPÊÖ²áÉÏÌṩÁËÒÔÏÂһЩÖ÷ÒªµÄmysqlÊý¾Ý¿âµÄÖ§³Öº¯Êý£º
mysql_affected_rows -- È¡µÃÇ°Ò»´Î MySQL ²Ù×÷ËùÓ°ÏìµÄ¼Ç¼ÐÐÊý
mysql_change_user -- ¸Ä±ä»î¶¯Á¬½ÓÖеǼµÄÓû§
mysql_client_encoding -- ·µ»Ø×Ö·û¼¯µÄÃû³Æ
mysql_close -- ¹Ø±Õ MySQL Á¬½Ó
mysql_connect -- ´ò¿ªÒ»¸öµ½ MySQL ·þÎñÆ÷µÄÁ¬½Ó
mysql_create_db -- н¨Ò»¸ö MySQL Êý¾Ý¿â
mysql_data_seek -- Òƶ¯ÄÚ²¿½á¹ûµÄÖ¸Õë
mysql_db_name -- È¡µÃ½á¹ûÊý¾Ý
mysql_db_query -- ·¢ËÍÒ»Ìõ MySQL ²éѯ
mysql_drop_db -- ¶ªÆú£¨É¾³ý£©Ò»¸ö MySQL Êý¾Ý¿â
mysql_errno -- ·µ»ØÉÏÒ»¸ö MySQL ²Ù×÷ÖеĴíÎóÐÅÏ¢µÄÊý×Ö±àÂë
mysql_error -- ·µ»ØÉÏÒ»¸ö MySQL ²Ù×÷²úÉúµÄÎı¾´íÎóÐÅÏ¢
mysql_escape_string -- תÒåÒ»¸ö×Ö·û´®ÓÃÓÚ mysql_query
mysql_fetch_array -- ´Ó½á¹û¼¯ÖÐÈ¡µÃÒ»ÐÐ×÷Ϊ¹ØÁªÊý×飬»òÊý×ÖÊý×飬»ò¶þÕß¼æÓÐ
mysql_fetch_assoc -- ´Ó½á¹û¼¯ÖÐÈ¡µÃÒ»ÐÐ×÷Ϊ¹ØÁªÊý×é
mysql_fetch_field -- ´Ó½á¹û¼¯ÖÐÈ¡µÃÁÐÐÅÏ¢²¢×÷Ϊ¶ÔÏó·µ»Ø
mysql_fetch_lengths -- È¡µÃ½á¹û¼¯ÖÐÿ¸öÊä³öµÄ³¤¶È
mysql_fetch_object -- ´Ó½á¹û¼¯ÖÐÈ¡µÃÒ»ÐÐ×÷Ϊ¶ÔÏó
mysql_fetch_row -- ´Ó½á¹û¼¯ÖÐÈ¡µÃÒ»ÐÐ×÷Ϊö¾ÙÊý×é
mysql_field_flags -- ´Ó½á¹ûÖÐÈ¡µÃºÍÖ¸¶¨×ֶιØÁªµÄ±êÖ¾
mysql_field_len -- ·µ»ØÖ¸¶¨×ֶεij¤¶È
mysql_field_name -- È¡µÃ½á¹ûÖÐÖ¸¶¨×ֶεÄ×Ö¶ÎÃû
mysql_field_seek -- ½«½á¹û¼¯ÖеÄÖ¸ÕëÉ趨ΪÖƶ¨µÄ×Ö¶ÎÆ«ÒÆÁ¿
mysql_field_table -- È¡µÃÖ¸¶¨×Ö¶ÎËùÔڵıíÃû
mysql_field_type -- È¡µÃ½á¹û¼¯ÖÐÖ¸¶¨×ֶεÄÀàÐÍ
mysql_free_result -- ÊͷŽá¹ûÄÚ´æ
mysql_get_client_info -- È¡µÃ MySQL ¿Í»§¶ËÐÅÏ¢
mysql_get_host_info -- È¡µÃ MySQL Ö÷»úÐÅÏ¢
mysql_get_proto_info -- È¡µÃ MySQL ÐÒéÐÅÏ¢
mysql_get_server_info -- È¡µÃ MySQL ·þÎñÆ÷ÐÅÏ¢
mysql_info -- È¡µÃ×î½üÒ»Ìõ²éѯµÄÐÅÏ¢
mysql_insert_id -- È¡µÃÉÏÒ»²½ INSERT ²Ù×÷²úÉúµÄ ID
mysql_list_dbs -- Áгö MySQL ·þÎñÆ÷ÖÐËùÓеÄÊý¾Ý¿â
mysql_list_fields -- Áгö MySQL ½á¹ûÖеÄ×Ö¶Î
mysql_list_processes -- Áгö MySQL ½ø³Ì
mysql_list_tables -- Áгö MySQL Êý¾Ý¿âÖеıí
mysql_num_fields -- È¡µÃ½á¹û¼¯ÖÐ×ֶεÄÊýÄ¿
mysql_num_rows -- È¡µÃ½á¹û¼¯ÖÐÐеÄÊýÄ¿
mysql_pconnec
Ïà¹ØÎĵµ£º
ÏÈ×¼±¸ºÃÈí¼þ£º
·Ö±ðÔÚApache¹Ù·½¡¢php¹Ù·½¡¢mysql¹Ù·½ÏÂÔØ×îлòÎȶ¨°æ±¾
Ò»¡¢°²×°Apache£¬ÅäÖóɹ¦Ò»¸öÆÕͨÍøÕ¾·þÎñÆ÷
ÔËÐÐÏÂÔغõēapache_2.0.55-win32-x86-no_ssl.msi”£¬³öÏÖÈçϽçÃ棺
³öÏÖApache HTTP Server 2.0.55µÄ°²×°Ïòµ¼½çÃ棬µã“Next”¼ÌÐø
È·È ......
http://javeye.javaeye.com/blog/558093
ÎÒÃÇÖªµÀ£¬group by¿ÉÒÔ½«sql²éѯ½á¹û°´ÕÕgroup byºóÃæÁнøÐзÖÀàÏÔʾ¡£±ÈÈ磺
Sql´úÂë
select
columnA,columnB
from
table
group
by
columnA,columnB
select columnA,columnB from table group by columnA,colum ......
½ñÌìµ½mysqlÍøÕ¾¿´¿´·¢ÏÖûÓÐÁËsun LOGO£¬Ò²ÕÒ²»µ½mysql downloadsÏÂÔØÁ´½Ó
ÒªÊÖ¹¤´òÈëhttp://dev.mysql.com²ÅÐУ¬²»½ûÉÁ¹ýһ˿Á¹Ò⣬ÒÔÇ°¼á³ÖʹÓÃmysqlÏÖÔÚ»¹Òª¼á³ÖÂð£¬
ÒÔÇ°ÐÄÀïÒ»Ö±ÔÚÏëÒ»Ö±»áʹÓÃmysqlµÄ£¬µ«ÊÇÏÖÔڸоõµ½ºÜʧÍû£¬´ìÕÛ£¬½¹ÂÇ£¬²»ÖªÒÔºó»áÔõôÑù
×Ô¼º¼¸ÄêÀ´Ò»Ö±Ê¹ÓÃLAMP×éºÏ£¬ÖªÊ¶¶¼ÊÇÊÇΧÈÆ×ÅÕâ¸ö×éºÏ ......
function handleEach(&$array,$functionName)
{
foreach($array as $k=>$v)
{
if(is_array($v))
{
handleEach(&$array[$k],$functionName);
}
else
$array[$k] = $functionName($v);
return $array[$k];
}
} ......