                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    
<?php
include 'config.php';

// Create table
$conn->query("CREATE TABLE IF NOT EXISTS banners (
    id INT PRIMARY KEY AUTO_INCREMENT,
    image VARCHAR(255) NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
)");

$banners = ['1.jpeg', '2.jpeg', '3.jpeg'];
foreach($banners as $b) {
    $res = $conn->query("SELECT * FROM banners WHERE image = '$b'");
    if($res->num_rows == 0) {
        $conn->query("INSERT INTO banners (image) VALUES ('$b')");
        echo "Inserted $b\n";
    } else {
        echo "$b already exists\n";
    }
}
?>