how to have a variable take a value from one page and move to another

Question

I have this code below.

<?php
       include '../conexao.php';

       $sth = $pdo->prepare('SELECT * FROM comanda');
       $sth->execute();
       ?>
      
                       <?php
                       foreach ($sth as $res) {
                           extract($res);
                       ?>
                           <center>
                               <ul>
                                   <a href="#.php"><img id="efeito" src="../img/<?= $num_com ?>.png"></a>
                               </ul>
                           </center>
                       <?php
                       }
                       ?>

here the code line with the "href" brings a data from the bank and uses in the $num_com.
I need to make sure that when I select a command(image) it takes the specific value of the variable and stores in another to be used in an Index in the future.
how can I do this ?

thanks in advance for the attention.

Answer 1

can do by creating a "GET Receiver" on and perform an Insert function on the database.

I will demonstrate the logic and you implement according to your scenario!

1. First, let’s imagine that below is where the value will come:

www.localhost/pegaValor? value=2 <- Here we have the value 2 being passed through the GET method in a variable called value

2. Then you need to receive this value, in case we will receive on the page: catch that will stay that way:

$value = $_GET['value']; <- Here is where you will receive the value, from here is success, you now just need to give an input in the BD.

$sql = "Insert into TABLE ('column name') VALUE = '$value';"

Study: Pass by $_GET and $_POST (These you should master)