 | |||||
| |||||
| |||||
|
|
| ||||||||||||||||
| |||||||||||||||||
Php Database Website Template _hot_ May 2026CREATE DATABASE php_template_db; USE php_template_db; CREATE TABLE users ( id INT(11) AUTO_INCREMENT PRIMARY KEY, username VARCHAR(50) UNIQUE NOT NULL, email VARCHAR(100) UNIQUE NOT NULL, password_hash VARCHAR(255) NOT NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); $error = ''; label { display: block; margin-bottom: 0.3rem; font-weight: bold; } php database website template try { $stmt = $pdo->prepare("INSERT INTO users (username, email, password_hash) VALUES (?, ?, ?)"); $stmt->execute([$username, $email, $password_hash]); redirect('login.php?registered=1'); } catch(PDOException $e) { if ($e->errorInfo[1] == 1062) { $errors['database'] = "Username or email already exists"; } else { $errors['database'] = "Registration failed. Please try again."; } } } } ?> <?php include 'includes/header.php'; ?> <h2>Register</h2> <?php if (isset($errors['database'])): ?> <div class="error"><?= $errors['database'] ?></div> <?php endif; ?> <form method="POST"> <div> <label>Username:</label> <input type="text" name="username" value="<?= htmlspecialchars($username ?? '') ?>"> <?php displayError($errors, 'username'); ?> </div> <div> <label>Email:</label> <input type="email" name="email" value="<?= htmlspecialchars($email ?? '') ?>"> <?php displayError($errors, 'email'); ?> </div> <div> <label>Password (min 6 chars):</label> <input type="password" name="password"> <?php displayError($errors, 'password'); ?> </div> <div> <label>Confirm Password:</label> <input type="password" name="confirm_password"> <?php displayError($errors, 'confirm_password'); ?> </div> <button type="submit">Register</button> </form> <?php include 'includes/footer.php'; ?> <?php require_once 'config/database.php'; require_once 'includes/functions.php'; if (isLoggedIn()) { redirect('dashboard.php'); } // Fetch user's items $stmt = $pdo->prepare("SELECT * FROM items WHERE user_id = ? ORDER BY created_at DESC"); $stmt->execute([$_SESSION['user_id']]); $items = $stmt->fetchAll(); ?> <?php include 'includes/header.php'; ?> <h2>Welcome, <?= htmlspecialchars($_SESSION['username']) ?>!</h2> Password (min 6 chars):< header { background: #333; color: #fff; padding: 1rem 0; } .nav-links a { color: #fff; text-decoration: none; } input type="password" name="password"> form div { margin-bottom: 1rem; } |
Вход
