php sql 在选中复选框时获取查询

Question

我只是想知道如何在 SQL 中获取列的值，当选中该复选框时，它会将这些值相加，因为它们是数字。

数据

表名=添加

    SEARCH = Dan

    -----------------------
    name   |   date    | Total | Checkbox
    -------------------------------------
    Dan    | dd/mm/yyy | 200   |  checked
    Dan    | dd/mm/yyy | 400   |  checked
    Dan    | dd/mm/yyy | 300   |  checked
    Dan    | dd/mm/yyy | 250   |  unchecked
    Dan    | dd/mm/yyy | 260   |  unchecked

TOTAL AMOUNT = 900

更新:这是我到目前为止所做的代码，但它仍然无法工作。

 <?php  

            include "connection.php";

                //$searchName= $_POST['submit'];


                if(isset($_POST['submit'])){
                    $searchName = $_POST['submit'];

                    $searchName = preg_replace("#[^0-9a-z]#i","",$searchName);

                    $query = "SELECT * FROM adding where Code LIKE '$searchName%' ORDER BY Date";
                    $result = mysql_query($query);

                    if(mysql_num_rows($result)>0){
                        echo "<form action=Payment.php method=get>";                            
                        echo "<table border='1'>
                        <tr>
                        <th>Name</th>
                        <th>Date</th>   
                        <th>Total</th>
                        <th>Checkbox</th>
                        </tr>";
                        while($row = mysql_fetch_array($result)){
                            //$idno = $row['id'];

                            echo "<tr>";
                            echo "<td>" . $row['Code'] . " </td>";
                            echo "<td>" . $row['Date'] . "</td>";
                            echo "<td>" . $row['Total'] . "</td>";
                            echo "<td><input type = \"checkbox\" name=\"pay[]\" value='{$row['id']}' ></td>";
                            echo "</form>"; 
                        }
                        echo "<table>";
                        echo "<input type=\"submit\" name =\"button2\" value=\"Submit\">";
                        echo "</form>";

                        if(isset($_GET['pay'])){

                            $checked=$_GET("pay");
                            $c= count($checked);
                            $totalpayment = $row['Total'];

                            for($i=0;$i<$c;$i++){
                                if($checked[$i]==$row['id']){
                                    $totalpayment = $totalpayment+$row['Total']; 
                                }
                            }
                            echo "total is: " .$totalpayment. "<br>";

                        } 


                    }
                    else{
                        echo "RECORD NOT FOUND!";
                    }




                }

                mysql_free_result($result);


            ?>

Answer 1

试试这个

select sum(total) as TOTAL AMOUNT from table
where Checkbox='checked'