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:
- Undefined function mysql_connect()
- MySQL “Or” Condition
- Transaction when using WP functions rather than vanilla SQL?
- Can i use php sql functions instead of $wpdb?
- How to validate WordPress generated password in DB using PHP?
- How to get the list of WooCommerce product image of a certain category from database?
- Custom query to get post names beginning with a digit
- How To Make Connection To WordPress Data Base In A Plugin?
- Changing user_nicename
- WordPress will not operate correctly
- tag search using WP_Query
- Jquery ajax to custom php file: returning blank data
- Add value to usermeta without removing previous values?
- How can I call a row of user specific data from a custom table added to the WP Database
- Your PHP installation appears to be missing the MySQL extension which is required by WordPress
- How to merge local and live databases?
- How to track a users progress through pages by inserting data into WordPress Database?
- the_author_meta not working
- if statement on database query
- Is the regular ajax request method safe or I should use admin-ajax.php?
- Sortable admin column for one meta key with three possible meta values
- WordPress Ajax Custom Query – High CPU LOAD
- AJAX in WordPress, sending coords data to MySQL and show after into map
- Performance issues with large website [closed]
- Create a quick start wordpress installation [closed]
- How to migrate the posts from an old custom legacy blog to a new WordPress website?
- theme options echoing multiple times
- WordPress 3 – how are passwords stored and how do I compare to them?
- Styling images coming from another blog
- mysqli_real_connect() – authentication method unknown to the client Warnings
- how to echo all tables that start with a prefix
- Do I need to prepare query before get_results(), get_row() and get_var()?
- How to create and work with custom data / tables (i.e., for arbitrary data)?
- How to convert objects into arrays
- Ajax $wpdb not returning table data
- Is there a way to get 3+ dimensional array from a single MySql command
- Remove one value in dismissed_wp_pointers?
- Can’t get wp_insert_post to work
- Accessing data from a non-WP database/table within a page content
- I want to select the from values from database in WordPress? [closed]
- mysql query from wordpress page using custom table
- User management system similar to wordpress one?
- Importing Geo data into wordpress database
- PHP Fatal error: Uncaught mysqli_sql_exception: Table doesn’t exist in wordpress/wp-includes/wp-db.php
- SQL Injection blocked by firewall
- How to check if a meta value has already been assigned to any user?
- WP_Query adds “(wp_posts.ID = ‘0’)” so no results are returned
- How can I save unique user data on my site? [closed]
- Ordering users by custom user meta
- Long running queries
- WordPress SQL injection
- multiple where condition in result query
- Grouping posts by a custom meta value
- Mixing variables into an array when inserting values
- wpdb prepare insert table doesn’t work
- Make a database query using WordPress
- I can’t update my data through $wpdb
- Output: “Array”
- Using wordpress function to retrieve data
- Live search from database table
- form $_post action value gets truncated after it passes through two forms
- phpMyAdmin error #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’
- Add row to custom database Table and delete all rows older than 1 day
- making php value numeric
- How to create Loop code for Menu using WordPress?
- How to WP_Query posts order by parent title?
- Convert a column of a table containing an Array as response in HTML
- Please help! I have a problem with getting wordpress databas
- How to run complex query using PHP
- Error establishing a database connection (Set-up locally)
- Conditional formatting on data fetched from MYSQL
- Can I split a huge wp_postmeta table across different databases or servers?
- how to get data from two different table from wordpress database
- Passing Current User ID into SQL statement
- How to insert multiple rows and columns in database using array
- WordPress mysql deos not work with php7
- Error inserting into custom table – Object of class wpdb could not be converted to string [closed]
- Windows Setup: Error establishing a database connection
- WP + MySql db / PHP
- The plugin generated 225 characters of unexpected output during activation
- WAMP SERVER Command Prompt SET PATH=%PATH%
- append data to mysql table via submit button coded in php – not working
- WordPress select query issue
- How to do a MySql query in WordPress?
- Add two or multiple functions in WordPress Post or Page
- How can I display a query in a page?
- Send data from plugin to external database
- How to properly send many mysql queries via php and what happens with ajax requests after they are sent?
- How to set max users to 17.000
- Passed variable gets undefined variable error on insert on next page
- directorypress theme error mysql_error() [closed]
- How to set up an auto delete post?
- Cannot Upload Custom Header Image into WordPress Dashboard
- MySQL update text field with ‘
- Predefine Magazine Style Layouts
- Parse error: syntax error, unexpected ‘}’ in C:\xampp\htdocs\admin\products.php on line 148 [closed]
- How to set variable to specific field when querying
- How to get a database field value from a WordPress table? [closed]
- Error resetting database index using ALTER TABLE in $wpdb->query
- Trying to GET data with ajax from database and show in fullcalendar