setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
// Create products table if it doesn't exist
$db->exec("CREATE TABLE IF NOT EXISTS products (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL,
brand TEXT NOT NULL,
price REAL NOT NULL,
image_url TEXT NOT NULL,
description TEXT,
stock INTEGER DEFAULT 0
)");
// Check if we need to seed initial data
$count = $db->query("SELECT COUNT(*) FROM products")->fetchColumn();
if ($count == 0) {
// Insert sample products
$stmt = $db->prepare("INSERT INTO products (name, brand, price, image_url, description, stock) VALUES (?, ?, ?, ?, ?, ?)");
$products = [
['iPhone 15 Pro Max', 'Apple', 1199.99, 'https://images.unsplash.com/photo-1696446702094-378e2e960e6e?w=400', 'Latest iPhone with A17 Pro chip, titanium design, and advanced camera system', 15],
['Samsung Galaxy S24 Ultra', 'Samsung', 1299.99, 'https://images.unsplash.com/photo-1610945415295-d9bbf067e59c?w=400', 'Premium Android flagship with S Pen, 200MP camera, and AI features', 20],
['Google Pixel 8 Pro', 'Google', 999.99, 'https://images.unsplash.com/photo-1598327105666-5b89351aff97?w=400', 'Best Android camera phone with Google AI and Tensor G3 chip', 12],
['iPhone 14', 'Apple', 799.99, 'https://images.unsplash.com/photo-1663499482523-1c0c1bae4ce1?w=400', 'Reliable iPhone with great performance and camera quality', 25],
['OnePlus 12', 'OnePlus', 799.99, 'https://images.unsplash.com/photo-1511707171634-5f897ff02aa9?w=400', 'Fast charging flagship with smooth 120Hz display', 18],
['Samsung Galaxy Z Flip 5', 'Samsung', 999.99, 'https://images.unsplash.com/photo-1686904423955-b6c2e1a5b0aa?w=400', 'Compact foldable phone with large cover screen', 10]
];
foreach ($products as $product) {
$stmt->execute($product);
}
}
// Fetch all products
$products = $db->query("SELECT * FROM products ORDER BY id")->fetchAll(PDO::FETCH_ASSOC);
?>
KoolaPhones - Premium Smartphone Store
KoolaPhones
Premium Smartphones at Great Prices
Discover the latest flagship phones from top brands. Quality guaranteed.