Tul xxx Tul

Viewing: migrate_hero.php

<?php

define('ROOT_PATH', dirname(__DIR__));
define('APP_PATH', ROOT_PATH . '/admin/app');

require APP_PATH . '/Core/Database.php';

$db = Database::connection();

// 1. Create the table
$sql = "
CREATE TABLE IF NOT EXISTS hero_section (
    id INT AUTO_INCREMENT PRIMARY KEY,
    subtitle VARCHAR(255),
    title_1 VARCHAR(255),
    title_2 VARCHAR(255),
    desc_1 VARCHAR(255),
    desc_2 TEXT,
    btn_text VARCHAR(100),
    image_1 VARCHAR(255) DEFAULT NULL,
    image_2 VARCHAR(255) DEFAULT NULL,
    image_3 VARCHAR(255) DEFAULT NULL,
    status ENUM('activo', 'inactivo') DEFAULT 'activo',
    updated_at DATETIME
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
";

$db->exec($sql);

// 2. Insert initial data if table is empty
$count = $db->query("SELECT COUNT(*) FROM hero_section")->fetchColumn();

if ($count == 0) {
    $insertSql = "
    INSERT INTO hero_section (subtitle, title_1, title_2, desc_1, desc_2, btn_text, image_1, image_2, image_3, status, updated_at)
    VALUES (
        'CONSTRUCTORA F BONILL@ • DISEÑO Y CONSTRUCCIÓN',
        'Constructora en Honduras',
        '– Diseño y Construcción',
        'DISEÑAMOS, CONSTRUIMOS Y REFORMAMOS CASAS',
        'Construimos en toda Honduras.',
        'Contáctanos',
        'https://images.unsplash.com/photo-1600585154340-be6161a56a0c?ixlib=rb-1.2.1&auto=format&fit=crop&w=1950&q=80',
        'uploads/elegant_modern_house_1.png',
        'uploads/elegant_modern_house_2.png',
        'activo',
        NOW()
    )
    ";
    $db->exec($insertSql);
    echo "Hero data inserted successfully.\n";
} else {
    echo "Table already has data.\n";
}

echo "Migration completed.\n";

User / IP	: 216.73.216.217
Host / Server	: 45.84.207.204 / aircan.me
System	: Linux lt-bnk-web1726.main-hosting.eu 5.14.0-611.36.1.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Mar 3 11:23:52 EST 2026 x86_64