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

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»¿ÉÄÜµÄ Ð»Ð»


Ïà¹ØÎÊ´ð£º

ÇëÎÊphp²ÉÓÃʲô¼ÓÃÜ·½Ê½²»±»ÆÆ½â£¿ - PHP / »ù´¡±à³Ì

zend guard¼ÓÃܵÄphpÊÇ¿ÉÒÔÆÆ½âµÄ£¬ÓÐµÄ ËµÊÇʹÓú¯Êý»ìÏý¿ÉÒÔ¸üÄÑÆÆ½âһЩ¡£ÔõôʹÓÃÄØ¡£
»òÕß´ó¼Ò¸æËßÎÒÄÄÖÖ¼ÓÃÜ·½Ê½¸ü°²È«¡£Ð»Ð»ÁË¡£
ÎÒĿǰµÄzend guard°æ±¾ÊÇ4.0.1
ÎÞ½â

ÒýÓÃ
ÎÞ½â
²»¿ÉÄܰɡ£ÔÚÍøÉϲéÁ ......

ÎÊÒ»¸öPHPºÍsmartyµÄÈÕÆÚÎÊÌâ - PHP / »ù´¡±à³Ì

index.phpÄÚÈÝ£º
  $smarty->assign('name',strtotime('-0'));
  $smarty->display("index.html");
index.htmlÄÚÈÝ£º
{$name|date_format:'%Y-%m-%d'}<hr>
{$ ......

phpÁª½Ó¶à¸öÊý¾Ý¿âµÄÎÊÌâ

mssql_select_db("f1",mssql_connect("localhost","sa","sa"));
mssql_select_db("f2",mssql_connect("192.168.0.1","sa","sa") ......

PHP submitÎÊÌ⣨¼±£¬ÔÚÏߵȣ© - PHP / »ù´¡±à³Ì

<?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 ......

PHP+MYSQLÊý¾Ý¼¯´¦Àí - PHP / »ù´¡±à³Ì

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)ÖеÄÊý¾ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ