ÐÞ¸Ämysql×Ö¶ÎÀàÐÍ£¬Ìύʱ±¨´í - PHP / »ù´¡±à³Ì
ÏÖÔÚÎÒµÄprice×Ö¶ÎΪvarcharÐÍ£¬ÒÔǰû¿¼Âǵ½¼Û¸ñ»áÓÃÀ´×ö¼ÆË㣬½ñÌìÒªÓõ½ÁË£¬¸ÄΪ¸¡µãÐÍ£¬¿ÉÊÇÌύʱ±¨´í˵¡°Data truncated for column 'price' at row 1 ¡±£¬ ²»ÖªµÀÓÐûÓÐÅóÓÑÓöµ½¹ý¡£
ßÀ
¸ã¶¨
ÔÀ´ÊÇÕâ¸ö×Ö¶ÎϵÄÄÚÈݲ»ºÏ¸ñ
µ±ÎҰѸ¡µãÐ͵ij¤¶ÈÉèΪ4£¬ÎÞ·¨±£´æÐ¡Êý£¬³¤¶ÈÉèΪ0È´¿ÉÒÔ£¬Çó½â
²»ÊÇÌ«Ã÷°×Â¥Ö÷Òâ˼
DECIMAL(8,2) ÎÒmysqlÀïÃæ¶¼ÊÇÕâÑùÓÃµÄ ±íʾ°Ëλ¸¡µãÊý ÆäÖÐÁ½Î»Ð¡Êý²¿·Ö
µ±ÎÒ³¤¶ÈÖµÉèΪ4£¬²»Äܱ£´æÐ¡Êý£¬µ±ÉèΪ¿Õ£¬²Å¿ÉÒÔ±£´æÐ¡Êý
Ó¦¸ÃÊÇÒÑÓеÄÊý¾ÝÎÞ·¨Âú×ãж¨ÒåµÄ×ֶεĹæÔò¡£
Ó¦¸ÃÊdz¤¶ÈÎÊÌâ,³¤¶È±äΪfloatĬÈϳ¤¶ÈÊÔÊÔ.
³¤¶ÈÊÇ4µÄ»°,ÒÔǰ³¤¶È´óÓÚ4µÄ,¾ÍÓ¦¸Ã»á±¨´í°É.
Ïà¹ØÎÊ´ð£º
1.¾«Í¨ÃæÏò¶ÔÏóµÄÉè¼ÆºÍ¿ª·¢£»
2.ÊìÁ·Ê¹ÓÃPHPÓïÑÔ(5.0+)½øÐÐÊý¾Ý¿â£¬ÍøÂçͨÐÅ£¬Îļþ¶Áд£¬°²È«»úÖÆµÈ¿ª·¢£»
3.ÊìÁ·Ê¹ÓÃMYSQL(5.0+)Êý¾Ý¿â¿ª·¢£¬°üÀ¨»ù±¾µÄÊý¾Ý¿âÉè¼Æ/ÓÅ»¯/°²È«£¬¸´ÔÓµÄT-SQLÓï¾ä±àд£¬ÊìÁ·±àдMYS ......
zend guard¼ÓÃܵÄphpÊÇ¿ÉÒÔÆÆ½âµÄ£¬ÓÐµÄ ËµÊÇʹÓú¯Êý»ìÏý¿ÉÒÔ¸üÄÑÆÆ½âһЩ¡£ÔõôʹÓÃÄØ¡£
»òÕß´ó¼Ò¸æËßÎÒÄÄÖÖ¼ÓÃÜ·½Ê½¸ü°²È«¡£Ð»Ð»ÁË¡£
ÎÒĿǰµÄzend guard°æ±¾ÊÇ4.0.1
ÎÞ½â
ÒýÓÃ
ÎÞ½â
²»¿ÉÄܰɡ£ÔÚÍøÉϲéÁ ......
²ËÄñÇó¾È£¡£¡
ÏÖÔÚÎÒÊÖÍ·ÓÐÒ»¸öphp+oracleµÄÍøÕ¾¡£¡£·þÎñÆ÷ÊÇlinuxϵͳ
Çë¸÷λ¸æËßÎÒÈçºÎ·¢²¼¡£¡£¡£ÎÒÊÇÐÂÊÖ¡£Ð»Ð»ÁË£¡£¡
°²×°Ò»¸öapache£¬°ÑphpÎļþ·Åµ½apacheµÄ·¢²¼Ä¿Â¼Ï£¬ ......
×î½üÒ»¸öÏîÄ¿ÖÐÓöµ½Ò»¸öÎÊÌ⣺ÔÚÔÓеÄÒ»Ì×ϵͳÖÐ(php¿ª·¢)Ìí¼ÓһЩС¹¦ÄÜ(jsp¿ª·¢)£¬ÔÀ´Óû§ÏµÍ³¶¼ÊÇphp¿ª·¢µÄ£¬ÎÒÈçºÎÔÚjsp¿ª·¢µÄ¹¦ÄÜÖÐ×öµ½Óû§ÐÅÏ¢sessionͬ²½ÄØ£¿ ÓÐÈËÊÇ·ñÓÐ×ö¹ýÀàÒÔÏîÄ¿£¬ÏëÌýÌý´ó¼ÒµÄ¿´·¨
......
3̨µçÄÔ£¬ÆäÖÐһ̨×÷ΪMYSQL·þÎñÆ÷£¬ÁíÍâ2̨ΪTOMCAT·þÎñÆ÷¡£
MYSQL·þÎñÆ÷ÀïÓÐÒ»Ìõ¼Ç¼£¬ IDΪ10.
ÏÖÔÚ2̨TOMCATͬʱ£¨100%£©·¢ÆðÐÞ¸ÄMYSQLÀïIDΪ10µÄÄÇÌõ¼Ç¼£¬±ÈÈçÐ޸ĴËID¼Ç¼ÀïijһÏîµÄÄÚÈÝ¡£ ±ÈÈçTOMCAT 1Ò ......