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

How can i steam a video on my PHP site? (non YouTube)
Basically I have a PHP site and don't want to give page rank to YouTube. I just want to stream a bas

Image upload - determine folder
I have an upload script that may be accessed from different directories. Problem is, the script is m

Alternate messaging
I have 4 strings in MySQL db1

$string1 : Hello
$string2 : Hi
$string3 : Great
$strin

php/mysql auto logout after 2 hour and reset password
Hi all,

This I hope will make sense. I've the following code which when a user logins in, cr

Php script to read msword file
hi,

I need to read a msword file and i want to print the contents in that word file.

i

image upload script not working with png
The basic process of this php code is to take the submitted file, convert it to a small JPG thumbnai

passing data from one page to another
hey guys
i have the follwoing code to get information from one page and place on another:

AJAX form submit
I recently built a form that submits data to my database with an ajax function that is called throug

mail() problem
Hi Guys,

I've set up a contact email form. It sends the information fine, but it sends it to

Array help
Hello i got this code to fetch data from database but it is not working it displays
7
Array