PHP - Delete An Entry From A Forum

I have  a code where i can edit or delete certain details from the database. Right now, if the user clicks on the edit button it takes him edit page where he can edit the details. But, I am not able to Incorporate a Delete button such that, when the user clicks on a delete button, it should ask for a confirmation box. If the user clicks YES, then do the following:

Code: [Select]
DELETE from emp WHERE emp_id='$emp_id';
When there are multiple entries and I click on delete it deletes everything from the database. how can i make it to delete only the entry that is besides the delete button?

Code: [Select]
if(mysql_num_rows($emp_query) > 0){
echo "<table border='1'>";
echo "<th>Employee Id </th>";
echo "<th>Employee Name </th>";
while($get_emp = mysql_fetch_assoc($emp_query)){
$emp_id = $get_emp['emp_id'];
$emp_name = $get_emp['first_name']." ".$get_emp['last_name'];
echo "<tr>";
echo "<td width='100'>";
echo $emp_id;
echo "</td>";
echo "<td width='400'>";
echo $emp_name;
$edit_path = 'edit_employee.php?id='.$emp_id;

?>
<INPUT TYPE="button" style="display:inline;" value="VIEW / EDIT" onClick="location.href='<?php echo $edit_path; ?>'">
<form style='margin: 0; padding: 0; display:inline;' method="post" action="<?php echo $_SERVER['PHP_SELF'];?>" onSubmit="return confirm('Are you sure this is correct?');">
<input style='display:inline;' name="delbutton" type="submit" value="DELETE">
<?php if(isset($_POST['delbutton'])){
$del_emp = mysql_query("DELETE from employee WHERE emp_id = '$emp_id'") or die(mysql_error());
    //header('Location:view_employee.php');
  }
echo '</form>';

echo "</td>";
echo "</tr>";
}

}

Hey guys

I have trouble picking the specific id of an entry i want to delete

so please take a look at the codes first

Here's the function for making the form:

Code: [Select]
function am_query_display_quick($page,$order ='DATE DESC'){
global $email;
$conn = db_connect_2();
$color1 = "tableRowOdd";
$color2 = "tableRowEven";
$RowCount = 0;

$result = $conn->query("SELECT pro,pro_update,ana,ana_update,cell,cell_update,cellother,cellother_update,gen,gen_update,genother,genother_update,author,author_update,other,other_update,id
FROM mailing_list
WHERE email = '$email'
ORDER BY $order LIMIT $start_row, $max_per_page;");

echo "<form method = \"post\" action=\".{$_SERVER['PHP_SELF']}.\">";
echo "<table class=\"sortable\" id=\"query_quick2\" width=\"100%\" >\r\n";
echo "\t<tr><th></th><th>Promoter
Locus</th><th>Update?</th><th>Anatomical Area</th><th>Update?</th><th>Cell
Type</th><th>Update?</th><th>Other Cell Type</th><th>Update?</th><th>Genetic
Background</th><th>Update?</th><th>Other Gen.
Back.</th><th>Update?</th><th>Author</th><th>Update?</th><th>Other</th><th>Update?</th><th></th>\r\n";

if($result->num_rows){
while ($row = $result->fetch_array()){
$RowCount ++;
$row_color = ($RowCount % 2) ? $color1 : $color2;

echo "\t<tr class=\"$row_color\" ><td><input type=\"submit\" name=\"edit_mail\" value = \"Edit\"/></td>
<td>{$row['pro']}</td><td>{$row['pro_update']}</td><td>{$row['ana']}</td>
<td>{$row['ana_update']}</td><td>{$row['cell']}</td><td>{$row['cell_update']}</td><td>{$row['cellother']}</td>
<td>{$row['cellother_update']}</td><td>{$row['gen']}</td><td>{$row['gen_update']}</td><td>{$row['genother']}</td>
<td>{$row['genother_update']}</td><td>{$row['author']}</td><td>{$row['author_update']}</td><td>{$row['other']}</td><td>{$row['other_update']}</td>
<td><input type=\"submit\" name=\"delete_mail\" value =\"Delete\"/></td>
<td><input type =\"hidden\" name = \"id\" value=\"{$row['id']}\"/></td>
</tr>";


}
}

echo "</table>";
echo "</form>";

And this is where the delete command comes into place (excerpt):


Code: [Select]
} elseif(isset($_SESSION['user_id']) AND isset($_POST['delete_mail'])){
//user is deleting existing queries
$conn=db_connect_2();
$id = mysqli_real_escape_string($conn, $_POST['id']);
echo $id;

$sql2 = "DELETE FROM mailing_list WHERE id='$id'";
$result = mysqli_query($conn, $sql2) or mysqli_error($conn);

$msgs[] = "Query deleted successfully.";
$body = "account.php";

}


yes it can delete entries all right

but it doesn't delete a specific entry when i click the "delete" button near it

somehow, it ALWAYS deletes the last row of entry at the table

as you can see, i echoed out $id as it's referring to the LAST entry as well

So my question is, how to delete a particular entry when i click the corresponding "delete" button??

Thanks

I'm working on an old cms I built a few years ago and for some reason my Delete page isn't working.  It has to be something simple I'm overlooking.  The database connection is made just above this code and is pulling the thumb and title listed by id.  When I push delete I'm getting the cmd=delete&id=2 passed on so something is up with my last if statement (I think).  Here is the code:

if(!isset($cmd)) 
{
   //display all the news
   $result = mysql_query("select * from verizon order by id"); 
   

   
   //run the while loop that grabs all the news scripts
   while($r=mysql_fetch_array($result)) 
   { 
      //grab the title and the ID of the enws
      $title=$r["title"];//take out the title
      $id=$r["id"];//take out the id
      $thumb=$r["thumb"];
      
      echo "<div id='delete'>
            <table>
<tr>
  <td width='350px'><strong>$title</strong></td><td><a href='verizondelete.php?cmd=delete&id=$id'>  Delete</a></td>
</tr>
<td colspan='2' align='center'><img src='../upload/verizon/$thumb'></td>
    </table>
         
          </div><br />";
    }
}

if($cmd=="delete")
{
    $sql = "DELETE FROM verizon WHERE id='$id'";
    $result = mysql_query($sql);
    echo "<h1 style='text-align:center;'>deleted!</h1>";
} 

}
?>

No errors come up when I run this but it just doesn't delete the entry.



<?
$rec = $_POST['stock'];
if (!$rec){ 
die ('Please eneter a stock number');
}

$link = mysql_connect("xxxx","xxx","xxx");
mysql_select_db('wadkin', $link) or die( "Unable to select database");

mysql_query("DELETE FROM 'wadkin'.'stocklist' WHERE 'stocklist'.'Stock Number' = $rec")
or die ('Query failed');

mysql_close($link);

?>


Can someone please correct,

(btw I have also tried... "DELETE FROM stocklist WHERE 'Stock Number' = $rec")

Alright,  wasn't quite sure how to summarize this in the title,  but I want to:

Check if a user status is "active" or not based on the UserName input.

I have a table witch holds:

Code: [Select]
VarChar Username      Var CharPassWord     int Active
 Ted                        TedsPW                1
something like the above(assuming it formatted correctly.

In my php script I will want to input a variable for Username to check for:

inputUN in this example would be "Ted".

$UserNameToCheck = $_GET['inputUN'];

Then I want to check for that UserName in the database,  if it exists,  I want pull the value for the "Active" field for just that UserName and echo it.

Thanks for any help.