mysql

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

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