[mlbpa2]

ok first thing is on my main page news update id like to make it so i have a page that displays each news thing with a checkbox next to it so i can delete it. Also for the array addition id like to have a text box thing so it adds to this array.

$sections = array("Section1", "Section2", "Section3");

[Keith]

This would be the script that builds the form. Use remove[] to build the array $remove:

PHP Code:

<form action="remove.php" method="post">



<?php



$query = mysql_query("SELECT id,name FROM table");

    while ($rows = mysql_fetch_assoc($query))

    echo "<input type=\"checkbox\" name=\"remove[]\" value=\"" . $rows['id'] . "\" /> " . $rows['name'] . "<br />\n";



?>



<input type="submit" name="submit" value="Remove">

</form>

Then in the processing file "remove.php":

PHP Code:

<?php



if (isset($_POST['remove'])) {



    foreach ($_POST['remove'] as $id) {

    mysql_query("DELETE FROM table WHERE id = '" . $id . "'");



echo "Selected items have been removed.<br />";



}

else

echo "No items were selected.<br />";



?>

I think that's what you're aiming for, hope it helps.

[mlbpa2]

yeah thats exactly what i need but im getting a parse error on the else line.

found the error you were missing a }

[Keith]

Yeah, whoops... take out the { after the foreach(). I didn't forget one, just stuck one where it shouldn't be

remove.php:

PHP Code:

 <?php



if (isset($_POST['remove'])) {



    foreach ($_POST['remove'] as $id)

    mysql_query("DELETE FROM table WHERE id = '" . $id . "'");



echo "Selected items have been removed.<br />";



}

else

echo "No items were selected.<br />";



?>

[ciggie]

I am new to PHP and have been trying to get this feature to work as well by using your code Keith. But everytime I try it I get the no items selected return. Any explanations of what I am doing wrong would be much appreciated:

<form action="removeteach.php" method="post">
<?php
...
while ($get_info = mysql_fetch_row($result)) {
print "<tr>\n";
foreach ($get_info as $field)
print "\t<td><input type=\"checkbox\" name=\"remove[]\" value=\"" . $rows['teachid'] . "\" /></td>\n";
print "\t<td>$field</td>\n";
...
?>

removeteach.php file
<?php

if (isset($_POST['remove'])) {

foreach ($_POST['remove'] as $teachid)
mysql_query("DELETE FROM teacherid WHERE teachid = '" . $teachid . "'") or die ('Can\'t delete : ' .

mysql_error());

}
else
echo "No items selected";

?>

[Keith]

What version of PHP are you running? In removeteach.php, try changing all occurences of
$_POST['remove']
to
$HTTP_POST_VARS['remove']

[ciggie]

Got the same result as last time, where it says No Items Selected. I am running php 4.3.3.

[Keith]

Aha, I see what you have wrong...

PHP Code:

<form action="removeteach.php" method="post">

<?php

...

while ($get_info = mysql_fetch_row($result)) {

print "<tr>\n";

foreach ($get_info as $field)

print "\t<td><input type=\"checkbox\" name=\"remove[]\" value=\"" . $rows['teachid'] . "\" /></td>\n";

print "\t<td>$field</td>\n";

...

?>

change $rows['teachid'] to $get_info['teachid']

[ciggie]

Still a no go Keith. Thank you for your continuing help though, any other ideas?

[Infinite_Hackers]

If the script below doesn't work, could you please show us your $result and the script you use to connect to mysql ;D

PHP Code:

<form action="removeteach.php" method="post">

<?php

...

while ($row = mysql_fetch_row($result)) {

         $get_info[] = $row;

}

          

print "<tr>\n";

foreach ($get_info as $field) {

print "\t<td><input type=\"checkbox\" name=\"remove[]\" value=\"" . $field['teachid'] . "\" /></td>\n";

print "\t<td> What goes here ?? we need some variable.. you can't put ' field'</td>\n";



...

?>

What goes here ?? we need some variable.. you can't put ' field'
you cannot put $field there... you need $field['some row name']