24 lines
870 B
PHP
24 lines
870 B
PHP
<?php
|
|
require_once __DIR__ . '/../config.php';
|
|
|
|
function seed_categories() {
|
|
$pdo = db();
|
|
$categories = [
|
|
['name' => 'E-Commerce', 'slug' => 'ecommerce', 'icon_url' => 'shopping-bag'],
|
|
['name' => 'Food Delivery', 'slug' => 'food', 'icon_url' => 'coffee'],
|
|
['name' => 'Movie Tickets', 'slug' => 'movies', 'icon_url' => 'film'],
|
|
['name' => '30-Min Delivery', 'slug' => 'delivery', 'icon_url' => 'truck'],
|
|
];
|
|
|
|
$stmt = $pdo->prepare("INSERT INTO categories (name, slug, icon_url) VALUES (?, ?, ?) ON DUPLICATE KEY UPDATE name=VALUES(name)");
|
|
|
|
foreach ($categories as $category) {
|
|
$stmt->execute([$category['name'], $category['slug'], $category['icon_url']]);
|
|
}
|
|
echo "Categories seeded successfully." . PHP_EOL;
|
|
}
|
|
|
|
if (basename(__FILE__) == basename($_SERVER["SCRIPT_FILENAME"])) {
|
|
seed_categories();
|
|
}
|