从mysql数据库中删除记录 [英] deleting record from mysql data base

问题描述

我有一个包含fname，lname和email addres以及动态添加的复选框字段的表.
一旦我选中了复选框，然后按Delete键，相关记录应被删除.
我尝试如下.

I have a table which contains fname,lname and email addres and dynamically added check box field too.
Once i checked the check box and then press delete button the relevent record should be deleted.
I tried as follows.

<?php
if(isset($_POST[''deleteAcc'']))//delete button
{
      $getEmail = "SELECT * FROM user";
      $getEmailResult = mysql_query($getEmail);
      while($r = mysql_fetch_array($getEmailResult))
      {
       $email = $r[''email''];
       if(isset($_POST[$email])!=NULL)//check box
       {
           $deleteUserQuery = "DELETE FROM user WHERE email=''$email''";
           $deleteUserQueryResult = mysql_query($deleteUserQuery);
           header(''Location:admin.php'');
       }
      }
}
?>

上面的代码在像``abc''之类的电子邮件时可以正常工作，但是在像``a@b.c''之类的电子邮件中则不起作用.

帮帮我吧！
谢谢.

above code will properly work when email something like ''abc''.but it does not work when email like ''a@b.c''.

help me!
thank you.

推荐答案

_POST [''deleteAcc''])))//删除按钮 {

_POST[''deleteAcc'']))//delete button {

getEmail ="SELECT * FROM user";

getEmail = "SELECT * FROM user";

getEmailResult = mysql_query(

getEmailResult = mysql_query(

这篇关于从mysql数据库中删除记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！