so I have been trying to work with prepared statements into order to make my PHP more secure.
I need to display products from a db table and without using prepared statements, the cards align as they should.
However, with a prepared statement, somewhere, somehow, I have made the cards not align in the right grid.
<!doctype html>
<html lang="en">
<head>
<!-- Required meta tags -->
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<!-- Bootstrap CSS -->
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-EVSTQN3/azprG1Anm3QDgpJLIm9Nao0Yz1ztcQTwFspd3yD65VohhpuuCOmLASjC" crossorigin="anonymous">
<title>Website Title</title>
<?php
include 'navbar.php';
include 'dbConnect.php';
$results=$db->query("SELECT * FROM Stock");
?>
</head>
<body>
<div class="container-xl">
<div class="row">
<div class="col">
<p class="text-muted"> Home > viewStock.php </p>
<h1 class="display-6">Shop
</h1>
</div>
</div>
</div>
<div class="container-xl">
<?php while($row=$results->fetch_array())
{
?>
<form name="orderForm" method="post" action="viewProduct.php">
<div class="col-sm-4">
<div class="card" style="width: 18rem;">
<div class="card-body">
<h5 class="card-title">Stock No: <?php echo $row['stockID'] ?></h5>
<input type="hidden" name="stockID" value="<?php echo $row['stockID'] ?>">
<span class="card"><img class="img-fluid card-img-top" src="<?php echo $row['image'] ?>" alt="No image yet"></span>
<ul class="list-group list-group-flush">
<li class="list-group-item">Description: <?php echo $row['category'] ?></li>
<li class="list-group-item">Quantity In Stock: <?php echo $row['qtyInStock'] ?></li>
<li class="list-group-item">Price: £<?php echo $row['price'] ?></li>
</ul>
<p align="center"><button type="submit" class="btn btn-primary">VIEW</button></p>
</div>
</div>
</div>
</form>
<?php } ?>
</div>
<!-- end row -->
</body>
<!-- Footer-->
<footer class="container-xl py-5 bg-light">
<div class="container">
<p class="m-0 text-center text-black">Copyright © The Music Store 2021</p>
</div>
</footer>
</html>