Updating database with php and mysqli

Question

I am trying to update the last login date in my database each time a user logs into the website. It currently updates the LastLogin with a null value?

Why does the below code not work?

$this->mysqli->query("Update adminusers SET LastLogin = DATE('yyyy-mm-dd') WHERE Username = 'admin'");

Thanks!

RTFM? dev.mysql.com/doc/refman/5.5/en/…

Marc B
– Marc B

2014-12-02 20:04:24 +00:00
Commented Dec 2, 2014 at 20:04 — Marc B
– Marc B, Commented Dec 2, 2014 at 20:04
@Rafael session value of the current date ? eh why ??

user557846
– user557846

2014-12-02 20:07:22 +00:00
Commented Dec 2, 2014 at 20:07 — user557846
– user557846, Commented Dec 2, 2014 at 20:07

D_R · Accepted Answer · 2014-12-02 20:05:07Z

1

You are not using the DATE() function properly. You should use CURDATE() for current date in yyyy-mm-dd format

$this->mysqli->query("UPDATE adminusers SET LastLogin = CURDATE() WHERE Username = 'admin'");

answered Dec 2, 2014 at 20:05

D_R

4,9724 gold badges47 silver badges62 bronze badges

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

1 Comment

user557846 Over a year ago

DATE(NOW()) should be CURDATE()

Collectives™ on Stack Overflow

Updating database with php and mysqli

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related