[php5]

I am making a custom portal for one of the users on this forum, dripdown, and part of it is a news system. Part of that news system is the ability for the admin account to delete news articles. I want the administrator to be able to check all boxes that he wants to delete. That part's easy.

But what I need to do is get it to delete all ones that are marked. Here is the current code:

PHP Code:

<?

$root = './../';

//Setup page

$pagename = 'Add News';

include($root . 'admin/admin_header.php');

//Begin handling the form.

if($_POST['submit'])

{

    $db->query($sql);

    $sql = 'DELETE FROM `news` WHERE `title` = \'' . $_POST['title'] . '\'';

    $result = $db->query($sql);

    if($result)

    {

        $message = 'All selected news entries have been deleted.';

    }

}

?>

<form action="<? $PHP_SELF ?>" method="post">

    <p>

        Select all entries which you wish to delete. <b>This <i>cannot</i> be undone.</b>

    </p>

    <p>

        <?

        $sql = 'SELECT * FROM news';

        $result = $db->query($sql);

        while($rows = $db->fetchrow($result))

        {

            echo '<input type="checkbox" name="' . strtolower($rows['title']) . '" value="' . $rows['title'] . '" /> ' . $rows['title'] . '<BR />';

        }

        ?>

    </p>

    <p>

        <input type="submit" name="submit" class="blink" value=">>Delete News<<" />

    </p>

</form>

<?

//include($root . 'admin/admin_footer.php');

?>

I think I need to somehow do a while look that executes the delete query for every one that is checked. But I don't know how.

If someone could direct me in the right direction, I'd be quite happy.
Thanks in advance,
-php5

[sszettella]

Just as you iterated over the rows to create the checkbox names, you will need to iterate over the same result set to "get" the state of the checkbox from the post. In pseudo-code:

PHP Code:

$sql = 'SELECT * FROM news';

$result = $db->query($sql);

while($rows = $db->fetchrow($result)) {

  if ($_POST[$rows['title']] == 'on') {

    $sql2 = 'DELETE FROM `news` WHERE `title` = \'' . $_POST[$rows['title']] . '\'';

    $db->query($sq2); 

} 

Note, what this really does, is "get" the title from the DB, then "get" the value of the "title" named checkbox. Then, if the checkbox is checked, the delete query will be executed.

This is one approach that should work for you.

[php5]

Awesome! Thanks. I'll try it out and reply back here with my results!

[php5]

Originally Posted by sszettella

Just as you iterated over the rows to create the checkbox names, you will need to iterate over the same result set to "get" the state of the checkbox from the post. In pseudo-code:

PHP Code:

$sql = 'SELECT * FROM news';

$result = $db->query($sql);

while($rows = $db->fetchrow($result)) {

  if ($_POST[$rows['title']] == 'on') {

    $sql2 = 'DELETE FROM `news` WHERE `title` = \'' . $_POST[$rows['title']] . '\'';

    $db->query($sq2); 

} 

Note, what this really does, is "get" the title from the DB, then "get" the value of the "title" named checkbox. Then, if the checkbox is checked, the delete query will be executed.

This is one approach that should work for you.

EDIT: I guess it was just that one bad apple. I removed it in phpMyAdmin and tried again with a new one and it worked. THANKS!


Thanks for your help!
-php5