Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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


Ïà¹ØÎĵµ£º

mysql Íü¼ÇROOTÃÜÂëµÄ¼òµ¥½â¾ö·½°¸

1.Í£µômysqld
  service mysqld stop
2.ÖØÆômysqld£¬Ö¸¶¨²ÎÊý
  service mysqld start --skip-networking --skip-grant-tables
  »òÕß
  /opt/mysql/bin/mysqld_safe --skip-networking --skip-grant-tables &
  /opt/mysql/ÊÇÎÒµÄMYSQL°²×°Â·¾¶
  skip-grant-tables:Á¬½ÓÊ±Ìø¹ýÊ ......

Linuxϰ²×°MySQLÊý¾Ý¿â¹¥ÂÔ

1.MySQL¼ò½é
   MySQLÊÇÒ»¸ö¹ã·ºÊ¹ÓõĽṹ»¯²éѯÓïÑÔ£¨SQL£©Êý¾Ý¿â·þÎñÆ÷¡£ºÍÆäËûSQL·þÎñÆ÷Ò»Ñù£¬MySQLÌṩÁË·ÃÎʺ͹ÜÀíSQLÊý¾Ý¿âµÄ·½·¨£¬µ«ÊÇ£¬MySQLͬʱҲÌṩÁË´´½¨Êý¾Ý¿â½á¹¹ÒÔ¼°ÔÚÕâЩ½á¹¹ÖÐÌí¼Ó¡¢Ð޸ĺÍɾ³ýÕâЩ½á¹¹µÄ¹¤¾ß¡£
   MySQLÊý¾Ý¿âÏà¹ØµÄÈí¼þ°üÖ÷ÒªÓÐÒÔϼ¸ÖÖ£º
   ......

¡¾×ª¡¿mysqlÏÂÈçºÎÖ´ÐÐsql½Å±¾

Ê×Òª²½Öè(Ò»°ã¿ÉÊ¡ÂÔ):
¿ªÆômysql·þÎñ(ĬÈÏÊÇ¿ª»úʱ¾Í×Ô¶¯ÔËÐÐÁË):
¿ØÖÆÃæ°å
-->¹ÜÀí¹¤¾ß-->·þÎñ,ÔÚÀïÃæÕÒµ½Ãû³ÆÎªmysqlµÄÏî,Ë«»÷¾Í¿É¿´ËüµÄ·þÎñ״̬ÊÇÆô¶¯»¹ÊÇÍ£Ö¹,°ÑËüÉèΪÆô¶¯
Á¬½Ómysql:
ÔÚÃüÁîÐÐÏÂÊäÈë mysql -h
localhost -u root -p»Ø³µ,È»ºóÊäÈëÃÜÂë¼´¿É;»òÖ±½ÓÔËÐÐmysql×Ô´øµÄÁ¬½Ó¹¤¾ß,È»ºóÊäÈëÃÜÂë¼ ......

PHP±éÀú¶àάÊý×麯Êý

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];
}
} ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ