File Manager

✏️ Edit File: /home/u625410797/domains/monothailand.com/public_html/scripts/run_map_locations_setup.php

<?php
/**
 * Setup script to create map_locations table
 */

require_once 'conn_mono.php';

$sql = "CREATE TABLE IF NOT EXISTS `map_locations` (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `address` text DEFAULT NULL,
  `lat` decimal(10,8) DEFAULT NULL COMMENT 'Latitude coordinate',
  `lng` decimal(11,8) DEFAULT NULL COMMENT 'Longitude coordinate',
  `map_url` text DEFAULT NULL COMMENT 'Google Maps direct URL',
  `description` text DEFAULT NULL COMMENT 'Additional description for the location',
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `sort_order` int(11) NOT NULL DEFAULT 0,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `idx_is_active` (`is_active`),
  KEY `idx_sort_order` (`sort_order`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;";

try {
    if ($conn->query($sql)) {
        echo "✓ Table 'map_locations' created successfully.\n";
        
        // Insert sample data
        $sampleData = "INSERT INTO `map_locations` (`name`, `address`, `lat`, `lng`, `map_url`, `description`, `is_active`, `sort_order`) VALUES
        ('Head Office', '95/23 Suwinthawong Rd., Minburi Subdistrict, Minburi district, Bangkok 10510', 13.7267, 100.7730, 'https://maps.google.com/?q=13.7267,100.7730', 'สำนักงานใหญ่ โมโน อีเล็คทริค (ประเทศไทย) จำกัด', 1, 1),
        ('Showroom Bangna', '555 ถนนศรีนครินทร์ แขวงบางนา เขตบางนา กรุงเทพฯ 10260', 13.6720, 100.7350, 'https://maps.google.com/?q=13.6720,100.7350', 'โชว์รูมบางนา', 1, 2),
        ('Showroom Rangsit', '777 ถนนพหลโยธิน แขวงจตุจักร เขตจตุจักร กรุงเทพฯ 10900', 13.9956, 100.6265, 'https://maps.google.com/?q=13.9956,100.6265', 'โชว์รูมรังสิต', 1, 3)";
        
        if ($conn->query($sampleData)) {
            echo "✓ Sample data inserted successfully.\n";
        } else {
            echo "⚠ Sample data insertion failed (table may already have data): " . $conn->error . "\n";
        }
    } else {
        echo "✗ Table creation failed: " . $conn->error . "\n";
    }
} catch (Exception $e) {
    echo "✗ Error: " . $e->getMessage() . "\n";
}

$conn->close();
?>

Batal

⬅ Naik ke public_html 18 item

Nama	Tipe	Ukuran	Diubah	Aksi
🐘conn_mono.php	php	1.1 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘deploy_solar_calculator.php	php	5.6 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘fix_all_urls.php	php	1.8 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘fix_inquiries.php	php	431 B	2026-05-31 16:39	✏️ Edit 👁️ View
🐘fix_urls.php	php	2 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘import_services.php	php	1.8 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘insert_about_page.php	php	4.7 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘migrate_images.php	php	18.3 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘run_about_setup.php	php	2.9 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘run_banners_migration.php	php	6.5 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘run_banners_setup.php	php	2.9 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘run_map_locations_setup.php	php	2.5 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘run_variations_migration.php	php	410 B	2026-05-31 16:39	✏️ Edit 👁️ View
🐘setup_production_admin.php	php	10.6 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘setup_tables.php	php	2 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘show_create.php	php	252 B	2026-05-31 16:39	✏️ Edit 👁️ View
🐘update_database.php	php	7 KB	2026-05-31 16:39	✏️ Edit 👁️ View
🐘update_database_world_class.php	php	10.3 KB	2026-05-31 16:39	✏️ Edit 👁️ View