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

WordPress website not loading

WP stores URLs in a lot of different tables. You can either use a WP CLI command to search and replace the old URL to your new local URL, or use a plugin to do the same thing. Don’t just go do a blanket search-and-replace in phpMyAdmin or similar because the URLs are stored in … Read more

How to allow searching a custom meta key in admin list table?

After posting the same question to multiple AI chatbots, CoPilot finally gave me an answer that works for both: add_action( ‘pre_get_posts’, ‘filter_files_admin_columns’ ); function filter_files_admin_columns( $query ) { if ( !is_admin() || ‘eri-files’ !== $query->get( ‘post_type’ ) ) { return; } add_filter( ‘posts_search’, ‘custom_search_query’, 10, 2 ); function custom_search_query( $search, $wp_query ) { global $wpdb; … Read more

WordPress query_posts with multiple tax_query

You could build an intermediary array for the tax_query parameter: $tax_query = array(); $taxonomies = array( ‘product_cat’, ‘sub_category’, ); foreach ( $taxonomies as $taxonomy ) { if ( ! empty( $_POST[ $taxonomy ] ) ) { $tax_query[] = array( ‘taxonomy’ => $taxonomy, ‘terms’ => $_POST[ $taxonomy ], ); } } query_posts( array( // … ‘tax_query’ … Read more

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