How to add button for every field when retrieving data from a database

Question

I have looked everywhere for this question, perhaps I'm just not phrasing it correctly.

I have a page displaying various products, the table is called items. There in my fields I have all the information and images to display on the page, this works fine. Now I want to be able to press a button to add the item to cart, I have the code below where I access the data.

<div class="col-md-5">
 <h2 style="font-size:25px;"> <?=$items['title'];?></h2>
 <img src="<?=$items['image'];?> "width='300' height='500'/>
 <p style="font-size:20px;" class = "lprice">GBP <?= $items['price'];?></p>
</div>

Now that I have done that, my question is how can I add a button for every time a result is displayed and have that button linked with that item, I appreciate this may no be as straight forward as I am phrasing this, but just looking for some help.

Thanks

Answer 1

You can do it in two ways, either way, you need a primary key (eg: id) in your items table which will hold a unique number for each of your items. After that, you print your id along with everything else inside a button or inside an a tag. Like

<div class="col-md-5">
 <h2 style="font-size:25px;"> <?=$items['title'];?></h2>
 <img src="<?=$items['image'];?> "width='300' height='500'/>
 <p style="font-size:20px;" class = "lprice">GBP <?= $items['price'];?></p>
 <a class="btn btn-primary" href="add_to_cart.php?id=<?=$items['id'];?>">Add to Cart</a>
</div>

Now inside your add_to_cart.php file, you can receive the id of the products like this $product_id = $_GET['id'];

Once you have the id of the product, you can process the rest on the add_to_cart.php file and redirect the user back to the previous page with a success or error message.

This way, we passed the id using a URL parameter. The second way is to pass the id using a form. I just wanted to let you that this method exists. I hope this helps. If you have any doubt, feel free to ask in the comment section.