Meta Query meta_query takes an array of meta query arguments arrays. You may check WordPress documentation for examples. This construct allows you to query multiple metadatas by using the relation parameter in the first (outer) array to describe the boolean relationship between the meta queries. Accepted arguments are ‘AND’, ‘OR’. The default is ‘AND’. Solution … Read more
There were a couple security issues and error checking that I did see. Try these: <?php add_action(‘wp_ajax_get_timeslot_data’, ‘get_timeslot_data’); add_action(‘wp_ajax_nopriv_get_timeslot_data’, ‘get_timeslot_data’); function get_timeslot_data() { if (!isset($_POST[‘activityId’]) || !ctype_digit($_POST[‘activityId’])) { wp_send_json_error(“Invalid activity ID”); } global $wpdb; $activity_id = intval($_POST[‘activityId’]); $table_name = $wpdb->prefix . ‘booking_seasons’; // Support custom table prefixes $result = $wpdb->get_row($wpdb->prepare(“SELECT timeslot_dates FROM $table_name WHERE id … Read more
As Tom J Nowell pointed out in the comments, this is a very specific situation, which makes the question rather difficult to answer. If the source system has suitable code for pushing data to other systems, then you could consider registering a custom REST endpoint at the WordPress end. The endpoint would receive, validate and … Read more
As discussed in comments, the problem was a missing prce2 package which meant preg_match(), used by $wpdb->db_version() to parse the MySQL version number out of SELECT VERSION(), didn’t work. Solved by sudo yum install pcre2
If you provided full code, issue is probably in this line: $wpdb->prepare(“INSERT INTO ‘myprefix_posts_views’ (postid, ip, device) VALUES (%d, %s, %s) ON DUPLICATE KEY UPDATE create_at=VALUES(create_at)”, $postID, $_SERVER[‘REMOTE_ADDR’], $_SERVER[‘HTTP_USER_AGENT’]); Because into column postid you are trying to put variable $postID, when you didn’t declare it anywhere. This column is NOT NULL, so probably you have … Read more
It is recommended to use the $wpdb->get_var() method when retrieving a count of rows. This method will return the count directly, rather than inside of an array or object like wpdb::get_results().
There’s only one naming convention to remember, the WP table prefix. If you don’t want to use it you can do whatever you want. WordPress only cares about its own tables, you can create any other tables you want. Keep in mind though that the WordPress table prefix isn’t always wp_, and it changes for … Read more
Using the wpdb::prepare() method is recommended for creating queries properly and avoiding SQL injection. For a basic solution, use the addslashes() function, but this is not sufficient for preventing SQL injection. See Mysql + php with special characters like ‘(Apostrophe) and ” (Quotation mark).
This is what I wanted to achieve, I hope it helps somebody DELETE wp_posts FROM wp_posts INNER JOIN wp_users ON wp_posts.post_author = wp_users.ID WHERE post_author = 1 AND post_date BETWEEN ‘2024-01-01 00:00:00’ AND ‘2024-03-28 23:59:59’;
I think the problem is here {$wpdb->prefix}prflxtrflds_user_field_data It seems your {$wpdb->prefix} value is prflxtrflds So you can directly use : global $wpdb; $results = $wpdb->get_results( “SELECT user_id FROM {$wpdb->prefix}user_field_data WHERE id = 37” );`