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

php³ÌÐò²åÊý¾ÝÈëmysql, ²åÈëʧ°ÜÎÊÌâ

×¢Òâ:ÒýÓÃ"·ÊÕ¼µÄ²©¿Í http://fatjames.extjs.org.cn/archives/40"
mysql5.x sql-mode ÒýÆðµÄ´íÎó
½ñÌì°²×°Á˸ömysql5.0,ÄÃÁËÒ»¸öºÜ¾ÃÖ®Ç°ÍøÉÏϵijÌÐò¼ì²éÒ»ÏÂÊÇ·ñ¹¤×÷Õý³£.
·¢ÏÖÒÔǰµÄ³ÌÐò¾ÓÈ»²»ÄÜÕý³£ÔËÐÐ,ÌáʾÐÅÏ¢ÈçÏÂ:
Database error: Invalid SQL: INSERT INTO
Survey_UserHistory(userId,jobId,type,action,startTime,endTime)
VALUES(‘17′,”,’User’,'Login’,”,’2008-11-23 14:33:56′)
MySQL error: 1366 (Incorrect integer value: ” for column ‘jobId’ at row 1)
Session halted.
µÚһʱ¼äµÄ·´Ó¦ÊǸúmysql5.0мӵÄsql-modeÓйØÏµ,ÒòΪǰһÕó×Ó¸Õ¸Õ¿´¹ýÊÖ²á.¹ûÈ»,×÷ÁËÈçϸü¸Äºó¾Í²»ÔÙÌáʾÁË.
ÐÞ¸Ä my.ini Îļþ.
# Set the SQL mode to strict
sql-mode=”STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION”
¸ÄΪ:
# Set the SQL mode to strict
sql-mode=”NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION”


Ïà¹ØÎĵµ£º

mysqlÐÔÄÜÓÅ»¯µÄ²ÎÊý¼ò½é


1)¡¢back_log£º
ÒªÇó MySQL ÄÜÓеÄÁ¬½ÓÊýÁ¿¡£µ±Ö÷ÒªMySQLÏß³ÌÔÚÒ»¸öºÜ¶Ìʱ¼äÄڵõ½·Ç³£¶àµÄÁ¬½ÓÇëÇó£¬Õâ¾ÍÆð×÷Óã¬È»ºóÖ÷Ï̻߳¨Ð©Ê±¼ä(¾¡¹ÜºÜ¶Ì)¼ì²éÁ¬½Ó²¢ÇÒÆô¶¯Ò»¸öÐÂÏ̡߳£ 
back_logÖµÖ¸³öÔÚMySQLÔÝʱֹͣ»Ø´ðÐÂÇëÇó֮ǰµÄ¶Ìʱ¼äÄÚ¶àÉÙ¸öÇëÇó¿ÉÒÔ±»´æÔÚ¶ÑÕ»ÖС£Ö»ÓÐÈç¹ûÆÚÍûÔÚÒ»¸ö¶Ìʱ¼äÄÚÓкܶàÁ¬½Ó£¬ÄãÐèÒªÔ ......

apache ºÍphp °²×°ÅäÖÃ

ÏȰ²×°apache http server   һ·next£»
ÔÙ°²×°php£¬×¢ÒâÑ¡Ôñ Apache 2.2.x Module£»
°²×°½áÊøÒԺ󣬻¹ÐèÒªÐÞ¸Ä Apache µÄÅäÖÃÎļþ¡£Îļþ·¾¶Îª
C:\Program Files\Apache
Software Foundation\Apache2.2\conf\httpd.conf¡£
Óà Notepad ´ò¿ª
httpd.conf£¬ÔÚÎļþ×îºóÓÐÒÔ¡¡#BEGIN PHP INSTALLER EDITS - RE ......

MySQLÖÐÎÄÂÒÂë½â¾ö·½°¸

˵Ã÷: ÔÚMYSQLÖУ¬Èç¹ûʹÓÃȱʡµÄ×Ö·û¼¯£¬ÔÚ½¨¿â¡¢½¨±íʱ£¬Ä¬ÈÏʹÓõÄÊÇlatin1×Ö·û¼¯£¬
ΪISO 8859-1Î÷Å·×Ö·û¼¯¡£²åÈëÖÐÎÄ×Ö·ûʱ£¬ÓëÖ®²»Æ¥Å䣬¾Í»á³öÏÖÂÒÂë¡£
¡¾½â¾ö·½°¸¡¿
1. ´ò¿ªÎļþ: C:\Program Files\MySQL\MySQL Server 5.0\my.ini;
2. ½«ÆäÖеÄdefault-character-set=latin1¸ÄΪdefault-character-set=gb2312, ......

PHP header() examples ÍêÕû´úÂë


/*** Function: PHP header() examples (PHP)
**
Desc: Some examples on how to use the header() function of PHPYou find
a detailed tutorial at expertsrt.com (English) or at ffm.junetz.de
(German).These is also a good help about caching at web-caching.com.
**
Example: see below.
<br/& ......

MySQLÑ§Ï°Ëæ±Ê1

²é¿´Êý¾Ý¿â°æ±¾  select version(), current_date();
ÏÔʾÊý¾Ý¿âÓà show databases;
Ñ¡Ôñij¸öÊý¾Ý¿âÓÃuse db_1;
´´½¨Êý¾Ý¿âÓÃcreate db_1;
²åÈëÊý¾ÝÓÃinsert into db_1 values(...);
ÏÔʾµ±Ç°Ñ¡ÔñµÄÊý¾Ý¿âÓÃselect database();
´´½¨±íÓÃcreate table tb_1 (...);
ÏÔʾËùÓбíÓÃshow tables;
ÏÔʾij¸ö±íµÄËùÓÐÄÚ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ