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

breaking a text file into paragraphs based on strings
I have a text file of email addresses that is all squished together. It looks like this:

abc

quick basic question, hopefully not dumb
I don't know how to search for this, so forgive me if it's been covered...

I often see an exa

in php, link returns to the line
When I add a link in a php page, the link word returns to the line (as a
would do)

Examp

how do i make new line after *
First check this page here. and you see my report. Im pulling form a mysql db. I want to beable to m

reating a background image
I am building a site in drupal and have a php form in it, due to certain annoyances with module buil

Error with Font and imagettfbbox
I keep getting an error that says "Warning: imagettfbbox() [function.imagettfbbox]: Could not f

Odd or Even
Inside of a while loop I need to echo several rows of info...easy enough.

In the loop (for th

Vertical Alligning - Not working in 1 cell?
<?php

echo "<table id="valign" width="60%" style=

Fetching META TAGS through
Hello everybody
I want to fetch meta tags of a domain.
It will be done from following code of

update 2 columns by doing inner 2-column query
Hi,
is something like this possible?

update contract_all set col1,col2 =
(