PHP Array to mySql Database

[mranderson1137]

OK guys:

I have a PHP array that gets the field names and the field values from one of my contact forms:

foreach ($_POST as $key => $value)
{
    if (!is_array($value))
    {
        $data .= "\n \n".$key." : ".$value;
    }
    else
    {
        foreach ($_POST[$key] as $itemvalue)
        {
            $data .= "\n \n".$key." : ".$itemvalue;
        }
    }
}

Now I need to break out the values to put into my SQL database.

I am using MySQL for the database and I am not using all the values in the array to post to the database which is adding (at least for me a php noobie) some complexity to the problem. Obviously the id field in the database is my index and is not in the array.

The MySql database table structure looks like this:

id,
name,
address,
city,
state,
zip,
phone,
email,
arrivaldate,
depratdate,
room,
foundus,
promocode,
comments,
date,
ip

Just how would I go about this?

[Dormilich]

Obviously the id field in the database is my index and is not in the array.

if it’s set to AUTO_INCREMENT it will be automatically set and you don’t need to pass it.

[mranderson1137]

Yes I know about the ID field that was just comment so folks would not have to worry about pulling that out of the array. I need to know how to break the array apart to get the values of the array into my database.