Total price of selected products...

[pavmoxo]

Hi!!

What can I do for obtain a total price of selected products with checkboxes.
I tried with the next piece of code but I don't know how to obtain the final result of the order:

foreach ($produto as $p) 
                        {
                            echo $p."<br />";
                            
                            $sql = "select preco from produtos where nome = '".$p."'";
                            $queryl = query($sql) or die ("Query failed: " . mysql_error() . " Actual query: " . $sql);
                            $arrl = mysql_fetch_array($queryl);
                            $conta = $arrl["preco"];
                            echo $conta."<br />";
                            
                            
                        } 

[blm126]

query() should be mysql_query first of all. Also you need a database connection to do that. And I don't see how that code is even close to dealing with check boxes. Do a google search for a PHP tutorial.

[pavmoxo]

Thanks but someone already helps me!!

But at this moment I wan't a field to insert a amount of a product and I wan't to show the total price of the product. I don´t know sure what to do!!! It´s similar to the checkboxes?? How can correspond to a selected checkbox??

Thanks for all!!!

[pavmoxo]

Thanks but someone already helps me!!

But at this moment I wan't a field to insert a amount of a product and I wan't to show the total price of the product. I don´t know sure what to do!!! It´s similar to the checkboxes?? How can correspond to a selected checkbox??

Thanks for all!!!

Hello!! Can you help me with this??

Code

<input name="produto[]" type="checkbox" value="<? echo $arrl["nome"]; ?>">
...
<input name="quant[]" type="text" size="1">



$produto = $_POST["produto"];
$quant = $_POST["quant"];

<?  
                        if($produto) 
                        { 
                            foreach ($produto as $p) 
                            { 
                                        $sql = "select * from produtos p, tipo_prod t where p.tipo_ID = t.tipo_ID and p.nome = '".$p."'"; 
                                        $queryl = query($sql) or die ("Query failed: " . mysql_error() . " Actual query: " . $sql); 
                                        $arrl = mysql_fetch_array($queryl); 
                                     
                                        $conta = $arrl["preco"]; 
                                         
                                         
                                         
                                            foreach ($quant as $q) 
                                            { 
                                                $total_prod = $conta * $q; 
                                             
                                                echo $arrl["tipo_nome"]." - ".$p." - ".$total_prod."<br />"; 
                                            } 
                                         
                                        //echo $conta."<br />";   
                                        $total[] = $conta; 
                            } 
                            //echo "Total: ".array_sum($total); 
                        } 
                        else 
                        { 
                            echo "<script>alert('Para realizar uma encomenda necessita de escolher pelo menos um produto');</script>"; 
                            echo "<meta http-equiv=\"refresh\" content=\"0;URL=mag_order_1.php\">"; 
                        } 
                         
                        ?>

An Output:

T-Shirt&#180;s - Very Hot - 4
T-Shirt&#180;s - Very Hot - 0
T-Shirt&#180;s - Very Hot - 0

1 product selected with amount of 1. There are 3 products registered.