CoolFace
Apppublic

gamg6688/firmwarefusion-hub

sourceHugging Faceupdated 9mo agoView on Hugging Face
0likes
db.php32 linesDownload Raw Back to root
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```