prepare("SELECT * FROM admin_users WHERE username = ? LIMIT 1"); $stmt->execute([$username]); $user = $stmt->fetch(); } catch (PDOException $e) { // If the table doesn't exist, create it and insert a default user if ($e->getCode() == '42S02') { // 42S02 is "Base table or view not found" $pdo->exec("CREATE TABLE admin_users ( id INT AUTO_INCREMENT PRIMARY KEY, username VARCHAR(50) NOT NULL UNIQUE, password VARCHAR(255) NOT NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP )"); $default_password = password_hash('123', PASSWORD_DEFAULT); $pdo->exec("INSERT INTO admin_users (username, password) VALUES ('admin', '$default_password')"); // Retry the query $stmt = $pdo->prepare("SELECT * FROM admin_users WHERE username = ? LIMIT 1"); $stmt->execute([$username]); $user = $stmt->fetch(); } else { $error = "Database Error: " . $e->getMessage(); } } if (empty($error)) { if (!empty($user) && password_verify($password, $user['password'])) { $_SESSION['admin_logged_in'] = true; $_SESSION['admin_id'] = $user['id']; $_SESSION['admin_user'] = $user['username']; header("Location: index.php"); exit; } else { $error = "Invalid username or password."; } } } } ?>
Madushan ALUMINIUM pvt ltd