How to save date of user login into another table using php and Mysql

by

You can use this logic to achieve your functionality

<?php 
  $todayDate = date('Y-m-d');
  //modify this query based on your framework
  $userTodayResult = "select * from user_login where user_id = ".$userId." and login_date = "$todayDate"";


if(empty($userTodayResult)){
  //insert your record with today date 
}
?>

More Related Contents:

  1. php+mysql Fatal error: Call to undefined function mysql_connect()
  2. Using PHP data in MySQL [closed]
  3. drop down menu using php and mysql [closed]
  4. php code for multiple search box after connecting to mysql [closed]
  5. Checking the availability of rooms
  6. How to sort user data by id
  7. Select those record only from table 1 where city exist against state id in table 2 in PHP
  8. PHP + MySQL transactions examples
  9. How to display errors for my MySQLi query? [duplicate]
  10. How to retrieve images from MySQL database and display in an html tag
  11. Automated or regular backup of mysql data
  12. Fatal error: Call to undefined function session_register()
  13. PHP: Warning: sort() expects parameter 1 to be array, resource given
  14. PHP date() format when inserting into datetime in MySQL
  15. Special characters in PHP / MySQL
  16. Fetching single row, single column with PDO
  17. MySQL db question marks instead of hebrew characters..?
  18. IP address storing in MySQL database using PHP [duplicate]
  19. How I can create installer for website. PHP mysql [closed]
  20. “No such file or directory” or “No such host is known” when running migrations
  21. How to convert IPv6 from binary for storage in MySQL
  22. mysqli – fetch_Array error call to a member function fetch_array() on a non-object mysqli [duplicate]
  23. How can I do a migration in laravel 5.5?
  24. Best way to store IP in database?
  25. Which is fastest in PHP- MySQL or MySQLi?
  26. How to get last inserted id from table MySQL [duplicate]
  27. Is mysql_real_escape_string enough to Anti SQL Injection?
  28. How can I list data in sections by an ID, with a while loop in PHP? [closed]
  29. Save array in mysql database
  30. find in set in laravel ? example

Leave a Comment