How to display certain products when clicking a link to another page?

Question

I’m having a problem, no matter how hard I try, I can’t fix it.. The problem is in:

<form action="" method="POST">
    <div class="containercompras">
        <div class="box">
            <div class="imgBox">
                <img class="imagem" src="images/imgbox1.jpg">
            </div>
            <div class="descricao">
                <div class="contentdescr">
                    <h2>Sombras</h2>
                    <p><a href="aaa.php" name="versombras">Ver mais</a></p>
                </div>
            </div>      
        </div>
        <div class="box">
            <div class="imgBox">
                <img class="imagem" src="images/imgbox2.jpg">
            </div>
            <div class="descricao">
                <div class="contentdescr">
                    <h2>Rimel</h2>
                    <p><a href="">Ver mais</a></p>
                </div>
            </div>
        </div>

The part where I have to see more I’m supposed to load and go to another page and show certain products, which I’ll get from the database. They on the other page works perfectly, I just can’t do that by pressing "See more" go to the other page and show only those products of a single category..

On the other page I did so for all categories and gave:

<?php
header('Content-Type: text/html;charset=UTF-8');
include("ligabd.php");

if (isset($_POST['sombras'])) {
    $procura = "SELECT * FROM produtos WHERE id_categoria='1'";
   ...
?>

Answer 1

You can do this by placing parameters on your href to pick up the page where you want it to list certain items. For example like this:

I’m going to use the piece of your code from the items "Shadows"

<div class="descricao">
                <div class="contentdescr">
                    <h2>Sombras</h2>
                    <p><a href="aaa.php" name="versombras">Ver mais</a></p>
                </div>

On the href of the line <p><a href="aaa.php" name="versombras">Ver mais</a></p> you add an identification parameter, as an example, I will put the parameter ?id=1, being like this:

<p><a href="aaa.php?id=1" name="versombras">Ver mais</a></p>

And so you add in as many links as you have (but I recommend a cont++ or other attribute if it’s multiple types of items).

Then on the "aaa.php" page you can notice that by clicking on See more the link will be "aaa.php? id=1". So you use this line on your page

$id = (int) $_GET['id'];

This line will take the value (integer) corresponding to your URL parameter (in the case of shadows, it will take the value 1), then you put this in your sql query, thus:

    $procura = "SELECT * FROM produtos WHERE id_categoria='$id'";
   ...

So whenever you click on a link, the page where you will list these items, will do a database search using the URL identification parameter to make the specific request, and will list neat and neat on the page.

The whole code goes like this:

index php.:

<form action="" method="POST">
    <div class="containercompras">
        <div class="box">
            <div class="imgBox">
                <img class="imagem" src="images/imgbox1.jpg">
            </div>
            <div class="descricao">
                <div class="contentdescr">
                    <h2>Sombras</h2>
                    <p><a href="aaa.php?id=1" name="versombras">Ver mais</a></p>
                </div>
            </div>      
        </div>
        <div class="box">
            <div class="imgBox">
                <img class="imagem" src="images/imgbox2.jpg">
            </div>
            <div class="descricao">
                <div class="contentdescr">
                    <h2>Rimel</h2>
                    <p><a href="aaa.php?id=2">Ver mais</a></p>
                </div>
            </div>
        </div>

aaa.php:

<?php
//inicia session
session_start();

//header
header('Content-Type: text/html;charset=UTF-8');

//inclui o arquivo do banco
include("ligabd.php");

//pega o id do item no link
$id = (int) $_GET['id'];

//listar as compras
  $procura = "SELECT * FROM produtos WHERE id_categoria='$id' ";

//query para imprimir as buscas
  $faz_procura = mysqli_query($link, $procura);
?>
<html>
  <body>
      <table id="itens" border="2">
          <thead>
              <tr>
                <td>ID</td>
                <td>Item</td>
                <td>Preço</td>
              </tr>
          </thead>
        <tbody>
    <?php

//while para listar todos os dados baseados no ID_CATEGORIA
  while ($row = mysqli_fetch_assoc($faz_procura)){
    ?>

    <tr>
          <td><?php echo $row['id_produto'] ?> </td>
          <td><?php echo $row['nome_produto'] ?> </td>
          <td><?php echo $row['preco_produto'] ?> </td>
    </tr>
  <?php }; ?>

    </tbody>
   </table>
  </body>
 </html>