dynamic form to delete and ban from 2 tables, I'm lost here!

dmacman1962

Hi all,

I don't know if this is the best/safest way to do this, but I will give it a shot.

I have a guestbook that I want to do a lookup that shows all the posts at once (of course, in a managable list like 25 per page), so I can view the post, check the 'ban IP' and delete checkboxes for all the posts I want to purge, and then delete/ban them all at once.

The issue is the actual posts are in the gbook_students table and the table that holds the banned IP addresses is in the gb_ban_students table (the 'Ban IP' record is just adding the IP address and the ID is auto-incremented).

What I am trying to do is like this...

Demo Form

Here is the code...

<?PHP 
include "mysql table connection to the db.php"; // this will connect to the database that hold both tables
session_start();
$order="SELECT * from gbook_students";
$order2=mysql_query($order) or die(mysql_error());

// HTML code
<form action="" method="get"><table width="500" border="0">
  <tr>
    <td><strong>ID (hidden) </strong></td>
    <td><strong>IP Address </strong></td>
    <td><strong>Ban IP </strong></td>
    <td><strong>Delete</strong></td>
    <td><strong>Name</strong></td>
    <td><strong>Comment</strong></td>
  </tr>
  <tr>
    <td>(0) hidden </td>
    <td>1.1.1.1</td>
    <td><label>
      <input type="checkbox" name="checkbox2" value="checkbox" />
      Ban</label></td>
    <td><label>
      <input type="checkbox" name="checkbox" value="checkbox" />
      Delete</label></td>
    <td>Joe Smith </td>
    <td>Garbage post </td>
  </tr>
  <tr>
    <td>(0) hidden </td>
    <td>1.1.1.2</td>
    <td><label>
      <input type="checkbox" name="checkbox2" value="checkbox" />
      Ban</label></td>
    <td><label>
      <input type="checkbox" name="checkbox" value="checkbox" />
      Delete</label></td>
    <td>Jane Smith </td>
    <td>Garbage post </td>
  </tr><tr>
    <td>(0) hidden </td>
    <td>1.1.1.3</td>
    <td><label>
      <input type="checkbox" name="checkbox2" value="checkbox" />
      Ban</label></td>
    <td><label>
      <input type="checkbox" name="checkbox" value="checkbox" />
      Delete</label></td>
    <td>Fred Smith </td>
    <td>Garbage post </td>
  </tr><tr>
    <td>(0) hidden </td>
    <td>1.1.1.4</td>
    <td><label>
      <input type="checkbox" name="checkbox2" value="checkbox" />
      Ban</label></td>
    <td><label>
      <input type="checkbox" name="checkbox" value="checkbox" />
      Delete</label></td>
    <td>Tom Smith </td>
    <td>Garbage post </td>
  </tr>
</table>
<input name="Reset" type="reset" value="Reset" />
<input type="submit" name="Submit" value="Submit" />
</form>
// End HTMl code
?>

I know I will need to do something like...

echo '<form>';
echo '<table><tr><td>IP</td><td>Name</td><td>IP</td><td>Delete</td><td>Ban</td><tr>';
	while($order3=mysql_fetch_array($order2)) {
	echo '<td>'.$order3['ID'].'</td><input name='.$order3['Name'].' type="checkbox" value='.$order3['IP'].' /><td><input name='.$order3['delete'].' type="checkbox" value='.$order3['ban'].' /></td></tr></table>';
echo '}';
echo '</form>';

But I do not know if that will allow me to modify 2 tables at the same time?

Also, how to pass those changes to 2 tables at the same time.

I hope this is clear enough, if not, please ask.

Thanks in advance,
Don

cbj4074

I think we need a little more explanation.

From your code, I see that you're querying the gbook_students table, presumably for all guest book entries. It then appears that you're planning to iterate through each result in the set and print some HTML form components that will allow the user/administrator/whomever to perform some task(s) relative to those entries.

My first question is, "Why do you need to update two tables? Which two?" You have only made reference to one table in your example. We need to know which tables are involved and what exactly you are intending to do with the information the user/administrator/whomever provides.

The short answer, though, is, "Yes. It's possible to update two tables at once."

With some further explanation, I think we can at least get you started down the right path.

dmacman1962

Hi cbj,

I figured I would need to elaborate some more.

I have 2 tables because the 1 table gb_banip_students, holds the IP address of any user we 'Ban' from posting after they have posted inapropriate info. This is a table that several 'guestbooks' use. It only has 2 fields (ID) and (IP). I need to add a new entry to this when I ban somone and want to use my 'New admin HTML form' that I am writing (yes, you are correct, it is an html form, with php added).

The 2nd table is the actual guestbook, gbook_students, holds the posts that the user makes and I an itterating thru a lookup to get all the records and display them in my HTML form.

Here is a demo of what I am trying to pull off... My demo HTML only form sample.

Basically, until the 'powers that be' allow me to drop this guestbook and use something with better 'SPAM' control, like phpBB, I need to purge the obscene posts. They currently have an admin page, but it is cumbersome, go to the posts, copy the IP address, hit delete, say 'Yes', hit ban IP, paste address, submit, say yes, start over. This is a pain to get rid of dozens of posts overnight.

I wanted a simple table with all posts, IP, name, and comments to purge/ban dozens of them at once.

Does that make more sense?

I have the php semi written, but did not want to write it all only to find I went down the wrong path and start over. I thougt I could get some direction and do it correct the first time.

Thanks for helping,

Don