Inserting Date from form using PHP Mysql

Question

I can not seem to get the date to insert from my form into my data base. Please help!

here is my form

echo '

<h1>Enter New Report</h1>
<form action="submitreport.php" method="post"
enctype="multipart/form-data">

 Date: <input type="text" name="Date" value='.$myDate.' /><br />
 Report:<br><TEXTAREA NAME=Report ROWS=4 COLS=40></TEXTAREA><br />
 <input type="submit" name="submit" value="Submit" />
 </form>

 ';
 ?>

Here is what I have written to submit it to the database

$insertdate = trim($_POST['Date']);

$insertdate = mysql_real_escape_string($insertdate);
    $insertdate = date('m/d/Y', $insertdate);

echo $insertdate;


mysql_query("INSERT INTO `Reports`(`Date`, `Report`) VALUES ('$insertdate','$_POST[Report]')") or die("load1 -" .  mysql_error());


mysql_close();

echo "Thank You!" . " -" . "<a href='index.php' style='text-decoration:none;color:#ff0099;'> Return Home</a>";
?>

does $myDate contain timestamp? otherwise date function will return false or raise a WARNING message. use strtotime when passing parameter to date — haynar
– haynar, Commented Oct 4, 2012 at 14:10
What half-assed book/site taught you mysql_query? It's been (at least unofficially) deprecated for years now. Check out PDO and mysqli. — cHao
– cHao, Commented Oct 4, 2012 at 14:37
Please don't use mysql_* functions in new code. They were removed from PHP 7.0.0 in 2015. Instead, use prepared statements via PDO or MySQLi. See Why shouldn't I use mysql_* functions in PHP? for more information. — tereško
– tereško, Commented Oct 4, 2012 at 15:25

newfurniturey · Accepted Answer · 2012-10-04 14:10:18Z

3

I'm only guessing, but your Date field in the database is either of type date or datetime. The format of these are YYYY-mm-dd. Try changing your code to:

$insertdate = date('Y-m-d', strtotime($_POST['Date']));

Also, you aren't converting the date to a timestamp before formatting it. I've added strtotime() on the data here as well.

answered Oct 4, 2012 at 14:10

newfurniturey

38.6k10 gold badges99 silver badges104 bronze badges

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

1 Comment

newfurniturey Over a year ago

It's the same as what you posted in your answer (except all in one line), so I should hope it works too =P

Zulakis · Accepted Answer · 2012-10-04 14:09:42Z

2

PHP's date needs a timestamp as second parameter. If $insertdate isn't one it won't work. You can though get a timestamp from a string using PHP's strtotime() function.

Also, the value in your sql statement must be formatted according to the type used in your mysql database, for example date, datetime or timestamp

answered Oct 4, 2012 at 14:09

Zulakis

8,46212 gold badges45 silver badges70 bronze badges

2 Comments

Steven Over a year ago

I still do not know why the default of mysql is Y-m-d but changing the format of my date and using the strtotime() function fixed the problem.

newfurniturey Over a year ago

Actually, the second parameter to date() is optional - without one, it will give you the current date/time. If you specify one it needs to be a Unix-timestamp.

james_tookey · Accepted Answer · 2012-10-04 14:09:45Z

0

You can use the NOW() MySQL function to insert the current date/time into the database. You'll just need to be using the Date, DateTime or Timestamp field types for this to work.

answered Oct 4, 2012 at 14:09

james_tookey

9056 silver badges12 bronze badges

1 Comment

Steven Over a year ago

I was using the date('m/d/Y') function just to put todays date in the form however I needed it to be allowed editing.

Steven · Accepted Answer · 2012-10-04 14:11:55Z

0

I got it $insertdate = trim($_POST['Date']);

$insertdate = mysql_real_escape_string($insertdate);
$insertdate = strtotime($insertdate);

    $insertdate = date('Y-m-d', $insertdate);

The strtotime fixed it but I had to rearrange the date format to Y-m-d

Thank you for the help

answered Oct 4, 2012 at 14:11

Steven

611 gold badge3 silver badges13 bronze badges

Collectives™ on Stack Overflow

Inserting Date from form using PHP Mysql

4 Answers 4

1 Comment

2 Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

2 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related