recurring system my sql query [closed]

by

Make another table called payments which has
– id of payment
– userid of user
– date they last paid
– length of payment

Then, to check when a user’s set to expire,

SELECT date+length as expy FROM payments WHERE userid = $userid ORDER BY date DESC LIMIT 1

Store dates & lengths as unix time (number of seconds). If time > expy then their subscription is expired.

More Related Contents:

  1. Trying to Show 87 mysql rows in 3 html tables using PHP and mysql [closed]
  2. While loop inserts three times
  3. Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in? [duplicate]
  4. Selecting events between dates in mysql
  5. A list of php error [closed]
  6. Laravel one to many relation with a one to one relation
  7. Thank you for helping [closed]
  8. How can create Database using url or other method [duplicate]
  9. How to create email notification with login users on PHP an MySQL [duplicate]
  10. PHP display image BLOB from MySQL [duplicate]
  11. LIMIT keyword on MySQL with prepared statement [duplicate]
  12. Is mysql_real_escape_string() broken?
  13. How to setup ElasticSearch index structure with multiple entity bindings
  14. Export MySQL database using PHP [closed]
  15. How to add new column to MYSQL table?
  16. WAMP/MySQL errors not in correct language
  17. Get Updated Value in MySQL instead of affected rows
  18. Category Hierarchy (PHP/MySQL)
  19. Alternative for mysql_num_rows using PDO
  20. How Can I Set the Default Value of a Timestamp Column to the Current Timestamp with Laravel Migrations?
  21. Warning: mysqli_query() expects parameter 1 to be mysqli, resource given [duplicate]
  22. How to escape single-quote (apostrophe) in string using php
  23. How to create PHP two column table with values from the database?
  24. Best way to connect to MySQL with PHP securely [duplicate]
  25. mysqli persistent connection
  26. selected value get from db into dropdown select box option using php mysql error
  27. SELECT row by DATEPART()
  28. UTF-8 not working in HTML forms
  29. Using mysql concat() in WHERE clause?
  30. Check if laravel model got saved or query got executed

Leave a Comment