admin cp

nem

hi
i just created a forum, and i was looking around on the web on how to delete the messages using a custom made admincp.

I know how to delete the messages through phpmyadmin, but how can i do this on a php document?

TheDefender

OK, if you created the forum script, then one would believe you probably have familiarity with things like the SELECT, INSERT, and UPDATE syntaxes in MySQL. Just use the one called DELETE. The rest is still pretty much the same.

(ie, DELETE * FROM yourtable WHERE username = '$username')

nem

the forum itself is very basic, as you can see:

http://www.dhost.hopto.org/gmforum/display.php

but how can i go about actually showing each individual post on a php page with a tick box.

TheDefender

It all depends on how you want to go about it... You could put an admin link on the main page you posted, and have that link to a log in form that you have some sort of validation on. That way, you can control it.

Then once you validate it, you have your script to prep the entries for deletion. There are a ton of ways to do it, ranging from just deleting one entry, to looping through a group of rows to delete simultaneously...

The hows:
Well, basically, what I recommend is that you go to hotscripts.com and look through the scripts and tutorials. I don't really have time to write an entire admin script for you. Maybe someone here can, or maybe it's already been posted in this forum... The basics go as follows:

<FORM method="POST" action="deleteitem.php">
<?
// Start with your connection script

// Run your query
$sql = mysql_query("SELECT * FROM table");

WHILE($row = mysql_fetch_array($sql))
{
  echo $row['title']."<input name=\"todelete[]\" type=\"checkbox\">";
}
?>
<input type="submit">
</FORM>

Then on the deleteitem.php file, you would get the array values you just posted, and loop through the checked boxes to delete them using a query kindof like:

<?
$countofitems = count($_POST['todelete']);
FOR($i = 0, $i < $countofitems, $i++)
{
mysql_query("DELETE FROM table WHERE id = '$i'");
}
?>

Now, this is by no means a complete script (no validation, and obviously, you need to adjust the count script to make sure it deletes the right id, etc.) but this is a basic premise of how to go about it. Like I said, there are a lot of ways. You need to dig into the php manual and mysql manual to get what you need.

Good Luck, and have fun with the learning...