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

php mysql»Ø¹öʾÀý

Ê×ÏÈ£¬½¨InnoDBÀàÐÍµÄ±í£¬²ÅÄÜÖ§³ÖÊÂÎñ
$handler = mysql_connect('localhost', '', '');
mysql_select_db('test');
mysql_query('SET AUTOCOMMIT=0'); // ÉèÖÃΪ²»×Ô¶¯Ìá½»²éѯ
mysql_query('START TRANSACTION'); // ¿ªÊ¼²éѯ£¬ÕâÀïÒ²¿ÉÒÔʹÓÃBEGIN
mysql_query("INSERT INTO users VALUES ('ccc')");
mysql_query("DELETE from users WHERE username = 'aac'");
if (mysql_affected_rows($handler) == 0)
mysql_query('ROLLBACK'); // Èç¹ûɾ³ýδÕÒµ½ÏàÓ¦µÄ¼Ç¼Ôò»Ø¹ö£¬²»Ö´ÐÐÉÏÃæµÄ²åÈë²éѯ
mysql_query('COMMIT');
mysql_close($handler);


Ïà¹ØÎĵµ£º

PHPÀàµÄ·ÃÎÊ¿ØÖÆ

PHPÖÐÀàµÄ·½·¨Ò²ºÍC++ͨ¹ý¹Ø¼ü×Ö private
¡¢Public
¡¢ protected
À´¿ØÖƵġ£Ï±ßÊÇÏêϸ˵Ã÷£º
1¡¢private
     º¯ÊýǰʹÓùؼü×ÖPrivate±íʾº¯ÊýÊÇ˽Óеģ¬Ë½ÓеÄÒâ˼¹ËÃû˼Ò壬Õë¶Ôµ±Ç°Àà˽ÓУ¬ÎÞÂÛÊÇËûµÄ×ÓÀ໹ÊÇËûµÄʵÀý¶¼ÎÞ·¨·ÃÎÊ¡£
     »¹ÊÇÏÈ¿´´úÂ룺
 &nbs ......

PHPÊý¾Ý¿âÊÂÎñ´¦Àí

ÔÚʹÓÃphpÖÐʹÓÃÊý¾Ý¿âÊÂÎñ´¦Àí²¢²»¸´ÔÓ£¬Ö÷ÒªÓõ½µÄÊÇmysqliÀàµÄ3¸ö³ÉÔ±º¯Êý¡£
£¨1£©autocommit£¨bool mode£©£¬ÉèÖÃÊý¾Ý¿â×Ô¶¯Ìύ״̬¡£µ±modeΪTRUEʱ£¬´ò¿ª×Ô¶¯Ìá½»ÉèÖ㬵±modeΪFASLEʱ£¬¹Ø±Õ×Ô¶¯ÉèÖá£Ëùν×Ô¶¯Ìá½»£¬¾ÍÊÇMYSQLÿִÐÐÒ»ÌõSQLÓï¾ä£¬¸ÃSQLÓï¾äµÄÖ´Ðнá¹ûÂíÉÏÉúЧ¡£¶ø·Ç×Ô¶¯Ìύʱ£¬ÔòÖ´Ðнá¹ûÒªÒ»Ö±µ½ ......

MySQL ´æ´¢ schema lessµÄÊý¾Ý

from timyang¡¯s blog ×ÛºÏÈ¡ÉᣬʹÓÃMySQLÀ´´æ´¢key/value(schema-less)Êý¾Ý,valueÖпÉÒÔ·Å£º
Python dict
JSON object ʵ¼Êfriendfeed´æ·ÅµÄÊÇzlibѹËõµÄPython dictÊý¾Ý£¬µ±È»ÕâÖÖ°ó¶¨Ò»ÖÖÓïÑÔµÄ×ö·¨¾ßÓÐÕùÒéÐÔ¡£ ......

¸ü¸ÄmysqlÊý¾Ý¿â±àÂëΪGBK

¸Õ¸Õ°²×°Íêmysqlºó
´ÓcmdÖнøÈëmysqlÊý¾Ý¿â
ÃüÁîÐÐÖÐÊäÈ룺
mysql -uroot -p123
½øÈëmysqlÊý¾Ý¿âÖÐ
ÃüÁîÐÐÖÐÊäÈë:
status;
²é¿´µ±Ç°Êý¾Ý¿âÖеıàÂë
ÈçÏ£º
--------------
mysql  Ver 14.12 Distrib 5.1.7-beta, for Win32 (ia32)
Connection id:       &nb ......

php±àÂëת»»×ܽá

iconvº¯Êý¿âÄܹ»Íê³É¸÷ÖÖ×Ö·û¼¯¼äµÄת»»£¬ÊÇphp±à³ÌÖв»¿ÉȱÉٵĻù´¡º¯Êý¿â¡£
1¡¢ÏÂÔØlibiconvº¯Êý¿âhttp://ftp.gnu.org/pub/gnu/libiconv/libiconv-1.9.2.tar.gz£»
2¡¢½âѹËõtar -zxvf libiconv-1.9.2.tar.gz;
3¡¢°²×°libiconv
££configure --prefix=/usr/local/iconv
#make
#make install
4¡¢ÖØÐ±àÒëphp Ô ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ