Admin control

[Billett]

If possible could anyone write a code for me that would be able to show a form that u can delete users from a mysql table, either by the user_id, username, or email address.

if not could you help me to write one

Cheers

[phprock]

This is just a thought... is this what you want.. ?

$id=intval($_POST["id"];
$uname=addslashes($_POST["uname"]);
$uemail=addslashes($_POST["umail"]);

$result=@mysql_query(
"DELETE FROM user WHERE user_id='$id' OR user_name='$uname' OR user_email='$uemail",$db);

if($result){
echo"User Deleted succesfully";

}else{

echo"Sorry,User couldn't be deleted";
}

[Billett]

yeah this looks promising, i'll have a go on it see what i can do

cheers

[Billett]

Ok i tries this but it doesn't work any suggestions?

<?php 

if (isset($_POST['submit'])) { 

require_once ('./mysql_connect.php');

$id = intval($_POST['userid']);
$un = addslashes($_POST['username']);
$e = addslashes($_POST['email']);

	$query = "DELETE FROM user WHERE user_id='$id' OR username='$un' OR email='$e";		
	$result = @mysql_query ($query);
	$row = mysql_fetch_array ($result, MYSQL_NUM)

if($row){
echo"User Deleted succesfully";

} else{

echo"Sorry,User couldn't be deleted";
}
}
?>
<form>
<p class="style1">Delete User_id: <input name="id" type="text" value="userid" maxlength="5"></p>
<p class="style1">Delete Username: <input name="username" type="text" value="username" maxlength="5"></p>
<p><span class="style1">Delete Email Address:</span><input name="email" type="text" value="email" maxlength="5"></p>
<p><input name="Delete" type="submit" value="Delete"></p>

</form>

[helz]

you dont need:

$row = mysql_fetch_array ($result, MYSQL_NUM)

as your deleting information from the database and not getting information (SELECT)

also you can add this onto the end of your mysql_query line:

$result = @mysql_query($query) or die(mysql_error());

also if you use the or die part then you do not need the if else statement below...

Heres an updated version for you to ponder at:

<?php 

if (isset($_POST['submit'])) { 

  require_once ('./mysql_connect.php'); 

  $id = intval($_POST['userid']); 
  $un = addslashes($_POST['username']); 
  $e = addslashes($_POST['email']); 

  $query = "DELETE FROM user WHERE user_id='$id' OR username='$un' OR email='$e' "; 
  $result = mysql_query($query) or die(mysql_error()); 
  $row = mysql_fetch_array ($result, MYSQL_NUM) 

  echo "User Deleted succesfully";  

} 
?> 
<form> 
<p class="style1">Delete User_id: <input name="id" type="text" value="userid" maxlength="5"></p> 
<p class="style1">Delete Username: <input name="username" type="text" value="username" maxlength="5"></p> 
<p><span class="style1">Delete Email Address:</span><input name="email" type="text" value="email" maxlength="5"></p> 
<p><input name="Delete" type="submit" value="Delete"></p>
</form>

Just one more thing, on the second code you posted at the end of your $query you had a parse error as you forgot to use a close single quote [ ' ] for the end of your last email='$e'

[Billett]

ok my code is as follows, i noticed one mistake which was the sumbit button was name="delete" not name="sumbit", but even this doesn't seem to make a difference, the form shows up but when submit button is clicked nothing happens, no error messages come and none logged in error.log file, i then noticed the in the mysql statement the the name of my table was users not user again i changed this but still nothing 🙁

i have also noticed that in my address bar once submit is clicked this appears:

http://billett.hopto.org/delete_use...p;submit=Delete

instead of just:

http://billett.hopto.org/delete_user.php

<?php  

if (isset($_POST['submit'])) {  

  require_once ('./mysql_connect.php');  

  $id = intval($_POST['userid']);  

  $un = addslashes($_POST['username']);  

  $e = addslashes($_POST['email']);  

  $query = "DELETE FROM users WHERE user_id = '$id' OR username = '$un' OR email = '$e' ";  

  $result = mysql_query($query) or die(mysql_error());   

  echo 'User Deleted succesfully';   

}

?>  

<form> 
<p class="style1">Delete User_id: <input name="userid" type="text" maxlength="50"></p> 
<p class="style1">Delete Username: <input name="username" type="text" maxlength="50"></p> 
<p><span class="style1">Delete Email Address:</span><input name="email" type="text" maxlength="50"></p> 
<p><input name="submit" type="submit" value="Delete"></p> 
</form>

[Billett]

anyone 🙁

[mtimdog]

you have to set the method of the form to post as in

<form method="post">

because the default is get

[Billett]

Thanx that worked fine