Okay So Here I'm trying to link a Item details page to a Item page, I have successfully done so however when I click on an item all the item details are showing up I would like to know how to Only Display one item on the item details page for the corresponding id. I know I'm missing some code (think its a GET or POST variable) to complete the link if anyone can help it will be much appreciated thanks alot
Heres my code
item.php
<div class="rone">
<?php
$conn = new mysqli("xxx", "xxx", "xxx", "xxx");
if ($conn->connect_error) {
die("Connection Failed!" . $conn->connect_error);
}
?>
<?php
$stmt = $conn->prepare('SELECT * FROM items');
$stmt->execute();
$result = $stmt->get_result();
while ($row = $result->fetch_assoc()):
?>
<div class="col-4">
<a href="item-details.php?id<?= $row['id'] ?>"><img src="<?= $row['itemimage'] ?>"></a>
<h4"><?= $row['item_name'] ?></h4>
</div>
<?php endwhile; ?>
</div>
item-details.php
<div class="rone">
<?php
$conn = new mysqli("xxx", "xxx", "xxx", "xxx");
if ($conn->connect_error) {
die("Connection Failed!" . $conn->connect_error);
}
?>
<?php
include 'config.php';
$stmt = $conn->prepare('SELECT * FROM items');
$stmt->execute();
$result = $stmt->get_result();
while ($row = $result->fetch_assoc()):
?>
<div class="col-2">
<img src="<?= $row['itemimage'] ?>" width="100%" id="ItemImg">
<?php endwhile; ?>
</div>
<div class="col-2">
<h1><?= $row['item_name'] ?></h1>
</div>
</div>
the names of my rows are: id , itemimage, item_name and in time to come I will add other attributes And the main table is items.
source https://stackoverflow.com/questions/68581403/how-to-display-one-item-in-my-item-details-page-from-my-item-page-using-php-mysq
Comments
Post a Comment