Php Database Website Template -
<h3>Your Items</h3> <?php if (count($items) > 0): ?> <ul class="items-list"> <?php foreach ($items as $item): ?> <li> <strong><?= htmlspecialchars($item['title']) ?></strong> <p><?= nl2br(htmlspecialchars($item['description'])) ?></p> <small>Created: <?= $item['created_at'] ?></small> </li> <?php endforeach; ?> </ul> <?php else: ?> <p>You haven't added any items yet.</p> <?php endif; ?> <?php include 'includes/footer.php'; ?> <?php session_start(); session_destroy(); header("Location: index.php"); exit(); ?> Step 9: Basic CSS ( assets/css/style.css ) Add this minimal styling to make the template presentable:
<?php // config/database.php $host = 'localhost'; $dbname = 'php_template_db'; $username = 'root'; // Change for production $password = ''; // Change for production try { $pdo = new PDO("mysql:host=$host;dbname=$dbname;charset=utf8mb4", $username, $password); // Set PDO to throw exceptions on errors $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); // Fetch associative arrays by default $pdo->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC); } catch(PDOException $e) { die("Database connection failed: " . $e->getMessage()); } php database website template
if ($_SERVER['REQUEST_METHOD'] === 'POST') { $username = sanitizeInput($_POST['username']); $email = sanitizeInput($_POST['email']); $password = $_POST['password']; $confirm_password = $_POST['confirm_password']; <h3>Your Items</h3> <