The answer is: function reservations_yesterday() { global $wpdb; $results = $wpdb->get_var (“SELECT SUM(`mattiscool`), booking_date FROM `wp_cbxrbooking_log_manager` WHERE `booking_date` = CURDATE() -1”); return $results; } add_shortcode(‘name’, ‘reservations_yesterday’);
You need to read the manual for the functions you’re using as all the information for how to debug is contained there. $wpdb-query() description is very clear. The return value is: (int|bool) Boolean true for CREATE, ALTER, TRUNCATE and DROP queries. Number of rows affected/selected for all other queries. Boolean false on error. As mentioned … Read more
How to change this ajax function to submit to the default wordpress content area instead of the custom field ‘seller notes’?
“Class Not Found” in HTML Form Target PHP File that contains the class
WP_Query will get posts, the whole post. If another repeater field instance has data for LotNos the sort parameter will not understand what you mean. What I’d do is getting all posts just by the date. Than I’d make a loop and create an array of objects with the data you need from each post … Read more
Instead of use shortcode in your confirmation, you can use the filter hook “gform_confirmation” for manage your confirmation. After, you’ll be able to use your shortcode [useful-tools] with do_shortcode() with your confirmation. Sorry if I misunderstood your problem!
UPDATE: Turns out I was trying to make a comparison between a DateTime object and the date() function of PHP. When I switched date() to DateTime the comparison was fine.
First a few notes: Shortcodes do accept arguments, so you could write [marks subject=”Biology”] (@see https://codex.wordpress.org/Shortcode_API) You should never ever pass raw data directly into a SQL statement, WordPress uses PDO, this means you can prepare statements. (@see https://developer.wordpress.org/reference/classes/wpdb/prepare/) Using the get_results will return an Array, object or null (@see https://developer.wordpress.org/reference/classes/wpdb/get_results/). There are many approaches … Read more
Press Ctrl+Shift+I to open the developer’s tool bar and examine your #hero to check if the image URL is correct. Will be helpfull if you share the full path of the image.
The only way that I know of to perform an action daily (or on another regular interval) is to schedule a cron event. A sustainable way to do that is to write a little plugin that schedules/clear_schedules the cron when activated/deactivated. Here’s a plugin that you could use – I tested to ensure that it … Read more