validate_request(); // process if(isset($_POST['unit_id'])) { $unit_id = sanitize_text_field($_POST['unit_id']); try { global $wpdb; $details_table = $wpdb->prefix . 'lfzw_details'; $listings_table = $wpdb->prefix . 'lfzw_listings'; $images_table = $wpdb->prefix . 'lfzw_images'; $query = $wpdb->prepare(" SELECT d.*, l.* FROM {$details_table} AS d INNER JOIN {$listings_table} AS l ON d.list_id = l.list_id WHERE d.list_id = %d LIMIT 1 ", $unit_id); $details = $wpdb->get_row($query, ARRAY_A); if ($details) { $image_results = $wpdb->get_results( $wpdb->prepare("SELECT image_url, image_alt FROM {$images_table} WHERE list_id = %d", $unit_id), ARRAY_A ); $details['images'] = $image_results; } $show_back_btn = true; ob_start(); include LFZW_Fr_Main::$plugin_dir . 'public/templates/details.php'; $details_template = ob_get_clean(); $res_array['details_template'] = $details_template; $res_array['latitude'] = isset($details['latitude']) ? $details['latitude'] : ''; $res_array['longitude'] = isset($details['longitude']) ? $details['longitude'] : ''; } catch(Exception $e) { $res_array['error'] = $e->getMessage(); } } echo json_encode($res_array); exit; } }