Loop through array -- get one result

zzz

I have an include file that contains data in this format:

sj[1] = 'SAN JOSE, CAsome text';

$sj[2] = 'NATIONWIDEsome text';

$sj[3] = 'NEW YORK, NYsome text';

$sj[4] = 'PHOENIX, AZsome text';

I have a page that has the following vars set:

$city and $state

I need include the page with array and if there's a match of this $city and $state get the value from the array and echo on the page.

Obviously first I need the best match, i.e. if both City and State match, if not if a state matches and if neither city nor state, see if NATIONWIDE is there. Nationwide can be present or not.

So, I've tried running a loop and preg_match but I think I'm on false track. It is starting to look a bit awkward:

foreach ($sj as $s) {
	if (preg_match('%<em>'.strtoupper($city.', '.$state).'</em><p>%', $s)) {
    	echo $spotlightProj;
		break;
	} elseif (preg_match('%<em>.*, '.$state.'</em><p>%', $s)) {
		echo $spotlightProj;
	} elseif (preg_match('%<em>NATIONWIDE</em><p>%', $s)) {
		echo $spotlightProj;
	}
}

Need some help here.

dagon

have you considered moving the data in to an db, it would be a loot easier to change\add\process

zzz

It probably would be easier, but I can't. I've got to work with this.

dagon

sqlite, i don't believe you have to work with that, you just don't know any better :-)

zzz

What's SQLite? Whatever... The array in the include file is used elsewhere and I just need to make use of it elsewhere. I don't have the time to re-write the existing functionality and am sure there's a way to implement my idea. Just need help.

Ahh, just googled for SQlite... No I don't use it. I use mySQL but not in this case...

BuzzPHP

Something like this should do the trick.

<?php
$sj[1] = '<em>SAN JOSE, CA</em><p>some text</p>';
$sj[2] = '<em>NATIONWIDE</em><p>some text</p>';
$sj[3] = '<em>NEW YORK, NY</em><p>some text</p>';
$sj[4] = '<em>PHOENIX, AZ</em><p>some text</p>'; 

function Find($city, $state)
{
  global $sj;
  $city = $city ? ">$city," : "unknown";
  $state = $state ? " $state<" : "unknown";
  foreach ($sj as $s) 
  {
    if (!$search1 && strripos($s, $city) && strripos($s, $state)) $search1 = $s;
    if (!$search2 && strripos($s, $state)) $search2 = $s;
    if (!$search3 && strripos($s, $city)) $search3 = $s;
    if (!$search4 && strripos($s, "NATIONWIDE")) $search4 = $s;
  }
  if ($search1) return $search1;
  if ($search2) return $search2;
  if ($search3) return $search3;
  if ($search4) return $search4;
}

echo Find("new york", "ny");
echo Find(null, "AZ");
echo Find(null, "CA");
echo Find(null, null);
echo Find("phoenix", null);
?>

The output is:

NEW YORK, NY
some text

PHOENIX, AZ
some text

SAN JOSE, CA
some text

NATIONWIDE
some text

PHOENIX, AZ
some text

zzz

Great! I need to show only one match. I'll try to figure this out now.