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Óï¾äµÄ·ÖÖ§ÁË =========================================== ÄѵÀ²»ÄÜд³ÉÒ»ÌõÂð£¿ÒýÓà ¿ÉÄÇÑùµÄ»°¾ÍÒªÅжÏ$ageÖ®ºóд2ÌõsqlÓï¾äµÄ·ÖÖ§ÁË =========================================== ÄѵÀ²»ÄÜд³ÉÒ»ÌõÂ𣿠ÕâÕýÊÇÎÒµÄÒÉÎʰ¡ д³É1ÌõµÄ»°£¬ÔÚÊäÈëΪ¿Õʱ¾ÍÒª¶Ô$age¸³ÖµÒÔ´ïµ½²åÈënullµÄÄ¿µÄ°¡ µ± $age Ϊ¿Õʱ£¬²»¶Ô customer_age Ö´ÐвåÈ붯×÷ ¼´ customer_age ²»³öÏÖÔÚ²åÈëÁбíÖÐ Èç¹ûÄãÊǸù¾Ý±íµ¥¶¯Ì¬¹¹Ôì sql ´®£¬ÄÇô¾ÍºÜÈÝÒ××öµ½ÁË ÓбØÒª·ÇNULLô£¿Äã·Ç¿ÕÏÔʾµÄʱºò¿ÉÒÔ×ö¸öÅжϰ¡£¬±ÈÈçNULL||""¾ÍÊä³öʲô Ä¿µÄÊÇ¿ÉÒÔ´ïµ½µÄ£¬ Ö»ÊÇÏëÖªµÀÄܲ»ÄÜÖ±½Óͨ¹ý¶Ô$ageÉèÖµµÄ·½Ê½£¬sqlÓï¾ä¾ÍдһÌõ£¬À´²åÈënull¡£ ¿´À´ÊDz»¿ÉÄÜµÄ Ð»Ð»
Ïà¹ØÎÊ´ð£º
zend guard¼ÓÃܵÄphpÊÇ¿ÉÒÔÆÆ½âµÄ£¬ÓÐµÄ ËµÊÇʹÓú¯Êý»ìÏý¿ÉÒÔ¸üÄÑÆÆ½âһЩ¡£ÔõôʹÓÃÄØ¡£ »òÕß´ó¼Ò¸æËßÎÒÄÄÖÖ¼ÓÃÜ·½Ê½¸ü°²È«¡£Ð»Ð»ÁË¡£ ÎÒĿǰµÄzend guard°æ±¾ÊÇ4.0.1 ÎÞ½â ÒýÓà Î޽⠲»¿ÉÄܰɡ£ÔÚÍøÉϲéÁ ......
index.phpÄÚÈÝ£º $smarty->assign('name',strtotime('-0')); $smarty->display("index.html"); index.htmlÄÚÈÝ£º {$name|date_format:'%Y-%m-%d'}<hr> {$ ......
mssql_select_db("f1",mssql_connect("localhost","sa","sa")); mssql_select_db("f2",mssql_connect("192.168.0.1","sa","sa") ......
<?php @session_start(); require_once './module/t_doctor.inc'; $t_doctor = new t_doctor(); if(isset($Submit)){ $sql="select * from t_doctor WHERE docname='".$usernam ......
1¡¢ÊDz»ÊÇPHPÖÐÖ»ÄÜʹÓÃmysql_query("update user_aa set money=money2-".$bpanmm." where uid=".$userppp);¸üÐÂÊý¾Ý£¿£¿£¿ 2¡¢PHP¸üÐÂmysql_fetch_row($res)Óëmysql_fetch_array($res)ÖеÄÊý¾ ......