不是/转义符,是一个ad什么的词,怎么包这句SQL
$where = "where 1";
if(!empty($ziduan) && !empty($txt_sousuo))
{
$where .= " and $ziduan like '%{$txt_sousuo}%'";
}
$sql = "SELECT count(h_id) as countnum FROM hotel_activities_2 $where ";
$where = "where 1";
if(!empty($ziduan) && !empty($txt_sousuo))
{
$where .= " and $ziduan like '%{$txt_sousuo}%'";
}
$sql = "SELECT count(h_id) as countnum FROM hotel_activities_2 $where ";
$where .= " and $ziduan like '%{$txt_sousuo}%'";
if(!empty($ziduan) && !empty($txt_sousuo))
{
$where .= " and $ziduan like '%{$txt_sousuo}%'";
}
addslashes($sql) = "SELECT count(h_id) as countnum FROM hotel_activities_2 $where ";
$result = mysql_query($sql);
$where=addslashes($where);
if(!empty($ziduan) && !empty($txt_sousuo))
{
$where .= " and $ziduan like '%{$txt_sousuo}%'";
}
$sql = "SELECT count(h_id) as countnum FROM hotel_activities_2 $where ";
$result = mysql_query($sql);
这样么
$where = "where 1";
if(!empty($ziduan) && !empty($txt_sousuo)){
$where .= " and $ziduan like '%{$txt_sousuo}%'";
}
$sql = mysql_real_escape_string("SELECT count(h_id) as countnum FROM hotel_activities_2 $where ");
$result = mysql_query($sql);