PHP inserting the type datetime into sql

Question

I have made a sql row as type: datetime.

The input for datetime should be like: 2013-02-02 10:13:20

You get the drill like: 0000-00-00 00:00:00

Now In php I use date("Y-m-d H:i:s");(current date and time) to insert it into my database. There are other variables as well. Those variables get inserted,but the datetime row stays: 0000-00-00 00:00:00

I first got this code when everything except the date worked:

$resultaat = $mysqli2->query("INSERT INTO questions  (title, description, username, date_made) VALUES ('" . $title . "','" . $description . "', '".$username ."','".date("Y-m-d H:i:s")."')");

but all the information in the databases will get "" around them.(Which could have caused the date to jump to 0000-00-00 00:00:00

Now when I try to insert again with other information, it wont even insert anymore. My problems:

What is the real problem for the date to set to 0000-00-00 00:00:00? Is it the automatic ""?
If it is the "", how can I lose them?

EDIT:

Nvm I lost the "" It wasn't the problem that cause the insert to fail at the second try. - Why wont it insert in it anymore after I inserted once?

Now these aren't really different questions because it's about the same problem but here's my code and yes I know SQL Injection, I'll fix it later:

if (isset($_POST['title'])) {
$alles_goed=true;
$description=$_POST['description'];
$title=$_POST['title'];
$username=$_SESSION['username'];

if ($title=''){ 
$alles_goed=false;
echo'title is empty';
}

if($alles_goed==true){
    $resultaat = $mysqli2->query("INSERT INTO questions  (title, description, username, date_made) VALUES ('" . $title . "','" . $description . "', '".$username ."','".date("Y-m-d H:i:s")."')");

}
}

Store date("Y-m-d H:i:s") value in a variable and assign to it and check whether it is inserting — Saranya Sadhasivam
– Saranya Sadhasivam, Commented Sep 26, 2013 at 7:34

sskoko · Accepted Answer · 2013-09-26 07:37:05Z

5

Try this:

$a=date("Y-m-d H:i:s");
if (!$resultaat = $mysqli2->query("INSERT INTO questions  (title, description, username, date_made) VALUES ('$title','$description','$username','$a')"))
{
   printf("Errormessage: %s\n", $mysqli2->error);
   exit;
}

and check if there is any error produced.

As to why is inserting it only once, you might have unique field.

answered Sep 26, 2013 at 7:37

sskoko

8397 silver badges18 bronze badges

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

8 Comments

Loko Over a year ago

I really have no idea what fixed it but when I did this. (Btw you forgot the "") it worked, but I already tried to put the date("y-m-d h:i:s") in a variable. I think I fixed it myself but I dont know how.

sskoko Over a year ago

Where did I forgot "" ?

Loko Over a year ago

VALUES ('" . $title . "','" . $description . "', '".$username ."','".$a."')"

sskoko Over a year ago

I didn't. My query is perfectly legal without "". Try it yourself.

sskoko Over a year ago

In PHP, you can put variable inside double quotes. Try it for yourself.

|

Shankar Narayana Damodaran · Accepted Answer · 2013-09-26 07:32:45Z

5

Just use a now() on MySQL

$resultaat = $mysqli2->query("INSERT INTO questions  (title, description, username, date_made) VALUES ('" . $title . "','" . $description . "', '".$username ."',now()");

answered Sep 26, 2013 at 7:32

Shankar Narayana Damodaran

68.6k43 gold badges102 silver badges129 bronze badges

Collectives™ on Stack Overflow

PHP inserting the type datetime into sql

2 Answers 2

8 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

8 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related