File Manager

✏️ Edit File: /home/u625410797/public_html/public_html/scripts/import_services.php

<?php
/**
 * Import Services Data from SQL file
 * This script imports the services table structure and data
 */
require_once __DIR__ . '/../config/config.php';

$sqlFile = __DIR__ . '/../database/monothailand.sql';

if (!file_exists($sqlFile)) {
    die("SQL file not found: $sqlFile\n");
}

echo "Importing services table from monothailand.sql...\n";

try {
    // Read SQL file
    $sql = file_get_contents($sqlFile);
    
    // Extract only the services table creation and data
    preg_match('/CREATE TABLE `services`[\s\S]*?ENGINE=InnoDB[^;]+;/', $sql, $createMatch);
    preg_match('/INSERT INTO `services`[\s\S]*?;/', $sql, $insertMatch);
    
    if (empty($createMatch)) {
        die("Could not find services table creation in SQL file\n");
    }
    
    $createTable = $createMatch[0];
    $insertData = $insertMatch[0] ?? '';
    
    // Drop existing table if exists
    try {
        Database::query("DROP TABLE IF EXISTS services");
        echo "Dropped existing services table (if any)\n";
    } catch (Exception $e) {
        echo "Note: " . $e->getMessage() . "\n";
    }
    
    // Create table
    Database::query($createTable);
    echo "Created services table\n";
    
    // Insert data
    if (!empty($insertData)) {
        Database::query($insertData);
        echo "Inserted services data\n";
    }
    
    // Verify
    $count = Database::fetch("SELECT COUNT(*) as count FROM services");
    echo "\nServices imported successfully!\n";
    echo "Total services: " . $count['count'] . "\n";
    
    // List services
    $services = Database::fetchAll("SELECT id, title, slug FROM services ORDER BY sort_order ASC");
    echo "\nAvailable services:\n";
    foreach ($services as $s) {
        echo "  - {$s['title']} (slug: {$s['slug']})\n";
    }
    
} catch (Exception $e) {
    die("Error importing services: " . $e->getMessage() . "\n");
}
?>

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