Need understanding of this bit of code

Posted on 16th Feb 2014 07:03 pm by admin

Code: <?php
// WHERE clause filters
$arrSQLFilters = array();

// whether or not zip codes table needs to be included
$boolIncludeZipCodes = false;

// Zipcode filter
if(!empty($strZipCode)) {
$boolIncludeZipCodes = true;

$arrSQLFilters[] = sprintf(
"z.zip LIKE '%s'"
,"%$strZipCode%"
);
}

// State filter
if(!empty($strState)) {
$boolIncludeZipCodes = true;

$arrSQLFilters[] = sprintf(
"z.state = '%s'"
,$strState
);
}

// Restaurants name filter
if(!empty($strName)) {
$arrSQLFilters[] = sprintf(
"r.restaurantname LIKE '%s'"
,"%$strName%"
);
}?>

Your Answer:

Login to answer

Other forums

Help with search.php
Hello All

I need the search engine on a site I am building at the moment to display the searc

Validating time
Hi Guys

what do you think of the following approach to validate a 24hour time:

http://

ob_ dynamic content
i was wondering about the potential to use ob to create a <div then remove it when the page

Mail sending is slow on server
Why mail is taking time to be send on apache-linux server

Undefined Index Notice In Internet Explorer Only
I am getting the following notice:

QuoteNotice: Undefined index: jrox in /home/ycsn/public_h

All possible combinations of String in PL/SQL
Hi All,

Could you please explain the logic of getting all possible combinations of String

$get problem
Hi Guys ...

can you please tell me what i am doing wrong here
Code: <?php

fwrite error
Hi All,
Does anyone know what is causing the error in this code?

Code: <?
$error

Phase Error I can't seem to find :(`
Hey guys, I can seem to find my phase error on this. I am getting this error

[error]
Pars

Linking with Foreign Keys
I have been getting an erro when I try and link:

create table Faculty_Specialty (I_Name v