$sql = "select * from myTable"
if ($_POST[user1] = "" && $_POST[date1] = "" && $_POST[date2]="" && $_POST[agent]="" $_POST[guest]="" && $_POST[okif]= "")
{
}
else
{ $sql. = " where" if ($_POST[user1] != "")
{
$sql. =" user1 = '$user1'"
} if ()
{}//自己写}echo $sql;//自己检查一下
if ($_POST[user1] = "" && $_POST[date1] = "" && $_POST[date2]="" && $_POST[agent]="" $_POST[guest]="" && $_POST[okif]= "")
{
}
else
{ $sql. = " where" if ($_POST[user1] != "")
{
$sql. =" user1 = '$user1'"
} if ()
{}//自己写}echo $sql;//自己检查一下
$submitArray= array_diff( $_POST , $filterKey );
foreach($submitArray as $SQLKey => $SQLValue)
{
if($SQLKey != 'pass_word' && $SQLKey != 'confirm')
$submitSetSQL .= "{$SQLKey} = '$SQLValue', ";
// end foreach
}
$searchIf = '';
foreach($searchIfArray as $key => $value)
{
if($key!='page' && $key!='SID') // 过滤健名
$searchIf = "{$key}='$value', ";
}
// end foreach
if($searchIf!='')
$searchIf = " WHERE ".substr($searchIf , 0 ,-2);
// end if
$searchSQL = "SELECT user_id,user_stat,user_name,reg_date FROM `" . TABLE_USERS . "`" . $searchIf . " ORDER BY user_id DESC LIMIT $offset , ".PAGE_NUMBER;
的值,即$user,$date1,$date2,$agent,$guest,$okif
可以这样查询:
$sql="select * from talel where (if(isset($user)&&isset($date1)&&isset($date2)&&isset($agent)&&isset($okif))
user=".$user. " , date1=".$date1." ,date2=".$date2." ,guest=".$guest.",okif=".$okif
else if(!isset($user)&&isset($date1).........
其它情况自己补充吧,不过我建议你在操作数据库时最好写一个数据操纵类,像这样的查询就简单得多了