Site Builder

Editing: Geo-JSON-Exporter.txt

writable 0666

<?php
/*
Plugin Name: Geo JSON Exporter
Description: Exports a JSON file per US state from the city table for fast AJAX geo navigation. Output goes to /geo/json-data/{STATE}.json.
Version: 1.0
Author: BestDealOn Dev Team
*/

if ( ! defined('ABSPATH') ) exit;

define('GJE_TABLE', 'kVTr1OdFj_city'); // Change to your table name if needed
define('GJE_OUTDIR', $_SERVER['DOCUMENT_ROOT'] . '/geo/json-data/');

// Ensure output directory exists
if (!is_dir(GJE_OUTDIR)) mkdir(GJE_OUTDIR, 0775, true);

add_action('admin_menu', function() {
    add_management_page(
        'Geo JSON Exporter',
        'Geo JSON Exporter',
        'manage_options',
        'geo_json_exporter',
        'gje_admin_page'
    );
});

// AJAX: Export JSON (single state or all)
add_action('wp_ajax_gje_export_json', function() {
    global $wpdb;
    $state = isset($_POST['state']) ? sanitize_text_field($_POST['state']) : '';
    $outdir = GJE_OUTDIR;
    $status = '';

$states = $state ? [$state] : $wpdb->get_col("SELECT DISTINCT subdiv_id FROM " . GJE_TABLE . " WHERE country_id='USA'");

foreach ($states as $st) {
        $rows = $wpdb->get_results($wpdb->prepare(
            "SELECT city_title, city_lat, city_lon, city_id FROM " . GJE_TABLE . " WHERE country_id='USA' AND subdiv_id=%s",
            $st
        ));
        $arr = [];
        foreach($rows as $r) {
            $slug = preg_replace('/[^a-z0-9]+/i','-', strtolower($r->city_title));
            $arr[] = [
                'city' => $r->city_title,
                'lat' => floatval($r->city_lat),
                'lon' => floatval($r->city_lon),
                'slug' => $slug,
                'url' => "/geo/USA/{$st}/{$slug}/"
            ];
        }
        $outfile = $outdir . $st . '.json';
        file_put_contents($outfile, json_encode($arr, JSON_PRETTY_PRINT | JSON_UNESCAPED_UNICODE));
        $status .= "Exported " . count($arr) . " cities to $outfile\n";
    }
    wp_send_json_success(['status' => $status]);
});

Site Builder

Editing: Geo-JSON-Exporter.txt

Site Builder