how to delete 30 day old data using PHP [closed]

You’re adding an extra wp_ prefix to your table and your using a timestamp instead of a MYSQL datetime. Below is how WP suggests you use $wpdb->query to delete rows, taken from the codex.

EDITED

global $wpdb;

$wpdb->query(
  "DELETE FROM " . $wpdb->prefix . "userinfo
   WHERE timeall < DATE_SUB(CURDATE(),INTERVAL 30 DAY)"
);

$wpdb->prefix adds the wp_ for you.

Related Posts:

  1. $wpdb->get_results(…) returns empty array despite correct query
  2. WPDB: how to get the value of a field in a custom database table
  3. Get stock by custom meta field on all Woocommerce variable products
  4. Display fields as values in array from external SQL DB
  5. Querying wpdb using PHP
  6. $wpdb->insert() does not Insert record in a table
  7. Use $wpdb or other PHP script method to find/replace in WP database
  8. How can I add a new row in a separate database when someone registers via WordPress?
  9. PHP -> SQL Query with Summing
  10. Why my query does not run with prepare
  11. wpdb getting avatars and author url
  12. WordPress SQL JOIN query
  13. Fetching review value using wpdb class
  14. Database SQL query error
  15. WordPress SQL Prepare
  16. Creating multiple tables with Plugin
  17. Querying multiple meta_keys in WordPress SQL query
  18. Can’t send form data to wpdb when URL has query string
  19. How to get the list of WooCommerce product image of a certain category from database?
  20. Alter query on edit.php
  21. queries inside of a class
  22. How to Join two tables from separate databases within WordPress
  23. Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
  24. Enhanced WordPress Search
  25. Automatically generate Post/Page from searched Database item?
  26. register_activation_hook isn’t adding table to DB
  27. How to display posts of specific category using a custom Query in WordPress?
  28. Renaming post IDs – Okay to do?
  29. How to generate page content from database the right way?
  30. Ajax $wpdb not returning table data
  31. Converting MYSQL to WordPress $WPDB
  32. How to Fetch values from WP database based on selected option value by onchange using PHP?
  33. phpMyAdmin displays error when importing database
  34. Preferred Method of debugging a wordpress SQL calls?
  35. Why is variable not working on custom sql query using wpdb?
  36. Can’t get wp_insert_post to work
  37. Trying to establish connection to External Database
  38. Getting id of poll from WP database
  39. How to insert a single row to WP database table?
  40. I want to select the from values from database in WordPress? [closed]
  41. Importing Geo data into wordpress database
  42. $wpdb->update with multiple parameters gives error
  43. WP_Query adds “(wp_posts.ID = ‘0’)” so no results are returned
  44. wp query foreach deleting record returning only first or last item
  45. Using $wpdb (WPDB class) ‘replace’ with multiple WHERE criteria problem
  46. Error using WordPress $wpdb object to get result from custom table
  47. How to retrieve the data from the sever and displaying it in a page?
  48. how to get serialized post meta
  49. How to Update post_modified of all wordpress post
  50. Basic wpdb update question
  51. wpdb Cannot Update column in Database
  52. Lost in trying to create user database system
  53. Pull MySQL data from multiple tables and merge into 1 PHP array
  54. Cannot access $wpdb, comes back NULL
  55. How do I prepare strings for insertions as values into a MySQL table?
  56. WPDB – Read and write value from / to database
  57. form $_post action value gets truncated after it passes through two forms
  58. How to Generate a list of Most Commented post?
  59. Why won’t this wpdb get_results query return results?
  60. Undefined variable: row?
  61. Add row to custom database Table and delete all rows older than 1 day
  62. select a single val though a table in wordpress
  63. making php value numeric
  64. Using color schemes with Color Picker
  65. populate select options from extra mysql table data
  66. quotes problem in very simple sql
  67. Add posts to custom table in database instead of wp_posts
  68. get_terms with specific id order
  69. get different meta-data of a complicated query at the same time
  70. Build A Custom SQL Query for WordPress Search
  71. How to run complex query using PHP
  72. Storing huge number of users in wordpress
  73. Custom User registration system
  74. How to use Multi SQL Database in WordPress?
  75. Conditional formatting on data fetched from MYSQL
  76. Using wpdb to connect to a different database is not working
  77. Looping through custom data in a custom table to display all items in a post
  78. Displaying SQL query result from user input via wpdb
  79. How do I create a WP endpoint that retrieves all custom post types that have a tag?
  80. How do I get data from my database into my Custom Export Field
  81. How to grab data from input and store it into custom table in database?
  82. Update user_email via php – WP 4.7
  83. direct query to post_meta table
  84. Unable to pass variable to database
  85. What to create new post using wp_insert_post, but it repeat the post infinitely
  86. Conditional statement within WP SQL query
  87. Passed variable gets undefined variable error on insert on next page
  88. Run insert if no entry otherwise run update with ajax
  89. See output of a sql query while plugin installation in wordpress
  90. How can I order metaboxes in my posts in WordPress?
  91. MySQL database migration to WordPress
  92. How do you get a reference to $wpdb in a PHP script
  93. WordPress Query -> Ajax Query
  94. how to display tables via ajax
  95. Changing regular db connection to $wpdb
  96. $wpdb how to make a record lookup
  97. Error resetting database index using ALTER TABLE in $wpdb->query
  98. How to sort search result by post_title, then by post_content
  99. WordPress / PHP: Check if column has value and then check if value in array
  100. get_var not returning a value when the field contains an apostrophe