PHP5ºÍMySQLѧϰ 2010.3.2
Ò»ÏîÄ¿¿ª·¢
ÐèÇó·ÖÎö¡¢ÏµÍ³·ÖÎö¡¢ÏµÍ³Éè¼Æ¡¢³ÌÐò¿ª·¢¡¢¼¯³ÉºÍ²âÊÔ
¶þ¡¢ÏîÄ¿·Ö¹¤
³ÌÐòÉè¼Æ¡¢¹²ÓÃ×é¼þÉè¼Æ¡¢Êý¾Ý¿â¡¢ÃÀ¹¤¡¢Îļþ±àд¡¢Êý¾ÝÊäÈë¡¢°²×°Î¬»¤¿Í·þ
Èý¡¢MySQL
Ëٶȿ죬֧³Ö¶àÏß³ÌÓë¶àÓû§Í¬Ê±ÔÚÏߵĹØÏµÊý¾Ý¿â¹ÜÀíϵͳ
»ù±¾µÄMySQLÃüÁîµÄ¼ÇÒä
ËÄ¡¢HTML
»ù±¾htmlµÄÓï¾ä
Ïà¹ØÎĵµ£º
×öÏîĿʱÓÉÓÚÒµÎñÂß¼µÄÐèÒª£¬±ØÐë¶ÔÊý¾Ý±íµÄÒ»Ðлò¶àÐмÓÈëÐÐËø£¬¾Ù¸ö×î¼òµ¥µÄÀý×Ó£¬Í¼Êé½èÔÄϵͳ¡£¼ÙÉè id=1 µÄÕâ±¾Êé¿â´æÎª 1 £¬µ«ÊÇÓÐ 2 ¸öÈËͬʱÀ´½èÕâ±¾Ê飬´Ë´¦µÄÂ߼Ϊ :
Select restnum from book where id =1 ;
-- Èç¹û restnum ´óÓÚ 0 £¬Ö´ÐÐ update
Update boo ......
ÔÚ¹¤×÷ÖÐÅöµ½Ò»¸öMysql×ֶθüÐÂÎÊÌâ
ÔÚcustom±íÖÐÓÐÒ»¸ötariffurlµÄÖµÖÐÓÐÈçÏÂÇé¿ö£º
uploadfiles ariff2007031172720306698.jpgÒÔ¼°uploadfiles ariff2007031172720306690.jpg;uploadfiles ariff2007031172720306691.jpgÐÎʽ
Òª¸ü¸Ä³Éuploadfiles/tariff/200703/1172720306698.jpg¼° uploadfiles/tariff/200703/11727 ......
PerlÖÐDBI¡¢DBD::mysqlÄ£¿éµÄ°²×°
ʹÓõÄÈí¼þ°æ±¾
DBI-1.604.tar.gz
DBD-mysql-4.006.tar.gz
½¨ÒéʹÓÃÒÔÉϰ汾´îÅ䣬·ñÔò¿ÉÄÜÁ¬½Ómysql´íÎó
Ò»¡¢DBIµÄ°²×°
wget http://www.cpan.org/modules/by-module/DBD/DBI-1.604.tar.gz
tar -zxvf DBI-1.604.tar.gz
cd DBI-1.604
perl Makefile.PL ......
Ê×ÏÈÐèÒª²é¿´Ò»Ï´´½¨º¯ÊýµÄ¹¦ÄÜÊÇ·ñ¿ªÆô£º
mysql> show variables like '%func%';
+-----------------------------------------+-------+
| Variable_name   ......
¾³£ÓÐһЩ¾Ñé²»×ãµÄPHP¿ª·¢ÈËÔ±ÔÚFreenodeµÄphp
IRCƵµÀÉÏÎÊÎÊÌâ¡£Èç¹ûÎÊÌâºÜËöË飬»òÕß´ð°¸ÏÔ¶øÒ×¼û£¬»ò±íÏÖµÃÏóÒ»¸ö²ËÄñ£¬ºÜ¿ìËûÃǾͻᷢÏÖ»áÊܵ½ÈçÏÂһЩ»Ø¸´µÄÅں䣺“È¥¶Á¸ÃËÀµÄÊÖ²áÈ¥°É”£¬“ºÃ
ºÃȥѧһѧPHP°É”£¬“ÎÒÃDz»ÊÇÄã¸öÈ˵ĵ¼Ê¦”»ò¸üÖ±½ÓµÄ“ÄãÐèÒª³ÉΪһ¸ö¸üºÃµ ......