<?php
include 'admin/database/config.php';
function getClients($conn)
{
$query = "SELECT * FROM clients WHERE published = 1";
$stmt = $conn->prepare($query);
$stmt->execute();
return $stmt->fetchAll(PDO::FETCH_ASSOC);
}
$clients = getClients($conn);
?>
<?php foreach ($clients as $item) : ?>
<div class="col-md-3">
<a href="#" class="card">
<img src="<?= $item['image'] ?>" alt="<?= $item['image_alt'] ?>">
<div class="info">
<h5><?= $item['name'] ?></h5>
</div>
</a>
</div>
<?php endforeach; ?>