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

Hardcopy printing is to wide
I want to make a hardcopy at runtime of my active form like this

array_combine() error
getting an "Warning: array_combine() [function.array-combine]: Both parameters should have an e

how to validate date using javascript
I need to validate date in textbox using javascript..
The date is must be not greater than TODAY

Session login issue
I'm wondering how to fix a problem I'm having with a session-based login system

Say I go to h

IP Based Cron Jobs
I run cronjobs on my website. After one of my visitors got curious and tinkered around he realized h

mail with attachment problems
Hi. I have the following code:
Code: else if(file_exists("site".$timp.".zip")

unexpected T_VARIABLE error
Hey all! I'm getting an unexpected T_VARIABLE with the following function:

function getHighes

Help on query replacing the date
Hi Pals,

i want to replace the current date in a column to some value say C or D or any n

Auto-populating dropdowns and multiple forms.
Here's what I have so far:

First drop down = select a state (works)
This populates the sec

Weird Problem with curl while sending data
I am facing a weird problem with sending data to a site via curl.

If i send the value by this