I want show only data for today

Well dear thanks for your effort.I solved this .here is answer.

$user1 = $wpdb->get_results("select product,checked_by,submit_date,unit_data,temperature_in,temperature_out,time_in,category from diary_user_form_storage  where category_name="opening" and DATE(`submit_date`) = CURDATE()");

Related Posts:

  1. Undefined function mysql_connect()
  2. MySQL column count doesn’t match value count at row 1 [closed]
  3. Fatal error: Call to undefined function mysql_connect()
  4. the_date() not working
  5. How to return number of found rows from SELECT query
  6. dbDelta support for FOREIGN KEY
  7. Check if post of title already exists
  8. $wpdb->delete column values IN ARRAY()?
  9. How to make WordPress plugin check for database changes and then do something?
  10. Custom SQL query to get List of posts with featured image url
  11. Does WordPress cache get_user_meta() results?
  12. Delete post revisions on post publish
  13. Using Echo in ShortCode – Stuck
  14. Problems migrating WordPress to localhost
  15. error importing localhost export file to server
  16. How to sort results from a custom database table
  17. Update some database fields when post is saved
  18. Successful or Error Message after running mysql code in functions.php
  19. sql query to put quotes around numbers in img tag
  20. PHP/MySQL issues when running WP on EC2 cloud [closed]
  21. WordPress get pagination on wpdb get_results
  22. How to create another version of my site based on the same database
  23. What SQL / WordPress queries would need a nonce?
  24. Different database query in function.php using mysqli
  25. Strange wordpress slowness
  26. Looking for most performant way to execute several similar WP queries within shortcodes
  27. Setting All Drafts to ‘exclude-from-catalog’ in WooCommerce
  28. Stumped on migration
  29. PHP code inside shortcodes
  30. Show MySQL errors that occur when I excute $wpdb->insert()
  31. Is XAMPP faster than running LAMP in WSL on Windows 10? [closed]
  32. WordPress Site Running Extremely Slow on Dedicated Server
  33. Get updated query results on page after insert in database
  34. WordPress not reflecting changed of the database
  35. How can I fix WordPress installation errors?
  36. How to split links generated into an xml sitemap to avoid exceeding 30 sec maximum execution time?
  37. Hacked WordPress website /Homepage redirect [closed]
  38. get_posts() and WP_query limits ‘AND’ conditions to a maximum of 6 for meta value queries in WordPress
  39. Refresh table data with Ajax
  40. database sent to a JSON file
  41. Database query works fine outside WordPress
  42. Large Woocommerce Site (83,000 items), What Can I Do? [closed]
  43. Help with a $wpdb MySQL Query
  44. WordPress SQL injection
  45. How i can obtain all the post meta for a specific post as an array?
  46. multiple where condition in result query
  47. Can’t Query Custom Table Using $wpdb Method
  48. $wpdb returns duplicate posts
  49. Update postmeta after theme switch
  50. Should I use WordPress to skin a database website?
  51. Creating Database Table vs. Adding MetaData to Post & User
  52. WordPress Custom SQL Table with UserID Filter for results
  53. How can I add a new row in a separate database when someone registers via WordPress?
  54. I can’t update my data through $wpdb
  55. Output: “Array”
  56. How to use mysql LIKE with wpdb?
  57. Submitting a form, using Ajax, to run a SQL Select query based on user input from the form
  58. WordPress WP_Query without query GET parameters
  59. How to use AJAX in WordPress in MYSQL query?
  60. Use variable in SQL statement
  61. Processing ajax call to php to insert into mysql database
  62. WPDB secure custom form
  63. Query the links Database
  64. WordPress Custom Query: Combining Two Functions
  65. MySQL Query Returns Array () In Shortcode
  66. Passing in MySQL prepare statement parameter separately throwing error
  67. Database SQL query error
  68. Display Results of SQL Query on WP site
  69. PHP Warning: mysqli_query(): after updating my websites php from 5.6 to 7.2
  70. MYSQL TIMESTAMP when adding DATE_FORMAT then the output is blank, PHP conflict?
  71. Updated Php version from 5.4 to 7.2 and getting “PHP installation missing the MySQL extension needed by WordPress”
  72. how to get data from two different table from wordpress database
  73. Passing Current User ID into SQL statement
  74. How to optimize and reduce excessive database queries
  75. How to display MySQL table data which is stored as an array?
  76. Store GA Client ID in User DB
  77. How to import woocommerce custom fields data into another site?
  78. PHP 7.2.18 | Your PHP installation appears to be missing the MySQL extension which is required by WordPress
  79. Need help with format of nested array in MySQL
  80. Inserting other fields to existing registration form in a WordPress theme
  81. Advanced WordPress SQL Query
  82. Splitting table data to pages with numbers
  83. How can get all users by current user meta (array)?
  84. Site doesnt work once PHP changed to 7.1
  85. How to detect if a revision was made by woocommerce or wordpress?
  86. WordPress WPDB::insert 13th param is always blank (only if format)
  87. Ajax not updating to database
  88. can’t delete a row from post_meta table
  89. Send data from plugin to external database
  90. MySQL query in WordPress with AJAX
  91. Processing forms with php to wordpress database
  92. How to connect database table to each registered wordpress user.
  93. retrieve wordpress post-meta using php not wordpress functions
  94. Splash pages on a high traffic site
  95. Using the same shortcode to show any table from the database
  96. I am unable to fetch json data from wp_db
  97. Submit cf7 form to cfdb as pdf/BLOB [closed]
  98. Parse error: syntax error, unexpected ‘}’ in C:\xampp\htdocs\admin\products.php on line 148 [closed]
  99. How to send push notification in android using php? [closed]
  100. running an existing WordPress site from Visual Studio Code?
error code: 523