Dynamic Grid

EmmaS

yesterday

<?php
declare(strict_types=1);

// ---- Database Connection ----
$dsn  = "mysql:host=localhost;dbname=your_db;charset=utf8mb4";
$user = "your_user";
$pass = "your_pass";

try {
    $pdo = new PDO($dsn, $user, $pass, [
        PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
        PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
        PDO::ATTR_EMULATE_PREPARES   => false,
    ]);
} catch (PDOException $e) {
    http_response_code(500);
    exit("Database connection failed.");
}

// ---- Retrieve last 15 members ----
$stmt = $pdo->query("
    SELECT id, member_name
    FROM member_table
    ORDER BY id DESC
    LIMIT 15
");

$members = $stmt->fetchAll();
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Dynamic Member Grid</title>
    <style>
        body {
            font-family: system-ui, sans-serif;
            background: #f5f7fb;
            padding: 40px;
            margin: 0;
        }
        h3 {
            margin-bottom: 20px;
            color: #333;
        }
        .grid {
            display: grid;
            grid-template-columns: repeat(auto-fill, minmax(180px, 1fr));
            gap: 15px;
        }
        .card {
            background: white;
            padding: 15px 20px;
            border-radius: 10px;
            box-shadow: 0 4px 12px rgba(0,0,0,0.08);
            font-size: 16px;
            color: #444;
            text-align: center;
            transition: transform .1s, box-shadow .1s;
        }
        .card:hover {
            transform: translateY(-3px);
            box-shadow: 0 6px 16px rgba(0,0,0,0.12);
        }
    </style>
</head>
<body>

<h3>Dynamic PHP Grid Layout From a MySQL Result Set</h3>

<div class="grid">
    <?php foreach ($members as $row): ?>
        <div class="card">
            <?= htmlspecialchars($row['member_name'], ENT_QUOTES, 'UTF-8') ?>
        </div>
    <?php endforeach; ?>
</div>

</body>
</html>

You must be logged in to post a reply.

Support StreamCode Studio

Popular Topics