Insert datetime into database PHP

Question

I have some difficulties with inserting date (type: datetime) into my database. Whatever I put there, it throws me syntax errors about the date format etc. Could someone help me please?

DB::insert('INSERT INTO hidden_authors (e_user = ? AND h_user = ? AND h_change_time = ?)', array($userBanId, $id, date(Y-m-d H:i:s) ));

I have already tried to use sql getdate() but it also gives me an error.

It looks like e_user.h_change_time should be a timestamp field in the database anyway - with ON UPDATE CURRENT_TIMESTAMP ... which would make this entire question moot. — CD001
– CD001, Commented Oct 13, 2015 at 12:21

Abdulla Nilam · Accepted Answer · 2015-10-13 12:24:29Z

6

Error Because of missing " inside date() function.

change this to

date(Y-m-d H:i:s)

this

date("Y-m-d H:i:s")

So final Well Form code should be

DB::insert('INSERT INTO hidden_authors (e_user = ? AND h_user = ? AND h_change_time = ?)',array($userBanId, $id, date("Y-m-d H:i:s")));

PHP date() Function

Tip For Your Code:

Without add exact function in query, assign that to variable and call it to your query

Example :

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

So inside Query

DB::insert('INSERT INTO hidden_authors (e_user = ? AND h_user = ? AND h_change_time = ?)',array($userBanId, $id, $date));

So when you read that insert function you can get clear idea about

what you did?

what you need to do?

where is the error??

Its simply point all of these questions

edited Oct 13, 2015 at 12:24

answered Oct 13, 2015 at 12:11

Abdulla Nilam

39.7k18 gold badges85 silver badges115 bronze badges

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

3 Comments

WantToBeProgrammer Over a year ago

Thank you for a great answer. Unfortunately i still have a syntax error around h_change_time. Do you know why?

Abdulla Nilam Over a year ago

Try this (new)

DB::insert('insert into hidden_authors (e_user, h_user,h_change_time ) values (?, ?, ? )', array($userBanId, $id, $date));

Abdulla Nilam Over a year ago

updated new insert use this

DB::insert('insert into hidden_authors (e_user, h_user,h_change_time ) values (?, ?, ? )', array($userBanId, $id, $date));

Niranjan N Raju · Accepted Answer · 2015-10-13 12:46:36Z

3

you have missed quotes for your date(). This should help you.

DB::insert('INSERT INTO hidden_authors (e_user = ? , h_user = ? , h_change_time = ?)',
     array($userBanId, $id, date("Y-m-d H:i:s") ));
                                 ^           ^

edited Oct 13, 2015 at 12:46

answered Oct 13, 2015 at 12:10

Niranjan N Raju

12k4 gold badges24 silver badges41 bronze badges

7 Comments

Ashish Choudhary Over a year ago

Its always a good practice to use single quotes rather than double quotes where we have any PHP code in a string. PHP parses everything inside double quotes therefore takes more time to dun the same script comparing to the one having single quotes

Niranjan N Raju Over a year ago

i added double coz, he has single quotes in his query.

Ashish Choudhary Over a year ago

that wont bother. PHP will parse date function string separately

WantToBeProgrammer Over a year ago

Thank you for a great answer. Unfortunately i still have a syntax error around h_change_time. Do you know why?

Niranjan N Raju Over a year ago

replace and my comma ,

|

Sergynyo · Accepted Answer · 2015-10-13 13:22:02Z

1

mysql datetime NOW()

DB::insert('INSERT INTO hidden_authors (e_user = ? AND h_user = ? AND 
h_change_time = ?)', array($userBanId, $id, NOW() ));

answered Oct 13, 2015 at 13:22

Sergynyo

113 bronze badges

Collectives™ on Stack Overflow

Insert datetime into database PHP

3 Answers 3

Tip For Your Code:

3 Comments

7 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Tip For Your Code:

3 Comments

7 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related