How to make a mysql query from a link

Question

I have seen on some websites links that do mysql searches and return results, ie make a mysql query from a link instead of a field.

Assuming the link within the tag to were it so:

href="https://www.meulink.com" name="camisas" >Camisas

The user clicks on the link, the query is made in the database returning the corresponding values:

$sql = "SELECT roupas FROM estoque WHERE roupas='camisas';
$result = mysqli_query($conn, $sql);

if (mysqli_num_rows($result) > 0) {
    while($row = mysqli_fetch_assoc($result)) {
        echo $row["roupas"]."<br/>";
    }
} else {
    echo "Nada foi encontrado.";
}

Answer 1

You can achieve this by passing a parameter to the page, then the PHP can take this parameter and generate the appropriate content for the reader. For example, by clicking on shirts, you can have:

<a href="https://www.meulink.com" name="camisas" >Camisas</a>

Backend Action:

if(isset($_POST['camisas'])){
//Se a pagina enviar como post um clique nas camisas, então execute mysql query
$sql = "SELECT roupas FROM estoque WHERE roupas='camisas';
$result = mysqli_query($conn, $sql);

if (mysqli_num_rows($result) > 0) {
    while($row = mysqli_fetch_assoc($result)) {
        echo $row["roupas"]."<br/>";
    }
} else {
    echo "Nada foi encontrado.";
}
}

Of course there are several ways to do what you are asking, this is an example of how it could work for you, test there and see if it helps you.