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

PHP Redirecting
Hello everyone. Is there a way to redirect people to pages within a statement in PHP? Since there is

Unifying logins of two different scripts
I have two different game scripts which I want to embed on my own site. The problem is I don't want

building a function with multiple outputs
I want to build a function that has multiple outputs.

I know but am not to sure how I should

upload only text files
hi guys i want to upload only text like like (pdf,note pad and ofiice files) so can any one please t

array_diff weirdness
I'm using the following bit of code

$diff = array_diff($pids, $pidlist);
$diff = array_va

urldecode question
How would I format this line of code properly?

<?php echo urldecode($_GET['Title']); ?

Security Exception on pages using AJAX
I am getting the exception: attempted to perform an operation not allowed by the security policy on

Ariba 9r - SAP MM Integration
Hi experts,

The standard Ariba adapter for 9r creates a relationship between Cost Centers

Simultaneous select/update/insert
Hi

How would I need to go about when 2 users update a single row simultaneous? And how would

Timer control causing error
I recently decided to add a timer control to an existing page that uses AJAX on my site. As soon as