Insert date in mysql using html5 input tag

Question

<!DOCTYPE html>
<html>
<head>
<title>Form</title>
</head>
<body>
<form action="collect.php" method="post">
date:<input type="date" name="date"/><br/>
<input type="submit"/><br/>
</form>
</body>
</html>

This form accepts date and sends it to collect.php which is as follows

<?php
$connect=mysqli_connect("localhost","root","");
if(mysqli_connect_error()){
echo "Databse connect error";
die();
}
else echo "successfully connected <br/>";
$date=$_POST['date'];
$adddate="INSERT INTO `testform`.`date`(date) VALUES(".$date.")";
$result=mysqli_query($connect,$adddate);
if($result==TRUE)
    echo "date added asuccessfully";
else echo "problem in date";
?>

The problem is that it echos date added successfully but when i check in my phpmyadmin result is 0000-00-00 I don't understand the reason.Have tried almost everything i could.please help...

Please read about SQL Injection and update your code accordingly. — Jason McCreary
– Jason McCreary, Commented Sep 10, 2013 at 17:50
when i am not allowing the user to input anything else but date,how can there be sql injection?@JasonMcCreary — Bhushan
– Bhushan, Commented Sep 10, 2013 at 17:55

Hanky Panky · Accepted Answer · 2013-09-10 17:47:32Z

1

Add Quotes around your date

$date=mysqli_real_escape_string($connect,$_POST['date']);
$adddate="INSERT INTO `testform`.`date`(date) VALUES('".$date."')";
                                                     ^         ^

answered Sep 10, 2013 at 17:47

Hanky Panky

46.9k9 gold badges76 silver badges95 bronze badges

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

Collectives™ on Stack Overflow

Insert date in mysql using html5 input tag

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related