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

type check while uploading
Hi Everyone,

How can I check the exact type of a file while uploading on my site?

Here

Ajax Error since Upgrading to 3.5
Ever since upgrading my site to .NET 3.5 (I needed LINQ), I've been getting this annoying error on o

login from external site
Hi my new experience begins, Now what i am trying to do is i make three pages, login.php logout.php

form problem
below in the form action, i've put "test.php?w=$sw&h=$sh" but when i input the for

Session problem?!?
Hello All! I am very new to the php world but I am working on fixing things that a previous programm

How to generate a random array of integers subject to a certain constraint
I am writing a program that asks the user to enter an integer N and then generates a random array of

NOOB needs help with upload file
The intent of this form is to create a folder for a client and upload an image into another folder '

problem with refreshing
in my site, i have an index page, it has a main div. this main div's content is changing according t

Embed Video Problem
Hey, thanks for looking!

File to be embedded:

Code: <playlist version="1&q

What am I missing here? Help!
Hello all!. I can't seem to get this working right. Well - it renders right, but something is goin