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();
?>
Ïà¹ØÎĵµ£º
1¡¢Ê×ÏÈͨ¹ý´úÂëÀ´¿´¿´±íÏó£º
<?php
session_start();
if (empty($_SESSION['count'])) {
$_SESSION['count'] = 1;
} else {
$_SESSION['count']++;
}
var_dump($_SESSION);
var_ ......
ÒÔǰһֱ¸ãC++½øÐÐC/S¿ª·¢£¬Ôø¾µÄÏë·¨ÊÇÈç¹ûÓлú»á£¬Ñ§Ñ§¸ãÍøÕ¾ºÍǶÈëʽ¿ª·¢
ûÏëµ½ÕÒµ½¹¤×÷µÄµÚ2Ìì¾ÍÓÐÁË×öÍøÕ¾µÄ»ú»á£¬Ò²×¬µ½ÁË×Ô¼º´óѧÆÚ¼ä×î¸ßµÄÒ»·Ý¹¤×Ê£¬10Ìì1000¿é
ÔÚʲôµÄ¶¼²»»áµÄÇé¿öÏ£¬¾¡È»´ðÓ¦ÈËÊ´¦µÄÀÏʦһ¸öÐÇÆÚдºÃÍøÕ¾µÄºǫ́
ÎÒ³ÐÈÏÕÒµ½¹¤×÷ºó×Ô¼ºÊÇÓеã¿ñÁË£¬ºÜ¶àÊÂûעÒâµ½£¬ºÜ¶àʺó»Ú²»ÁË¡£¡£¡£
......
ÔÚDOSÖнøÐÐMySQLµÄ·ÃÎÊ¿ÉÄÜÂÒÂëµÄÇé¿öÓÐÈýÖÖ£¬
Ê×ÏÈ£¬Òª×öµÄÊǼì²éMySQLµÄÅäÖ㬰²×°µÄʱºòÑ¡Ôñutf-8µÄÓïÑÔ»·¾³»áʡȥºÜ¶àµÄÂé·³
1. ¼ì²éMySQLµÄ·þÎñ¶Ë¡¢¿Í»§¶ËµÄÓïÑÔÉèÖÃÊÇ·ñΪ“utf8”£¬²»ÊǵϰÊÖ¶¯½«my.int¸ü¸Ä¹ýÀ´£»
2. ÔÚPHP½øÐеÚÒ»´Îmysql_query֮ǰÉèÖÃʹÓÃÁ¬½ÓµÄ×Ö·û¼¯Îª"SET N ......
ÉîÒ¹ÏÐÁÄJavaÓëPHP ÒÔ¼°¼Ü¹¹Éè¼ÆË¼ÏëÓë×î¼Ñʵ¼ù
·¢ÐÅÈË: wesley (ÐÄÖеÄÉÁÖ), ÐÅÇø: Java
±ê Ìâ: ÉîÒ¹ÏÐÁÄJavaÓëPHP ÒÔ¼°¼Ü¹¹Éè¼ÆË¼ÏëÓë×î¼Ñʵ¼ù
·¢ÐÅÕ¾: ˮľÉçÇø (Thu Dec 24 01:55:04 2009), Õ¾ÄÚ
×ªÔØ×Ô±¾ÈËÐÂÀ˲©¿Í
http://blog.sina.com.cn/s/blog_53923f940100g7xx.html
£¨ÀÏÎâ×ÔÑÔ×ÔÓ
×î½üƵ·±ÌýË ......
ÕªÒª: ÓÃÕýÔòʵÏÖ°üº¬Ä³¸ö×Ö·û´®ºÜÈÝÒ×£¬µ«Èç¹ûʵÏÖ²»°üº¬Ä³¸ö×Ö·û´®ÄØ£¿×÷Õ߸ø³öÁËÒ»¸ö½â¾ö·½°¸¡£
ÅжÏÒ»¸ö×Ö·û´®ÖÐÊÇ·ñº¬ÓÐÁíÒ»×Ö·û´®£¬phpÓкܶ෽·¨£¬ÈçÏ£º
1. ³£¼ûº¯Êý
strstr($str, "abc");
strstr($str, "abc");
2. ÕýÔòÆ¥Åä
preg_match("/(abc)/is", $str);
p ......