Chkbox & delete

[davy_yg]

Hello, I create this backend system. When someone click check box then press apply. This script suppose to delete all rows that are checked. How to do so? It seems like the script are incomplete.

<?php
    $i=0;
    while ($data = mysql_fetch_array($result)){
    $result2=($i%2)?'#DFA09D':'white';
        echo "<tr bgcolor='$result2'>";
        echo '<td><input type="checkbox" name="vehicle" value="Bike"></td>';
        echo '<td>'.$data['productname'].'</td>';
        echo '<td>'.$data['location'].'</td>';
        echo '<td>'.$data['description'].'</td>';
        echo '<td>'.$data['urlimages'].'</td>';
        echo '<td><a href="product.php?mode=delete&id='.$data['id'].'">Hapus</a> |<a href="input_image.php?id='.$data['id'].'">Edit</a></td>';
        echo '</tr>';
    $i++;
    }
    ?>
    </table>

    <br>
    <tr>
    <td><select name="lokasi">
    <option value="Show">Show</option>
    <option value="DoNotShow">Do Not Show</option>
    <option value="Delete">Delete</option>
    </select></td>
    <td><input type="submit" name="ok" value="Apply"/></td>
    </tr>
    </form>


    </div>

[pzuurveen]

Yes, this is missing a lot. Is this all you got?

[davy_yg]

yes, what else do I need to add?

[pzuurveen]

is this script part of product.php?

missing the that prosses the results
The part with either $_POST, $_GET, or $_REQUEST

[davy_yg]

yes, it's a part of product.php. How to code it?

[LastMitch]

yes, it's a part of product.php. How to code it?

There should be a delete query that is connected to those checkboxes.

<a href="product.php?mode=delete&id='.$data['id'].'">

The delete query will delete that id

I don't know what post so far but on this thread you don't have a query to do that but you have a link to delete that id.

Did you write any of this at all?

[Webville312]

This should help.

[Hemali22]

first of all you need to change the name of the checkbox, for now it becomes "vechicle" at every time.
so you need to change your whole code as following

<?
    if(isset($_POST['submit'])
    {
        $del = 0;
        for($i=0; $i<total_no_rows; $i++)
        {
            $delete_id = 'vehicle_'.$i
            if($_POST[$delete_id] == 1)
            {
                mysql_query("YOUR DELETE QUERY");
                 $del++;
            }
        }
        Echo 'Your total '.$del.' Records are deleted';
}


<form name="delete_form" id="delete_form" method="post" action="">
<?php
    $i=0;
    while ($data = mysql_fetch_array($result)){
    $result2=($i%2)?'#DFA09D':'white';
        echo "<tr bgcolor='$result2'>";
        echo '<td><input type="checkbox" name="**vehicle_'.$i.'**" value="1"></td>';
        echo '<td>'.$data['productname'].'</td>';
        echo '<td>'.$data['location'].'</td>';
        echo '<td>'.$data['description'].'</td>';
        echo '<td>'.$data['urlimages'].'</td>';
        echo '<td><a href="product.php?mode=delete&id='.$data['id'].'">Hapus</a> |<a href="input_image.php?id='.$data['id'].'">Edit</a></td>';
        echo '</tr>';
    $i++;
    }
    ?>

    <tr>
    <td><select name="lokasi">
    <option value="Show">Show</option>
    <option value="DoNotShow">Do Not Show</option>
    <option value="Delete">Delete</option>
    </select></td>
    <td><input type="submit" name="ok" value="Apply"/></td>
    </tr>
    </table>
    </form>

[Webville312]

First, create the form like so;

<form method="post" target="some/php/script.php">
    <input type="checkbox" name="item[]" value="1" />
    <input type="checkbox" name="item[]" value="2" />
    <input type="checkbox" name="item[]" value="3" />
    <input type="submit" name="delete" value="Delete checked items" />
</form>

Note that the items in the checkbox are taken as an array. Then in your php script, you do this;

if(empty($_REQUEST['item'])) {
    // No items checked
}
else {
    foreach($_REQUEST['item'] as $id) {
        // delete the item with the id $id
    }
}

[Hemali22]

yes this is also the best way to create an array of the checkbox. @davy_yg did you get this?

[davy_yg]

Does the loop knows which items that I checked ?

Does it mean that the items that I checked passed an id number ?