计数表结果:使用单选按钮值的 PHP 开关案例

The page reloads when another radio button is clicked similar to Facebook search. I wanted to count the number of equipment per Condition and State to be displayed beside the radio button label. BUT, the state radio buttons affect the counting of equipment. For example, New EQ is the type of equipment that was just entered into the inventory. When the New EQ button is checked and Available/Unassigned button is also checked, the table result will be filtered that will display results that contain equipment with a state that is New and a condition that is Available/Unassigned. The table result will be counted and will be outputted beside the radio button label which tells the user how many equipment are "New" and "Available/Unassigned". When another state radio button is clicked, such as Old EQ button, The displayed quantity of the Available/Unassigned equipment beside the label will change depending on the number of rows returned because the user changed the request to output equipment that is "Old" and "Available/Unassigned". BTW the state and condition are columns in the same table. This will happen to all the radio buttons. If the user clicks another radio button under the Condition category, such as the Assigned EQ button, the quantity of the Available/Unassigned displayed beside the label will change to 0 or zero because the user requested that the table result should display equipment that are New and Assigned, the equipment that is Available/Unassigned was not requested. If the user clicks "All condition" button, it will count the table rows that contain ALL the conditions which also has a data on its row a New state. The filtering process to display table results is already functioning. I am now working on outputting the quantities beside the radio button labels.

<?php

switch($state AND $condition){
    case $state=="allstate" AND $condition=="allcondition":
        $sql3="SELECT *FROM eq_inv WHERE eq_condition='Available/Unassigned'";
        break;

    case $state=="new" AND $condition=="allcondition":
        $sql3="SELECT *FROM eq_inv WHERE eq_condition='Available/Unassigned' AND eq_state='new'";
        break;

    case $state=="old" AND $condition=="allcondition":
        $sql3="SELECT *FROM eq_inv WHERE eq_condition='Available/Unassigned' AND eq_state='old'";
        break;

    case $state=="Unknown state" AND $condition=="allcondition":
        $sql3="SELECT *FROM eq_inv WHERE eq_condition='Available/Unassigned' AND eq_state='Unknown state'";
        break;

    case $state=="Unknown state" AND $condition=="Available/Unassigned":
        $sql3="SELECT *FROM eq_inv WHERE eq_condition='Available/Unassigned' AND eq_state='Unknown state'";
        break;
}
         //Code above is incomplete
$result3=mysqli_query($conn,$sql3);
$count=mysqli_num_rows($result3);
echo "<label style='color:red;'><strong>".$count."</strong></label>";

?>

分类:

状态:所有状态，新，旧，未知状态

switch ($state)
{
    case "allstate":
        if ($condition == "allcondition")
            $sql3 = "SELECT *FROM eq_inv WHERE eq_condition='Available/Unassigned'";
        break;

    case "new":
        if ($condition == "allcondition")
            $sql3 = "SELECT *FROM eq_inv WHERE eq_condition='Available/Unassigned' AND eq_state='new'";
        break;

    case "old":
        if ($condition == "allcondition")
            $sql3 = "SELECT *FROM eq_inv WHERE eq_condition='Available/Unassigned' AND eq_state='old'";
        break;

    case "Unknown state":
        switch ($condition)
        {
            case "Available/Unassigned":
            case "allcondition":
                $sql3 = "SELECT *FROM eq_inv WHERE eq_condition='Available/Unassigned' AND eq_state='Unknown state'";
                break;

        }
}