How to insert date to MySQL from html input?

Question

I've problem with inserting a date enter code hereinto a MySQL database. On my webpage i've got a input which type is 'date' but there is a problem with inserting value of this input into database properly.

$connection->query("INSERT INTO users VALUES(NULL, '$nick', '$password_hash', '$email',".$_POST['gender'].",".$_POST['bday'].")")

Have you got any solution for my problem?

Apart from the answers given, make sure your post is the same format as MySQL needs it (yyyy-mm-dd). If it's not, use PHP's date() function to change it. — Muhammad Ali
– Muhammad Ali, Commented Jul 23, 2016 at 11:32

Devsi Odedra · Accepted Answer · 2016-07-23 11:25:22Z

1

Use this code. you forget Single quote (').

$connection->query("INSERT INTO users VALUES(NULL, '$nick', '$password_hash', '$email','".$_POST['gender']."','".$_POST['bday']."')")

answered Jul 23, 2016 at 11:25

Devsi Odedra

5,3421 gold badge25 silver badges38 bronze badges

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

Comments

Niklesh Raut · Accepted Answer · 2016-07-23 11:25:08Z

1

Use single quotes around date value and using column name is good practice

 $connection->query("INSERT INTO users VALUES(NULL, '$nick', '$password_hash', '$email','".$_POST['gender']."','".$_POST['bday']."')")

answered Jul 23, 2016 at 11:25

Niklesh Raut

34.9k17 gold badges82 silver badges112 bronze badges

Comments

saira · Accepted Answer · 2016-07-23 11:36:23Z

0

try this code, single quotes around the variables and I don't see the need of writing $_POST[], because you can access the variables simply by using their name

$connection->query("INSERT INTO users VALUES(NULL, '$nick', '$password_hash', '$email','$gender,'$bday'"));

answered Jul 23, 2016 at 11:36

saira

236 bronze badges

Comments

H. Pauwelyn · Accepted Answer · 2016-07-23 12:05:34Z

0

You incorrect syntax of MySQL

$connection->query("INSERT INTO users VALUES(NULL, '$nick', '$password_hash', '$email',".$_POST['gender'].",".$_POST['bday'].")")

Correct syntax

INSERT INTO table_name (column1, column2, column3,...)
VALUES (value1, value2, value3,...)

Link refe: http://www.w3schools.com/php/php_mysql_insert.asp

I hope help you

edited Jul 23, 2016 at 12:05

H. Pauwelyn

14.4k28 gold badges93 silver badges164 bronze badges

answered Jul 23, 2016 at 11:27

hunglevan

1094 bronze badges

Comments

satish kilari · Accepted Answer · 2016-07-23 12:28:33Z

0

$connection->query("INSERT INTO users VALUES(NULL, '$nick', '$password_hash', '$email','".$_POST['gender']."','".$_POST['bday']."')")

answered Jul 23, 2016 at 12:28

satish kilari

7284 silver badges23 bronze badges

Collectives™ on Stack Overflow

How to insert date to MySQL from html input?

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related