CODEWITHSUNDEEP
phpmysqldatetimesql-insert
TheViralGriffin
TheViralGriffin

Reputation: 441

Inserting time into database

The below piece of code isn't working the way it is supposed to

$t = date('Y-d-m H:i:s',time());
$query = "INSERT INTO time VALUES('$t')";
if(mysql_query($query))
echo "Date and Time are added";

I have created a table named time with only one column now and DATETIME as datatype. Even though the PHP script executes successfully in the browser by printing "Date and Time are added".

The database isn't updating the way it is supposed to be. Rather than the current time, it gets initialized to default value.

Do suggest the way to rectify the problem.

Upvotes: 1

Views: 32931

Answers (4)

Vagabond
Vagabond

Reputation: 897

Change the value of $t from

$t = date('Y-d-m H:i:s',time());

to

$t = date('Y-m-d H:i:s');

Even better method would be to write your insert query like this:

   $query = "INSERT INTO `time` VALUES ('".date('Y-m-d H:i:s')."')";

Upvotes: 1

Sadikhasan
Sadikhasan

Reputation: 18600

Try with this format

$t = date('Y-m-d H:i:s');
$query = "INSERT INTO time (now) VALUES('$t')";
if(mysql_query($query))
echo "Date and Time are added";

OR

$query = "INSERT INTO time (now) VALUES(NOW())";

Upvotes: 0

Grand Marshal Braev
Grand Marshal Braev

Reputation: 283

<?php

/* YOU NEED TO ESTABLISH FIRST A CONNECTION */

$con=mysqli_connect("Host","Username","Password","Database"); /* REPLACE THE NECESSARY HOST, USERNAME, PASSWORD, AND DATABASE */

if(mysqli_connect_errno()){

echo "Error".mysqli_connect_error();
}

$t = date('Y-d-m H:i:s');
$query = mysqli_query($con,"INSERT INTO time (now) VALUES ('$t')");
echo "Date and Time are added";

?>

Upvotes: 0

Companjo
Companjo

Reputation: 1792

You can use NOW()

$query = "INSERT INTO `time` (`now`) VALUES (NOW())";

Upvotes: 2

Related Questions