Array help

Asgardien

Hi guys
i am hoping that someone can give me a pointer on how to get data from an array into a mysql data base. the Array looks something like this.
array (
0 =>
array (
'id' => '4024',
'town_name' => 'BIRKENHEAD',
'active' => '1',
),
1 =>
array (
'id' => '4023',
'town_name' => 'CHESTER',
'active' => '1',
),
2 =>
array (
'id' => '3859',
'town_name' => 'ELLESMERE PORT',
'active' => '1',
),
3 =>
array (
'id' => '4065',
'town_name' => 'FLINT',
'active' => '1',
),
4 =>
array (
'id' => '3961',
'town_name' => 'LIVERPOOL',
'active' => '1',
),
5 =>
array (
'id' => '3962',
'town_name' => 'MOLD',
'active' => '1',
),
6 =>
array (
'id' => '3958',
'town_name' => 'ST HELENS',
'active' => '1',
),
)

I get the array from a CURL session from one of the Regiments computers. It is of no fixed length. All i need is a pointer in how to extract the data and pass it to a mysql database. Thanks in advance

jeepin81

Look into a foreach() loop.

ex:

foreach($urArr as $k=>$v){
  $sql = "INSERT INTO.....values('$v['id'],...)";

}

Bonesnap

Another common approach with a foreach loop when dealing with an array of arrays is to do something like this (I was never a fan of the $key => $value approach):

foreach($towns as $town)
{
    $sql = "INSERT INTO...VALUES(".$town['id'].", '".$town['town_name']."', ....)";
}

This just makes it a little more semantically pleasing and easier to read (and easier to debug if you run into problems).

Asgardien

Thanks for the reply guys, will give it try when we get back

Asgardien

how would i go about searching through the Array for a specific item, eg "town" and return all values that mach it ? and i am corect in thinking this is a multiple array or ?....

Derokorian

Asgardien;11005702 wrote:
how would i go about searching through the Array for a specific item, eg "town" and return all values that mach it ? and i am corect in thinking this is a multiple array or ?....

If you mean search through an array for a specific value of town, you can use [man]in_array/man. If you are looking for a specific key of town you can use [man]array_key_exists/man or [man]isset/man.

However if you are looking for any values that CONTAIN town, you will have to create your own function for that, possibly using [man]array_filter/man something a long the lines of:

$array = array('my town','downtown','nope','city');

print_r(array_filter($array, function ($var) {
   return (strpos($var,'town') !== FALSE);
}));

Asgardien

i have the following code, it works fine if the array is given ie

Array=array (
0 =>
array (
'id' => '4024',
'town_name' => 'BIRKENHEAD',
'active' => '1',
),
1 =>
array (

$searchfor = 'FLINT';

$heads = array_keys($data);
echo "<table border='1' cellpadding='2'>";
echo '<tr><th>' . join('</th><th>', $heads) . '</th></tr>';
foreach ($data as $array) {
if ($array['town_name'] == $searchfor)
echo '<tr><td>' . join('</td><td>', $array) . '</td></tr>';
}
echo '</table>';

but the array i have comes back from is $data=curl_exec($ch) and this gives errors.

PHP Warning: array_keys() expects parameter 1 to be array, string given in D:\wamp\www\php5298.tmp on line 34 PHP Stack trace: PHP 1. {main}() D:\wamp\www\php5298.tmp:0 PHP 2. array_keys() D:\wamp\www\php5298.tmp:34 PHP Warning: join() [function.join]: Invalid arguments passed in D:\wamp\www\php5298.tmp on line 36 PHP Stack trace: PHP 1. {main}() D:\wamp\www\php5298.tmp:0 PHP 2. join() D:\wamp\www\php5298.tmp:36 PHP Warning: Invalid argument supplied for foreach() in D:\wamp\www\php5298.tmp on line 37 PHP Stack trace: PHP 1. {main}() D:\wamp\www\php5298.tmp:0

anyone know Why, and how to resolve this ?