WordPress Query with meta_key and order by another meta_key

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

Trying to GET data with ajax from database and show in fullcalendar

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

How to sync non-wp database with wp-database?

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

MariaDB version not recognised

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

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)