Array posted to MYSQL database

yoki

Hi,

Ok here is my problem. I have a script (I didn't write this as I'm new to PHP) that stores multiple variables into one (that's what I think). I would like to split this variable into different fields in my mysql database. Here is a portion of the code:

foreach($VARS as $key=>$value)
{
if (is_array($value)) $value=implode(',',$value);
$tpl.="$key: $value |";
}

Say for example in $VARS there is a field called "Last_Name" which is $key1, how would I be able to post it in a field in mysql.

I'm not sure if i'm clear enough...Hope someone understands...

wilku

You've got to reverse the process:

$vars = explode("|", $tpl);
$results=array();
foreach ($vars as $var)
{
  list($key,$value) = explode(": ", $var);
  if ($key !="")
  {
     $results[$key] = $value;
  }
}
//do the insert or update with the values from $results

yoki

Hi Wilku,

Thanks for the answer. Here is what I've done:

foreach($VARS as $key=>$value)
{
if(is_array($value)) $VARS[$key]=explode(' ',$value);

echo $FIELDS.="$key : ".$VARS[$key]."\r\n";
}

I get the following output from the fields in my form:

Attending_ESC_Congress : Array
Last_Name : Emmanuel
First_Name : Dauksa

Attending_ESC_Congress is a checkbox in my box and contains the value Yes once it's checked. Somehow there is a parsing of the checkbox that transforms it as an array. Would you know how I can read the value instead of getting array?