Get Key from Array Value

Question

Get Key from Array Value

Pudsters (TechnicalUser)

(OP)

1 Dec 18 20:03

What am I doing wrong? I have 4 salesman ID's and the cities they cover in an array called "cities". How do I obtain the Salesman ID based on the city entered in a form, Field-name "city"? I don't know how to search through an array inside of another array.

CODE --> php

$cities = array (
  0 => array("Aldenville", "Analomink"),
  1 => array("Abington", "Ambler", "Ardmore", "Avondale"),  
  2 => array("Ackermanville", "Albrightsville", "Allens Mills", "Alpha"),
  3 => array("Adamstown", "Alburtis", "Allentown"));   

if (($key = array_search($_POST['city'], $cities)) === false) {
    echo "Not found";
} else {
    echo $key;
}

prex1 (Programmer) · Answer 1 · 2018-12-02 13:21:34

I can't see a way, other than cycling over all of the cities of the array.
IMHO you are using the wrong array structure. You should have an array with the city name as the key and the corresponding salesman as the value. This would let you search by salesman, cycling with array_search, and of course to search by city. This structure would also avoid having two salesmen for the same city, condition that I assume you don't want.

https://www.xcalcs.com : Online engineering calculations
https://www.megamag.it : Magnetic brakes for fun rides
https://www.levitans.com : Air bearing pads

Pudsters (TechnicalUser) · Answer 2 · 2018-12-02 16:34:01

I think I will just break it up into 4 different arrays, one for North, South, East, and West cities, like this. The finished project will end up having hundreds of cities:

CODE --> php

$northCities = array("Aldenville", "Analomink", "Archbald");
$arrlength = count($northCities);
    
    for($i = 0; $i < $arrlength; $i++) {
	
	   if (($_POST['state'] == "PA" || $_POST['state'] == "NJ") && $northCities[$i] == $_POST['city']) {	
	   	  $myBcc = $salesNorth;	   
		  $salesman = $salesmanNorth;	
	   } else {	
	     $myBcc;	
	   }                
    }

Come Join Us!

Posting Guidelines

Jobs

Get Key from Array Value