problem with checkboxes

geo

Hello! I'm new in PHP and I can't understand how to make chekboxes work. I want to create tables with different names and then when I choose some to delete them.I could really use some help in how to make the checkboxes work. Here is what I have done:

<?php

@ $db=mysql_pconnect("localhost");
if(!$db)
{
echo "<hr>";
echo "Error:Could not connect to server.Unable to authenticate user.";
echo "<hr>";
exit;
}

echo "Successfully connected to server.";

@ $mysql=mysql_select_db("bigbang") or die ("Could not open database");

echo " Successfully connected to database. ";
echo"<hr>";

echo '<a href="delete.php?<?php print ?>">Delete</a> ';

$show_query = "show tables";
$result = mysql_query($show_query,$db);
$num_rows = mysql_num_rows($result);
echo" There are currently $num_rows customers ----->";

echo" ";

print "<table border=2>\n";
while ( $a_row = mysql_fetch_row( $result ) )
{
print "<tr>\n";
foreach ( $a_row as $field )
$check = '<input type="checkbox" name="check[]" value="1">';
print "\t<td>$check $field</td>\n";
print "</tr>\n";
}
print "</table>\n";
?>

</body>
</html>

peppeto

I don't understand wich tables do you want to delete
be more specifik

geo

Thanks for replying. What I've done shows me all the names of the tables in a database with a checkbox next to them.What I want is to delete those that are checked.

Shrike

foreach($_POST['check'] as $value){
  mysql_query("DROP TABLE $value")
    or echo mysql_error();
}

ahundiak

But first you will need to wrap the check boxes in a form so there values will get posted.

geo

I did this:
<?php

@ $db=mysql_pconnect("localhost");
if(!$db)
{
echo "<hr>";
echo "Error:Could not connect to server.Unable to authenticate user.";
echo "<hr>";
exit;
}

echo "Successfully connected to server.";

@ $mysql=mysql_select_db("bigbang") or die ("Could not open database");
echo " Successfully connected to database. ";

foreach($_POST['check'] as $value)
{
mysql_query("DROP TABLE $value")
or die ("could not add data");
}

print " You erased : $value";
echo" ";

And it gives me this message:
Warning: Invalid argument supplied for foreach() on line 17

ahundiak

Again, you need to use a form to get the values to actually post. And if the user does not check any then $_POST['check'] won't have anything in it and you will get the same error.

The html:
<form method="post" action="delete.php">
<input type="checkbox" name="check[]" value="table 1" />
<input type="checkbox" name="check[]" value="table 2" />
<input type="submit" name="delete" value="Delete" />
</form>

delete.php
<?php
/* First see if the delete button was pressed */
if (isset($_POST['delete'])) {
  /* Get the checked boxes */
  if (isset($_POST['check'])) $checks = $_POST['check'];
  else        $checks = array();
  foreach($checks as $check) {
    echo 'Table ' . $check . '<br />' . "\n";
  }
}

Once you understand the basic posting process then add in the actual mysql code. And BTW, use mysql_connect and not mysql_pconnect unless you really know what the difference is.

geo

Thanks for all your help. I used a form as you told me but I can't understand how the $_POST works because I'm not very familiar with PHP. Instead I tried this

delete.php

$show_query = "show tables";
$result = mysql_query($show_query,$db);
$num_rows = mysql_num_rows($result);
$s_row = mysql_fetch_array($result);
for ($i=0;$i<$num_rows;$i++)
{if ($$s_row[$i] == on)
{$drop_query = "drop table $s_row[$i]";
$result = mysql_query($drop_query,$db);}

and it worked fine.Thaks again.