mysqlµÄnullÎÊÌâ - PHP / »ù´¡±à³Ì
×Ö¶Î `customer_age` int(11) default NULL
µ±Ò³Ãæ²»ÊäÈëÄêÁäʱ£¬$ageʵ¼ÊÊÇ¿Õ×Ö·û ¾ÍÊÇ$age==""; ´Ëʱ²åÈë Êý¾Ý¿â¸ÃÏîΪ0
ÔÚphpÀïÉè$age=NULL; ´Ëʱ²åÈë Êý¾Ý¿â¸ÃÏîΪ0
ÏëÖªµÀ£¬Èç¹û´Óphp²åÈëµÄ»°£¬ÔõôÑùÉèÖÃ$ageµÄÖµ´Ó¶øÊ¹Êý¾Ý¿â¸ÃÏîΪnull?²»ÖªµÀÕâÑù¿É²»¿ÉÄÜ
µ±È»Ö±½Ó¸Äдsql¾äÊÇ¿ÉÒԵģ¬¿ÉÄÇÑùµÄ»°¾ÍÒªÅжÏ$ageÖ®ºóд2ÌõsqlÓï¾äµÄ·ÖÖ§ÁË¡£
¿ÉÄÇÑùµÄ»°¾ÍÒªÅжÏ$ageÖ®ºóд2ÌõsqlÓï¾äµÄ·ÖÖ§ÁË
===========================================
ÄѵÀ²»ÄÜд³ÉÒ»ÌõÂð£¿
ÕâÕýÊÇÎÒµÄÒÉÎʰ¡ д³É1ÌõµÄ»°£¬ÔÚÊäÈëΪ¿Õʱ¾ÍÒª¶Ô$age¸³ÖµÒÔ´ïµ½²åÈënullµÄÄ¿µÄ°¡
µ± $age Ϊ¿Õʱ£¬²»¶Ô customer_age Ö´ÐвåÈ붯×÷
¼´ customer_age ²»³öÏÖÔÚ²åÈëÁбíÖÐ
Èç¹ûÄãÊǸù¾Ý±íµ¥¶¯Ì¬¹¹Ôì sql ´®£¬ÄÇô¾ÍºÜÈÝÒ××öµ½ÁË
ÓбØÒª·ÇNULLô£¿Äã·Ç¿ÕÏÔʾµÄʱºò¿ÉÒÔ×ö¸öÅжϰ¡£¬±ÈÈçNULL||""¾ÍÊä³öʲô
Ä¿µÄÊÇ¿ÉÒÔ´ïµ½µÄ£¬
Ö»ÊÇÏëÖªµÀÄܲ»ÄÜÖ±½Óͨ¹ý¶Ô$ageÉèÖµµÄ·½Ê½£¬sqlÓï¾ä¾ÍдһÌõ£¬À´²åÈënull¡£
¿´À´ÊDz»¿ÉÄÜµÄ Ð»Ð»
Ïà¹ØÎÊ´ð£º
1.¾«Í¨ÃæÏò¶ÔÏóµÄÉè¼ÆºÍ¿ª·¢£»
2.ÊìÁ·Ê¹ÓÃPHPÓïÑÔ(5.0+)½øÐÐÊý¾Ý¿â£¬ÍøÂçͨÐÅ£¬Îļþ¶Áд£¬°²È«»úÖÆµÈ¿ª·¢£»
3.ÊìÁ·Ê¹ÓÃMYSQL(5.0+)Êý¾Ý¿â¿ª·¢£¬°üÀ¨»ù±¾µÄÊý¾Ý¿âÉè¼Æ/ÓÅ»¯/°²È«£¬¸´ÔÓµÄT-SQLÓï¾ä±àд£¬ÊìÁ·±àдMYS ......
zend guard¼ÓÃܵÄphpÊÇ¿ÉÒÔÆÆ½âµÄ£¬ÓÐµÄ ËµÊÇʹÓú¯Êý»ìÏý¿ÉÒÔ¸üÄÑÆÆ½âһЩ¡£ÔõôʹÓÃÄØ¡£
»òÕß´ó¼Ò¸æËßÎÒÄÄÖÖ¼ÓÃÜ·½Ê½¸ü°²È«¡£Ð»Ð»ÁË¡£
ÎÒĿǰµÄzend guard°æ±¾ÊÇ4.0.1
ÎÞ½â
ÒýÓÃ
ÎÞ½â
²»¿ÉÄܰɡ£ÔÚÍøÉϲéÁ ......
×î½üÒ»¸öÏîÄ¿ÖÐÓöµ½Ò»¸öÎÊÌ⣺ÔÚÔÓеÄÒ»Ì×ϵͳÖÐ(php¿ª·¢)Ìí¼ÓһЩС¹¦ÄÜ(jsp¿ª·¢)£¬ÔÀ´Óû§ÏµÍ³¶¼ÊÇphp¿ª·¢µÄ£¬ÎÒÈçºÎÔÚjsp¿ª·¢µÄ¹¦ÄÜÖÐ×öµ½Óû§ÐÅÏ¢sessionͬ²½ÄØ£¿ ÓÐÈËÊÇ·ñÓÐ×ö¹ýÀàÒÔÏîÄ¿£¬ÏëÌýÌý´ó¼ÒµÄ¿´·¨
......
mssql_select_db("f1",mssql_connect("localhost","sa","sa"));
mssql_select_db("f2",mssql_connect("192.168.0.1","sa","sa") ......
ÔÚfirefoxä¯ÀÀÆ÷ÏÂÕý³£µÇ½£¬µ«ÔÚIE ä¯ÀÀÆ÷ÏÂÎÞ·¨µÇ½£¬Ã¿´Î¶¼»áÖØÐÂÉú³ÉÒ»¸ösession,ÔÀ´µÄÄÚÈݻᶪʧ¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£Ôõô»ØÊÂ......
¾ßÌåÇé¿ö£¿²Â²â¿ÉÄÜÊÇÄã±¾»úIEµÄcookie±»½ûÓÃÁ˰ɣ¬¿ÉÒÔ¿´¿´
cookie Æ ......