gamg6688/firmwarefusion-hub
0
1```php2<?php3// Database configuration4define('DB_HOST', 'localhost');5define('DB_USER', 'root');6define('DB_PASS', '');7define('DB_NAME', 'firmwarefusion');8 9// Connect to database10try {11 $pdo = new PDO("mysql:host=" . DB_HOST . ";dbname=" . DB_NAME, DB_USER, DB_PASS);12 $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);13} catch (PDOException $e) {14 die("Database connection failed: " . $e->getMessage());15}16 17// Create users table if not exists18$createTable = $pdo->prepare("19 CREATE TABLE IF NOT EXISTS `users` (20 `id` int(11) NOT NULL AUTO_INCREMENT,21 `username` varchar(50) NOT NULL,22 `email` varchar(100) NOT NULL,23 `password` varchar(255) NOT NULL,24 `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,25 PRIMARY KEY (`id`),26 UNIQUE KEY `username` (`username`),27 UNIQUE KEY `email` (`email`)28 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;29");30$createTable->execute();31?>32```