PHP mysqlÊÂÎñ´¦Àí »Ø¹ö²Ù×÷
	
    
    
	MYSQLÖÐÖ»ÓÐINNODBºÍBDBÀàÐ͵ÄÊý¾Ý±í²ÅÄÜÖ§³ÖÊÂÎñ´¦Àí£¡ÆäËûµÄÀàÐÍÊDz»Ö§³ÖµÄ£¡
$lnk = mysql_connect("localhost", "root", "");   
mysql_select_db("test");   
mysql_query("BEGIN");   
$query = mysql_query("INSERT INTO test VALUES(1, 'yangjun')");   
$q1 = mysql_error();   
mysql_query("INSERT INTO test VALUES(1, 'yangjun')");   
$q2 = mysql_error();   
mysql_query("INSERT INTO test VALUES(2, 'Ñî¿¡')");   
$q3 = mysql_error();   
if (!$q1 && !$q2 && !$q3) {   
     mysql_query("COMMIT");  //È«²¿³É¹¦£¬Ìá½»Ö´Ðнá¹û 
} else {   
     mysql_query("ROLLBACK"); //ÓÐÈκδíÎó·¢Éú£¬»Ø¹ö²¢È¡ÏûÖ´Ðнá¹û   
}   
var_dump($q1, $q2, $q3);
    
     
	
	
    
    
	Ïà¹ØÎĵµ£º
        
    
     
 Ò»¸ömysqlµÄÁªºÏ²éѯÁÐ×Ó£¬ºÜ»ù±¾µÄ£¬²»¹ýºÜʵÓá£
ÏÈ¿´Êý¾Ý±í¡£Êý¾Ý±íclass£º
------------------------------- 
id   cname
-------------------------------
1    ÄÐ×°
2    ŮƤ¿ã
3    Å®²ÊÃÞ
-------------------------------
class±í´æ·ÅµÄÊDzúÆ·µÄ´óÀàà ......
	
    
        
    
    ¿´µ½IEÀïÃæÏÔʾ“Á¬½Ó³É¹¦”µÄ»ÃæÊ±£¬ÕæµÄºÜÐË·Ü¡£Á½ÌìµÄŬÁ¦Ã»°×·Ñ¡£
ÏÖÔÚÀ´×ܽáһϣ¬ÔõôÈÃphpÓëMySQLÁ¬½Ó¡£Ìù³öÀ´£¬ÎªºóÀ´Ñ§Ï°µÄÈËÉÙµã×èÁ¦£¡
ÎÒÓõÄÊÇapache+windows+php+MySQL
´óÌå˵À´ÓÐÁ½ÖÖ·½Ê½£¬Ò»ÖÖÊǾɵÄÃæÏò¶Ô¹ý³ÌµÄ·½Ê½£¬ÐèÒª×°ÔØphp_mysql.dll£»ÁíÒ»ÖÖÊÇеÄÃæÏò¶ÔÏóµÄ·½Ê½£¬ÐèÒª×°ÔØphp_mysql ......
	
    
        
    
    1.show status
   Threads_connected  µ±Ç°µÄÁ¬½ÓÊý
   Connections  ÊÔͼÁ¬½Óµ½(²»¹ÜÊÇ·ñ³É¹¦)MySQL·þÎñÆ÷µÄÁ¬½ÓÊý¡£
   Max_used_connections  ·þÎñÆ÷Æô¶¯ºóÒѾͬʱʹÓõÄÁ¬½ÓµÄ×î´óÊýÁ¿¡£
2.set GLOBAL max_connections=Á¬½ÓÊý; 
   flush privilege ......
	
    
        
    
     ¡¶mysql Óë php »ù´¡½Ì³Ì¡·
1. Îı¾º¯Êý
º¯Êý
Ó÷¨
ÓÃ;
CONCAT()
CONCAT(x,y,...)
´´½¨ÐÎÈçxyµÄÐÂ×Ö·û´®
CONCAT_WS()
CONCAT_WS(separator,column1,column2,...)
·Ö¸ô·û½«²åÈëËùÁгöµÄÿ¸öÁÐÖ®¼ä
LENGTH()
LENGTH(column)
·µ»ØÁÐÖд洢µÄ×Ö·û´®µÄ³¤¶È
LEFT()
LEFT(colum,x)
´ÓÁеÄÖµÖзµ»Ø×î×ó±ßµÄx ......
	
    
        
    
     
PHP trim() º¯Êý
¶¨ÒåºÍÓ÷¨
trim() º¯Êý´Ó×Ö·û´®µÄÁ½¶Ëɾ³ý¿Õ°××Ö·ûºÍÆäËûÔ¤¶¨Òå×Ö·û¡£
Óï·¨
trim(str,charlist)
 ²ÎÊý 1 strΪ´ý²Ù×÷µÄ×Ö·û´®£¬²ÎÊý 2 charlist ¿ÉÑ¡£¬Ö¸¶¨ÁËÏëҪȥ³ýµÄÌØÊâ·ûºÅ¡£
Èç¹ûµÚ¶þ¸ö²ÎÊýû¸øÖµ£¬Ô¤Éè»áÈ¥³ýÏÂÁÐÕâЩ×ÖÔª£º 
" " (ASCII 32&nbs ......