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

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³£ÓÃÄÚÖó£Á¿

ϵͳÉè¼Æ´ÓÒ»¿ªÊ¼¾ÍÓ¦¸Ã¿¼ÂDz»Í¬Æ½Ì¨µÄ¼æÈÝÐÔÎÊÌ⣬×î³£¼ûÒ»¸öÎÊÌâ¾ÍÊÇLinux/uniuxÓëWinµÄһЩ²»Í¬£¬±ÈÈç˵Îļþ·¾¶·Ö¸ô·û¡¢¶à¸ö·¾¢·Ö¸ô·ûµÈµÈ¡£PHP±¾ÉíÄÚÖÃÁ˺ܶೣÁ¿£¬ÔÚ·½±ãµÄ±àд´úÂëͬʱҲºÜºÃµÄ´¦ÀíºÃÁ˲»Í¬Æ½Ì¨ÏµÄһЩ¼æÈÝÐÔÎÊÌâ¡£±ÈÈç×î³£Óõģº
DIRECTORY_SEPARATOR    ·¾¶·Ö¸ô·û£¬WinÏÂÊÇ"\"¶ ......

¡¾Õª×ÔCSDNÂÛ̳¡¿mysqlÃüÁîÐг£ÓÃÃüÁî

mysqlÃüÁîÐг£ÓÃÃüÁî
µÚÒ»ÕС¢mysql·þÎñµÄÆô¶¯ºÍÍ£Ö¹
net stop mysql
net start mysql
µÚ¶þÕС¢µÇ½mysql
Óï·¨ÈçÏ£º mysql -uÓû§Ãû -pÓû§ÃÜÂë
¼üÈëÃüÁîmysql -uroot -p£¬ »Ø³µºóÌáʾÄãÊäÈëÃÜÂ룬ÊäÈë12345£¬È»ºó»Ø³µ¼´¿É½øÈëµ½mysqlÖÐÁË£¬mysqlµÄÌáʾ·ûÊÇ£º
mysql>
×¢Ò⣬Èç¹ûÊÇÁ¬½Óµ½ÁíÍâµÄ»úÆ÷ÉÏ£¬ÔòÐèÒª¼ ......

ÈçºÎÐÞ¸Ämysql rootÃÜÂë

   Íü¼ÇMySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)
ROOTÃÜÂëÊÇÔÚMySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)ʹÓÃÖкܳ£¼ûµÄÎÊÌ⣬¿ÉÊÇÓкܶàÅóÓѲ¢²»»áÖØÖÃROOTÃÜÂ룬Äǽпడ£¬ÎÒÓÐÉîÓид¥£¬ÌØд´ËÎÄÕÂÓë´ó¼Ò½»Á÷£º
1¡¢±à¼­MySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)ÅäÖÃÎļþ£º
windows»·¾³ÖУº%MySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)_installdir%\my.ini¡¡//Ò»°ã ......

10¶ÎPHP³£Óù¦ÄÜ´úÂë

1¡¢Ê¹ÓÃPHP Mailº¯Êý·¢ËÍEmail
$to = "viralpatel.net@gmail.com";  
$subject = "VIRALPATEL.net";  
$body = "Body of your message here you can use HTML too. e.g. ﹤br﹥ ﹤b﹥ Bold ﹤/b﹥";  
$headers = "from: Peter\r\n"; &nbs ......

PHPÖÐdateº¯ÊýµÄÑ¡Ïî˵Ã÷

date() ½«·þÎñÆ÷µÄʱ¼ä¸ñʽ»¯
Óï·¨ÃèÊöΪstring date(string format,int[timestamp]);·µ»ØÖµµÄÊý¾ÝÀàÐÍÊÇ×Ö·û´®¡£
º¯Êý˵Ã÷£º·µ»ØÖµµÄ×Ö·û´®°´ÅäÖõĸñʽ¾ö¶¨¡£
×Ö·û´®¸ñʽ»¯µÄÑ¡ÏîÈçÏ£º
a: "am"»òÊÇ"pm"
A: "AM"»òÊÇ"PM"
d: ¼¸ÈÕ£¬Á½Î»Êý×Ö£¬Èô²»×ãÔò²¹Á㣻´Ó"01"ÖÁ"31"
D: ÐÇÆÚ¼¸£¬3¸öÓ¢ÎÄ×Öĸ£¬Èç:"Fri" ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ