CODEWITHSUNDEEP
phpmysql
Patricia Erika Dela Cruz
Patricia Erika Dela Cruz

Reputation: 7

Date time values incorrect on MySQL database

I don't know where the problem is within my code. I am trying to insert a value from datetime picker. But as it's saved into the MySQL database, the date value is 1970-01-01.

Here is my code:

<?php

    $FirstName=$_POST['fname'];
    $LastName=$_POST['lname'];
    $AreaCode=$_POST['acode'];
    $PrimaryPhone=$_POST['pphone'];
    $AlternatePhone=$_POST['aphone'];
    $EmailAddress=$_POST['email'];
    $CompanyName=$_POST['cname'];
    $StreetAddress=$_POST['saddress'];
    $BrgyCityProvince=$_POST['province'];
    $ZipCode=$_POST['zcode'];
    $rdate= "rawdate";
    $cdate= strtr($rdate, '/', '-');
    $Date= date('Y-m-d', strtotime($cdate));


    $sql = "Insert into bill values('','$FirstName','$LastName','$AreaCode','$PrimaryPhone','$AlternatePhone','$EmailAddress','$CompanyName','$StreetAddress','$BrgyCityProvince','$ZipCode', '$Date')";

    $query = mysql_query($sql);

    if(!$query)
        echo mysql_error();
    else
    {
        echo "Successfully inserted";
    }
?>

Upvotes: 0

Views: 147

Answers (1)

moni_dragu
moni_dragu

Reputation: 1163

Don't use quote around your variable in strtotime.

 $Date = date('Y-m-d', strtotime($cdate));

Upvotes: 3

Related Questions