$sql="SELECT * FROM $tbl_name";
$result=mysql_query($sql);
$count=mysql_num_rows($result);
?>
//A fair amount of html stuff . .
<?php
while($rows=mysql_fetch_array($result))
{ // Start looping table row
?>
<tr>
<td> </td>
<td align="center" bgcolor="#000000"><? echo $rows['id']; ?></a><BR></td>
<td align="center" bgcolor="#000000"><? echo $rows['myusername']; ?></td>
<td align="center" bgcolor="#000000"><? echo $rows['email']; ?></td>
<td align="center" bgcolor="#000000"><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<? echo $rows['id']; ?>"></td>
<tr>
</tr>
<?php
}
?>
<table align="center" class="t8">
<tr>
<td align="right" ><input class="button" name="delete" type="submit" id="delete" value="Delete"></td>
</tr>
</table>
<?
// Check if delete button active, start this
if($delete){
for($i=0;$i<$count;$i++){
$del_id = $checkbox[$i];
$sql = "DELETE FROM $tbl_name WHERE id='$del_id'";
$result = mysql_query($sql);
}
// if successful echo WTF ffs etc
if($result){
echo "wtf";
}
}
mysql_close();
?>
</form>
</table>
<?php
if($_POST['delete']) {
$success = 0;
$error = 0;
foreach($_POST['checkbox'] as $key => $value) {
$result = mysql_query("DELETE FROM $tbl_name where id = '$value'");
if($result) {
$success++;
} else {
$error++;
}
//you could replace that if/else statement with this one line of code....
// ($result) ? $success++ : $error++;
//but i didn't want to confuse things too much. :p
}
echo $success. ' records deleted successfully. There were ' . $error . ' errors.';
}
<input type="checkbox" name="selected_userid[]" value="<?=$data['userid'];?>">function delete_users($userid) {
mysql_query("DELETE FROM user WHERE userid='$userid'");
echo mysql_error();
echo "User(s) Deleted";
// do redirect code
}array_walk($_POST['selected_userid'], 'delete_users');if ($delete) {
function delete_users($userid) {
mysql_query("DELETE FROM user WHERE userid='$userid'");
echo mysql_error();
echo "User(s) Deleted";
// do redirect code
}
array_walk($_POST['selected_userid'], 'delete_users');
} else {
// do form with checkbox
?>
<form action="<?=$php_self;?>" method="post">
BLAH BLAH
<input type="checkbox" name="selected_userid[]" value="<?=$data['userid'];?>">
<input type="submit" name="delete" value="Delete User(s)">
<?
}
?>That method worked a treat, thankssnip
1) also place this code before you run the query that gets the results for the table display. i think the reason for that is obvious.
2) also, i'm assuming you have to be logged on as admin to view this page, so i haven't bothered with sanitising input.
is it not blindingly obvious?
you must process the deletion of users before running the query to display all users, otherwise you're going to be displaying users that are no longer in the database by time the page has finished loading.
Connect to DB
Select * from tbl_name
html
Start looping table row
html
Finish looping table row
Functional buttons
Run the for loopRetrieve
Delete
Refreshretrieve (for no reason whatsoever)
delete
refresh
retrieve again (this is why things are displayed ok)delete
retrieve
<!-- Connect shizzle -->
$myusername=$_SESSION['myusername'];
$avatar=$_POST['avatar'];
$sql="INSERT INTO $tbl_name(myusername, avatar)VALUES('$myusername', '$avatar')";
$result=mysql_query($sql);
<!--My table/form etc . .-->$sql="INSERT INTO $tbl_name(avatar)VALUES('$avatar')WHERE myusername = $myusername";
<?php
$tbl_name2="members"; // Switch to table "members"
$sql2="SELECT * FROM $tbl_name2 WHERE avatar='$avatar'";
$result2=mysql_query($sql2);
?><td> <img src="$avatar['avatar]" width="62" height="80" alt="Avatar" border="0" /> </a></td>Connect to DB
Retrieve original thread details
Display header table and all usual html stuff
*Connect to table members, to retrieve avatar info* ~This is the one where everything messes up~
HTML/CSS display original post
Connect to table 'create reply'
Retrieve reply details if they exist
Retrieve data and add views
Then add replies if done
Quick reply box
Thanks for the input . . I've gone too far into the design, there's no chance of a revamp, it's only for an assignment, once it's marked it shall be archived for reference