rreee rreee
は議論(ソリューション)に繰り返します「含まれる」ケース:
break;として扱われるため、変数 $PUR には値が割り当てられません。もちろん期待した結果はありません
<?php //定义常量define("EntTime", "2012-08-01");define("EntTime2", "2012-08-31");define("Query_field", "品号");define("Operate", "包含");define("requirement", "WDZ");//将常量转换为变量$EntTime = EntTime;$EntTime2 = EntTime2;$Query_field = Query_field;$Operate = Operate;$requirement = requirement;//自定义函数function jhRepPd(){ GLOBAL $PUR,$MOC; switch($Operate){ case "包含": if($Query_field=="品号"){ $PUR = "PURTH.TH004 like'%".$requirement."%' AND "; } break; }}//去除日期中的"-"$a_date = "PURTG.TG003 >='".str_replace("-","",$EntTime)."'";$b_date = "PURTG.TG003 <='".str_replace("-","",$EntTime2)."'";//判断变量是否为空if(!empty($EntTime) && !empty($EntTime2) && $requirement!==""){ $date = "(".$a_date." AND ".$b_date.") AND "; jhRepPd();};//sql语句$sql = "SELECT * FROM TB where {$date}{$PUR}dbId in('1','2','3')";//打印SQL语句echo $sql;?>