Updating Database

Iquil

How would I go about updating a database using an array? All the data is needed is within the array. I'm just not sure how I would be able to separate the data into the "sections" it needs to be in.

Array Example:

Array
(
    [1] => Array
        (
            [0] => 1                                      //This would be the info needed
            [1] => SLL
            [2] => 
            [3] => 0000
            [4] => Shallah, Oman
        )

[2] => Array
    (
        [0] => 1                                      //This would be the info needed
        [1] => LBS
        [2] => 
        [3] => 0000
        [4] => Lubeck, Germany
    )

[3] => Array
    (
        [0] => 1                                      //This would be the info needed
        [1] => FSC
        [2] => 
        [3] => 0000
        [4] => Figari, Corsica, France
    )

[4] => Array
    (
        [0] => 1                                      //This would be the info needed
        [1] => BGF
        [2] => 
        [3] => 0000
        [4] => Bangui, Central African Republic
    )
)

devinemke

are those array keys the primary key values from your table? if so then something like:

foreach ($array as $key => $value)
{
	foreach ($value as $subkey => $subvalue) {$value[$subkey] = "'" . addslashes($subvalue) . "'";}
	$sql = 'UPDATE table VALUES(' . implode(', ', $value) . ') WHERE id = ' . $key;
	// run the query here	
}

Iquil

Thats worked thank you devinemke.
Is there a way to show on screen to the user that the query has gone through?

e.g.

if($blah == true){
   echo "Query Successful";
} else {
   echo "Query Failed";
}

Or is that all I need to do?

TobyRT

for error checking, i'd put an "or die()" statement after the SQL included in devine's post (i know he just forgot it 😛), then if it DOES go wrong at any point, you can see exactly why.

As for the confirmation request, you just need something like

if (!$sql)
{
echo 'Sorry, there was a problem, please contact Iquil';
}
else
{
echo 'Update Successful, click here to return to the admin menu';
}

Iquil

ok cool thank you TobyRT