PHPÊý¾Ý¿âÊÂÎñ´¦Àí
ÔÚʹÓÃphpÖÐʹÓÃÊý¾Ý¿âÊÂÎñ´¦Àí²¢²»¸´ÔÓ£¬Ö÷ÒªÓõ½µÄÊÇmysqliÀàµÄ3¸ö³ÉÔ±º¯Êý¡£
£¨1£©autocommit£¨bool mode£©£¬ÉèÖÃÊý¾Ý¿â×Ô¶¯Ìύ״̬¡£µ±modeΪTRUEʱ£¬´ò¿ª×Ô¶¯Ìá½»ÉèÖ㬵±modeΪFASLEʱ£¬¹Ø±Õ×Ô¶¯ÉèÖá£Ëùν×Ô¶¯Ìá½»£¬¾ÍÊÇMYSQLÿִÐÐÒ»ÌõSQLÓï¾ä£¬¸ÃSQLÓï¾äµÄÖ´Ðнá¹ûÂíÉÏÉúЧ¡£¶ø·Ç×Ô¶¯Ìύʱ£¬ÔòÖ´Ðнá¹ûÒªÒ»Ö±µ½commit£¨£©Óï¾ä±»Ö´ÐÐʱÉúЧ£¬»òÕßµ½rollback£¨£©Óï¾ä±»Ö´ÐÐʱִÐнá¹û±»È¡Ïû£¬Êý¾Ý¿â»Ø¸´µ½µ±Ç°ÊÂÎñ֮ǰµÄ״̬¡£ÁíÍ⣬±¾º¯ÊýÖ»Ó°Ï쵱ǰÊý¾Ý¿âÁ¬½Ó¼ä·¢ÉúµÄÊý¾Ý¿â²Ù×÷£¬¼´ÔÚÒ»ÏÂÒ»Êý¾Ý¿âÁ¬½Ó½¨Á¢Ö®ºó£¬×Ô¶¯Ìύ״̬½«¸´³ÉMysqlÊý¾Ý¿âÄÚ²¿µÄÉèÖá£
£¨2£©commit(),Ìá½»µ±Ç°ÊÂÎñµÄÖ´Ðнá¹û¡£
£¨3£©rollback£¨£©£¬È¡Ïûµ±Ç°ÊÂÎñµÄÖ´Ðнá¹û¡£
PHPÖÐʹÓÃÊÂÎñ´¦ÀíµÄ´úÂë¿ò¼ÜÈçÏÂËùʾ£º
<?php
$conn=db_connect();//Á¬½ÓÊý¾Ý¿â¸Ãº¯ÊýΪÁíÍⶨÒåµÄ¡£
$conn->autocommit(FALSE);
$rsl = $conn->query($sql1);
$rs2 = $conn->query($sql2);
...
$rsn= $conn->query($sqln);
if($rs1&&$rs2&&...&$sqln)
$conn->commit();
else
$conn->rollback();
$conn->close();
?>
Ïà¹ØÎĵµ£º
˵¾äʵ»°,дÕâ¸öÕæ¹»ÎÞÁĵÄ.±¾À´¿´ÁËijλ´óϺµÄÀàËÆÎÄÕÂ,¸¹·ÌÁ˼¸¾äÒ²¾ÍËãÁË.µ«ÊÇ×òÌìÍíÉÏÓиö¿Í»§ÄÃ×ÅÕâÆªÎÄÕÂÎÊÎÒ: ÄãѾµÄ×Ô¼º×ö
Íâ°ü,ÄãË㼸¶ÎPHPer?Ëì¸Ð¾õÄÇÆªÎÄÕ¶ÔijЩ°ëͨ²»Í¨Ö®È˵ÄÎóµ¼Ö®Éî.ÎÞ·¨,Ö»ÓÐд´ËÎÄÕ±íÃ÷ÎÒ¶ÔPHPerµÄË®Æ½Çø·ÖµÄÁ¢³¡.
¹ØÓÚ¾ßÌåÊÕÈëˮƽ,×ܵÄÀ´ËµÒòΪÕ⼸ÄêPHPÅàѵ°àµÄ¼Ó¶à,´óÁ¿PHPÐÂÊÖ¿ ......
#################################
##########BY:Moskey.Tong#########
###########2009-11-15############
#########*×ªÔØÇë×¢Ã÷*############
#################################
×ܽáÒ»ÏÂÕâ¸öÐÇÆÚÌìPHPÉÏ´«Í¼Æ¬¡£
ÉÏ´«Í¼Æ¬ÔÀí£ºÊ×ÏÈÅжÏÎļþÀàÐÍÊÇ·ñΪͼƬ¸ñʽ£¬ÈôÊÇÔòÉÏ´«Îļþ£¬È»ºóÖØÃüÃûÎļþ£¨Ò»°ã¶¼ÊDZÜÃâÉ ......
Php Variable Circular References
Circular-references has been a long outstanding issue with PHP. They are
caused by the fact that PHP uses a reference counted memory allocation
mechanism for its internal variables. This causes problems for longer
running scripts (such as an Applicatio ......
ÕûÀí»î£ºPHPµÄÈÕÆÚʱ¼äº¯Êýdate()
1£¬Äê-ÔÂ-ÈÕ
echo date('Y-m-j');
2007-02-6
echo date('y-n-j');
07-2-6
´óдY±íʾÄêËÄλÊý×Ö£¬¶øÐ¡Ð´y±íʾÄêµÄÁ½Î»Êý×Ö£»
Сдm±íʾÔ·ݵÄÊý×Ö(´øÇ°µ¼)£¬¶øÐ¡Ð´nÔò±íʾ²»´øÇ°µ¼µÄÔ·ÝÊý×Ö¡£
echo date('Y-M-j');
2007-Feb-6
echo date('Y-m-d');
2007-02-06
´óдM±íʾÔÂ·ÝµÄ ......