checkbox ???

[fozzie_fos]

Hi,

I'm a new newbie and need some help, please.

I get my info out of a database and in the file add.php I add stuff. I can delete and edit my info line by line and behind every line I've also put a checkbox. Now I want to click several boxes and then press the button delete block. So, I can delete the clicked lines. My problem? don't know how to do this... bummer

In the file add.php I've got a table where I put my boxes and then I've got a form with the 'delete block'-button. In an other file I put my commands(-->case DeleteBlock)

add.php

<table>
<?php
  if ($totalRows_view > 0){
  do 
  { ?>
...
<tr>
<td>
<a href="index.php?cmd=Del&r_id=<?php echo $row_view['r_id']; ?>&ListK=<?php echo $ListK?> &ListP=<?php echo $ListP?>">delete</a>
<input name="check" type="checkbox" value="Y" id="check"> 
<input name="cmd" type="hidden" id="cmd" value="DeleteBlock">
</td> 
</tr>
<?php } 
  while ($row_view = mysql_fetch_assoc($view));} ?>
</table> 

<form action=" " method="post" name="formBlockAction" id="formBlockAction"> 
...
<table>
<tr>
<td>
<input type="submit" name="Submit" value="delete block"  class="formbuttonC">
<input name="cmd" type="hidden" id="cmd" value="DeleteBlock">
</td>
</tr>
</table>
</form>

other file

switch ($cmd) {...
case "DeleteBlock":
		if ($GLOBALS[check] == 'Y') 
			{
				del();
				include "add.php";
			}

	else echo "help me";
break;
}

[Frederick]

In your primary query to grab the information and where your check boxes are located, make the name="" into an array.

<input type="checkbox" name="fieldname[<?php echo $row["id"];?>]" value="1">

In your delete query,

if (is_array($fieldname) {
foreach ($fieldname as $key => $value) {
$sql = mysql_query("DELETE FROM tablename WHERE id=$key") or die (mysql_error());
}
}

[fozzie_fos]

this is what i did, but still no go...

in add.php

<input type="checkbox" name="check[<?php echo $row_view['r_id'];?>]" value="1"> 
<input name="cmd" type="hidden" id="cmd" value="DeleteBlock"> 

in lib.php

function del_block()
{
 global $database_U, $U;

 if (is_array($check)) { 
  foreach ($check as $key => $value) { 
   $delblocksql ="DELETE FROM ur_rooster WHERE r_id=$key"; 
   mysql_select_db($database_U, $U);
   $Resultdelblock = mysql_query($delblocksql, $U) or die(mysql_error());
  } 
 }
}

in case.php

case "DeleteBlock":
	del_block();
	include "add.php";
break;

What am I doing wrong?

[Frederick]

Just simplify your query, no need to include all your current code.

$sql = mysql_query("DELETE FROM tablename WHERE id=$key") or die (mysql_error());

You have way more then you need here:
$delblocksql ="DELETE FROM ur_rooster WHERE r_id=$key";

mysql_select_db($database_U, $U);
$Resultdelblock = mysql_query($delblocksql, $U) or die(mysql_error());

Question, are you estabishing your DB connection from an include or require statement, if so, you do not need to add the variable for it in your query.

mysql_select_db($database_U, $U);

[fozzie_fos]

I'm using a require statement to establish my db connection. And I simplified the sql query as you said, but it still doesn't work.

[tsinka]

Hi,

try something like this:

function del_block()
{
 global $database_U, $U;

 if (isset($_POST["check"]) && is_array($_POST["check"])) { 
  mysql_select_db($database_U, $U);
  $delblocksql ="DELETE FROM ur_rooster WHERE r_id IN ('".implode("','",$_POST["check"])."')"; 
  $Resultdelblock = mysql_query($delblocksql, $U) or die(mysql_error());
 }
}

You need to use $_POST if register_globals is set to Off in php.ini.

Thomas

[fozzie_fos]

The register_globals are set on... i'm hopeless, sorry guys

[tsinka]

Ok,

so my code didn't work, too ?

Please post the complete script (as attachment).

Thomas

[tsinka]

Ok,

please post the complete form. I need it to check what's going on.

EDIT: forget it ... I found it 🙂

Thomas