posting array to MySQL

Question

How can insert a array into my MySQL database?

I have managed to insert some of this data into the database already.

Below is part of my code:

$depart=serialize($_POST['departure']); 
$sql="INSERT INTO bookings VALUES('$depart');

I am trying to insert

[departure] => Array ( [0] => 30 [1] => 05 [2] => 2011 [3] => 17 [4] => 41 )

into the database field 'depart'

your help will be much appreciated.

I forgot to mention the data I am trying to insert is from a form, the values in the above array was received from var_dump after form was submitted. — Novice_2011
– Novice_2011, Commented May 31, 2011 at 9:52
You'd better to convert the array to date-time and save it in a datetime field. — Toto
– Toto, Commented May 31, 2011 at 9:58
note you can format lines as code by indenting them four spaces. The "{}" button in the editor toolbar does this for you. Someone did it for you this time, but next time try it yourself. Click the orange question mark in the editor toolbar for more information and tips on formatting. — outis
– outis, Commented May 31, 2011 at 10:02

GolezTrol · Accepted Answer · 2011-05-31 09:58:48Z

1

Assuming 'depart' is a datetime field:

$timestamp = mktime($depart[3], $depart[4], 0, $depart[2], $depart[1], $depart[0]);

$sql = "insert into bookings(depart) values (from_unixtime($timestamp))";

// Execute the sql as normal

answered May 31, 2011 at 9:58

GolezTrol

116k19 gold badges186 silver badges215 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Emil Ahlbäck · Accepted Answer · 2011-05-31 10:01:01Z

1

You should escape your serialized array string.

$depart=mysql_real_secape_string(serialize($_POST['departure']));

answered May 31, 2011 at 10:01

Emil Ahlbäck

6,2268 gold badges41 silver badges55 bronze badges

Collectives™ on Stack Overflow

posting array to MySQL

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related