I have this code that will show any product containing the word adidas in my database at a specified table. So the next thing is to link the code of the product to the certain product and then have it link to another page so that it will populate automatically recurring that product code.
I've tried the session method but it only gives me the last code. If there is this code: cha3
cha2
cha1
, it will give me cha1
no matter what I've clicked on the other page. What I wanted to do is if you click product with the code cha1
it will populate the produto.php
with the details of cha1
. Sorry if you don't understand. I'll post s snippet of code to give some idea. It's "clean" because I tried a lot of methods and until now nothing worked.
<?php
$ligaBD=odbc_connect('basededadospap','','');
$sql="SELECT * FROM produto WHERE nome_produto LIKE '%ADIDAS%'";
$resultado=odbc_exec($ligaBD,$sql);
?>
<div class="row shop_box-top">
<?php
while (odbc_fetch_row($resultado))
{
$codigo = odbc_result($resultado,1);
$nome = odbc_result($resultado,2);
$preco = odbc_result($resultado,4);
$foto1 = odbc_result($resultado,9);
?>
<div class="col-md-3 shop_box"> <a href="produto.php" >
<img src=" <?php echo $foto1;?>" class="img-responsive" alt=""/>
<span class="new-box">
<span class="new-label">Novo</span>
</span>
<?php $codigo ?>
<div class="shop_desc">
<h3><a href="produto.php> <?php echo $nome;?> </a></h3>
<span class="actual"><?php echo $preco; ?></span><br>
</div>
</a></div>
<?php }?>