PHP²Ù×÷MySQLµÄº¯Êý
(1)mysql_connect(Ö÷»ú,Óû§Ãû,¿ÚÁî);
·µ»ØÒ»¸öÁ¬½ÓºÅ.
×¢Òâ:mysql¸÷Óû§µÄ¿ÚÁî¿ÉÒÔËæ¸ÃÓû§ËùÔÚ»úÆ÷IPµØÖ·²»Í¬¶ø¸Ä±ä. ÁíÍâ,mSQLûÓÐÓû§Ãû»úÖÆ,ËùÒÔmsql_connectÖ»ÐèÒªÒ»¸öÖ÷»ú²ÎÊý.Ö÷»ú¿ÉÒÔÊÇIPµØÖ·»òÓòÃû.
(2)mysql_create_db(Êý¾Ý¿âÃû);
(3)mysql_select_db(Êý¾Ý¿âÃû,Á¬½ÓºÅ);
Á¬½ÓÒ»¸öÊý¾Ý¿â.
(4)mysql_query(SQLÓï¾ä,Á¬½ÓºÅ);
Èç¹ûSQLÓï¾äÊÇselect,Ôò·µ»ØÒ»¸ö½á¹ûºÅ.·ñÔò·µ»ØµÄÖµ¿ÉÒÔ²»Àí»á. Èç¹ûʧ°Ü,·µ»Øfalse.
(5)mysql_fetch_array(½á¹ûºÅ);
È¡³öÏÂÒ»ÐÐ,·µ»ØÒ»¸öÊý×é.¿ÉÒÔÓÃÊý×Öϱê·ÃÎÊ(µÚÒ»¸ö×Ö¶ÎÊÇϱê0),Ò²¿ÉÒÔÓÃ×Ö·û´®Ï±ê·ÃÎÊ(¼´Ê¹Óø÷×Ö¶ÎÃû). ÈçÒÑÈ¡ÁË×îºóÒ»ÐÐ,·µ»Øfalse.
(6)mysql_fetch_field(½á¹ûºÅ,[×Ö¶ÎÐòºÅ]);
ÈçÎÞ×Ö¶ÎÐòºÅ,È¡ÏÂÒ»¸ö×Ö¶Î.·µ»ØÒ»¸ö¹þÏ£±í,ϱêÓÐ:
name,table,max_length,not_null,primary_key,unique_key,multiple_key,numeric,blob,type,unsigned,zerofill
¸÷ϱêµÄÒâ˼Ӧ¸Ã±È½ÏÃ÷°×ÁË.
(7)mysql_num_rows(½á¹ûºÅ);mysql_num_fields(½á¹ûºÅ);
(8)mysql_free_result(½á¹ûºÅ);
(9)mysql_list_dbs();mysql_list_tables(Êý¾Ý¿âÃû);
(10)mysql_close(Á¬½ÓºÅ);
(11)mysql_pconnect(Ö÷»ú,Óû§Ãû,¿ÚÁî);
(12)mysql_select_db(Êý¾Ý¿âÃû,Á¬½ÓºÅ);
Á¬½ÓÒ»¸öÊý¾Ý¿â.
Óëmysql_connectÍêÈ«ÏàËÆ,µ«½¨Á¢Ò»¸ö"ÓÀ¾ÃÁ¬½Ó",¸ÃÁ¬½ÓÒ»¾½¨Á¢ÓÀ²»¹Ø±Õ,¼´Ê¹Ê¹ÓÃmysql_closeº¯Êý»ò³ÌÐòÖ´ÐÐÍê±ÏÒ²²»¹Ø±Õ.ÏÂÒ»´ÎÊÔͼ½¨Á¢ÓÀ¾ÃÁ¬½Óʱ,ϵͳÈç·¢ÏÖÒÑ´æÔÚÒ»¸öÓÀ¾ÃÁ¬½Ó,ÔòÖ±½Ó·µ»Ø¸ÃÁ¬½ÓºÅ¶ø²»ÖØÐ´´½¨.
×¢Òâ:MySQL·ÃÎʺ¯Êý¶¼ÐèÒªÓÐÏàÓ¦µÄȨÏÞ²ÅÄÜÔËÐÐ
Ïà¹ØÎĵµ£º
<?php
function getmicrotime(){
list($usec, $sec) = explode(" ",microtime());
return ((float)$usec + (float)$sec);
}
//Àý×Ó
//¿ªÊ¼
$time_start = getmicrotime();
//ÕâÀï·ÅÄãµÄ´úÂë
......
ת×Ô: http://www.phpweblog.net/lemon2maple/archive/2007/07/29/1397.html
mysqlµÄ³ö´í´úÂë±í£¬¸ù¾ÝmysqlµÄÍ·Îļþmysql/include/mysqld_error.hÕûÀí¶ø³É¡£´íÎóÖ®´¦£¬Çë´ó¼ÒÖ¸Õý¡£
1005£º´´½¨±íʧ°Ü
1006£º´´½¨Êý¾Ý¿âʧ°Ü
1007£ºÊý¾Ý¿âÒÑ´æÔÚ£¬´´½¨Êý¾Ý¿âʧ°Ü
1008£ºÊý¾Ý¿â²»´æÔÚ£¬É¾³ýÊý¾Ý¿âʧ°Ü
1009£º²»ÄÜɾ³ýÊý¾ ......
Íü¼ÇMySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)
ROOTÃÜÂëÊÇÔÚMySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)ʹÓÃÖкܳ£¼ûµÄÎÊÌ⣬¿ÉÊÇÓкܶàÅóÓѲ¢²»»áÖØÖÃROOTÃÜÂ룬Äǽпడ£¬ÎÒÓÐÉîÓид¥£¬ÌØÐ´´ËÎÄÕÂÓë´ó¼Ò½»Á÷£º
1¡¢±à¼MySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)ÅäÖÃÎļþ£º
windows»·¾³ÖУº%MySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)_installdir%\my.ini¡¡//Ò»°ã ......
£¨1£©ÒÔubuntuµÄrootÓû§µÇ½
£¨2£©Í£Ö¹MYSQL·þÎñÆ÷£º
/etc/init.d/mysql stop
£¨3£©Ìø¹ýÊÚȨ±íÖ´ÐÐMYSQL·þÎñÆ÷£º
mysqld_safe --skip-grant-tables --skip-networking &
(×¢£º²ÎÊý--skip-grant-tablesÎªÌø¹ýÊÚȨ±í£»--sk ......
Íâ¼üµÄʹÓÃÌõ¼þ£º
1.Á½¸ö±í±ØÐëÊÇInnoDB±í£¬MyISAM±íÔÝʱ²»Ö§³ÖÍâ¼ü£¨¾Ý˵ÒÔºóµÄ°æ±¾ÓпÉÄÜÖ§³Ö£¬µ«ÖÁÉÙĿǰ²»Ö§³Ö£©£»
2.Íâ¼üÁбØÐ뽨Á¢ÁËË÷Òý£¬MySQL 4.1.2ÒÔºóµÄ°æ±¾ÔÚ½¨Á¢Íâ¼üʱ»á×Ô¶¯´´½¨Ë÷Òý£¬µ«Èç¹ûÔÚ½ÏÔçµÄ°æ±¾ÔòÐèÒªÏÔʾ½¨Á¢£»
3.Íâ¼ü¹ØÏµµÄÁ½¸ö±íµÄÁбØÐëÊÇÊý¾ÝÀàÐÍÏàËÆ£¬Ò²¾ÍÊÇ¿ÉÒÔÏ໥ת»»ÀàÐ͵ ......