function db_prep_timestamp($time)
{
if (!is_null($time) && $time != '' && !is_numeric($time)) {
$result = db_prep_string(db_escape($time));
$result = strtotime(str_replace("'", '', $result));
$result = " to_timestamp( {$result} ) ";
} else {
if (is_numeric($time)) {
$result = db_prep_int($time, true);
$result = " to_timestamp( {$time} ) ";
} else {
$result = 'null ';
}
}
return $result;
}
function search_deal($deal, $url, $image_url, $business, $expiration, $percent_discount, $max_discount, $one_per, $claimed, $city, $fine_print, $columns, &$count)
{
$query = "select ";
if (is_null($columns)) {
$query .= "*";
} else {
$query .= db_escape(implode(',', $columns));
}
$query .= " from tb_deal where true ";
$deal = db_prep_positive_int($deal);
$business = db_prep_positive_int($business);
$percent_discount = db_prep_positive_int($percent_discount);
$max_discount = db_prep_positive_int($max_discount);
$claimed = db_prep_positive_int($claimed);
$url = db_prep_string(db_escape($url));
$image_url = db_prep_string(db_escape($image_url));
$expiration = db_prep_string(db_escape($expiration));
$one_per = db_prep_string(db_escape($one_per));
$city = db_prep_string(db_escape($city));
$fine_print = db_prep_string(db_escape($fine_print));
fb($city, '$city');
if (strcmp($deal, 'null')) {
$query .= "and deal = {$deal} ";
}
if (strcmp($url, 'null')) {
$query .= "and url = {$url} ";
}
if (strcmp($image_url, 'null')) {
$query .= "and image_url = {$image_url} ";
}
if (strcmp($business, 'null')) {
$query .= "and business = {$business} ";
}
if (strcmp($expiration, 'null')) {
$query .= "and expiration = {$expiration} ";
}
if (strcmp($percent_discount, 'null')) {
$query .= "and percent_discount = {$percent_discount} ";
}
if (strcmp($max_discount, 'null')) {
$query .= "and max_discount >= {$max_discount} ";
}
if (strcmp($one_per, 'null')) {
$query .= "and one_per = {$one_per} ";
}
if (strcmp($claimed, 'null')) {
$query .= "and claimed >= {$claimed} ";
}
if (strcmp($city, 'null')) {
$query .= "and city = {$city} ";
}
if (strcmp($fine_print, 'null')) {
$query .= "and fine_print regexp {$fine_print} ";
}
fb($query, '$query');
$retval = query_assoc($query, $count);
return $retval;
//fb( $retval, '$retval search_deal' );
//fb( $count, '$count' );
}
