Sikander Sikander - 4 years ago 141
SQL Question

PHP : comparing fetched date with today

i'm saving time for first login ,now when user logs in i enter time using NOW() function, that saves time in this format (data type is DATETIME.

2015-12-24 15:47:30

Now logic is like every login is first login so i've to check if there already exists an entry for today to check that i fetch time explode it and get time like this

$logintime= mysqli_query($connection,"SELECT loggedin from employees");
$loggedin_time= mysqli_fetch_assoc($logintime);
$Date = $loggedin_time['loggedin'];
$loggedin_time_converted= explode(" ",$yourDate) ;
$ConvertedDate = $loggedin_time_converted[0];

last line returns 2015-12-24 now i've date

$today= time();
$DateToday= date("Y-m-d",$today);

$DateToday also returns me same format and same date now i need your help me to compare these dates , if they are equel i dont uopdate database if they are not i will , Pleas help me how do i compare these values

Answer Source

You can do the test in MySQL

$result = mysqli_query($connection, "SELECT DATE(loggedin) = CURDATE() AS logged_in_today FROM employees");
$row = mysqli_fetch_assoc($result);
if (!$row['logged_in_today']) {
    // code to update database
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download