insert in database using array

[abhikerl]

hi, can anyone explain me how to insert data in the database using arrays. I know only how to insert using post method.

I am learning OOP in php. thanks

[trq]

Pretty vague question really.

 

$a = array('bob','marry','jane');
foreach ($a as $v) {
  $sql = "INSERT INTO users (name) VALUES ('$v')";
  mysql_query($sql);
}

[abhikerl]

Thanks for the answer but I wasn't clear enough. Actually, suppose I have a form with data which I want to insert in the database. We will use :

"mysql_query("INSERT INTO Persons (FirstName, LastName, Age)

VALUES ('Peter', 'Griffin', '35')");"

 

But I want to use array to insert this type of data..

[trq]

Still not clear enough. What does the array look like?

[PFMaBiSmAd]

Slightly off topic, but a person's age is not a constant unless they are dead. You should store the date of birth instead of their age. Use a DATE data type YYYY-MM-DD.