我的代码不是从数据库中删除记录。 [英] My code isn't deleting records from th database.

问题描述

 <   tr  >  
 <   th  >  <  输入   类型  =  submit    name   =  delete    id   =  delete    value   = 删除 >  <   / th  >  
 <   th  >  name < span class =code-keyword><   / th  >  
 <   th  >  comp < span class =code-keyword><   / th  >  
 <   / tr  >  
 
 $ query = mysql_query（SELECT * FROM riv）; 
 $ count = mysql_num_rows（$ query）; 
 while（$ riv = mysql_fetch_assoc（$ query））{
 
 echo<   tr  > ; 
 echo<   td  >  <  输入    type   =  复选框 名称  =  复选框[]   id   =   checkbox []   value   =  <？php   echo     $ riv [id];     ??  >  <   / td  > ; 
 echo<   td  >  $ riv [name] <   / td   > ; 
 echo<   td  >  $ riv [comp] <   / td   > ; 
 echo<   / tr  > ; 
} 
？> 
 
 //检查删除按钮是否有效，启动此
 if（isset（$ _ POST ['delete']））{
 for（$ i = 0; $ i < span class =code-keyword><   $ count; $ i ++）{  
   
           if（isset（$ _ POST ['checkbox []' ]））{  
   
                   $ del_id     =  <跨度类= 代码关键字> $ ID [$ i]于; 
   
                   echo     $ del_id;   
   
                   $ sql     =  DELETE F ROM riv WHERE id ='$ del_id' ;   
   
              < span class =code-attribute>     $ result     =   mysql_query（$ sql）;} 
   
              < span class =code-attribute>}   
   
        < span class =code-attribute>    }     
   
  ？ >  

什么我试过了：



试过&创建了一个单独的删除代码，工作正常，但有复选框和&多次删除。

解决方案

query = mysql_query（SELECT * FROM riv）;

count = mysql_num_rows（

查询）;
while（

<tr>
<th><input type="submit" name="delete" id="delete" value="DELETE"></th>
<th>name</th>
<th>comp</th>
</tr>

$query=mysql_query("SELECT * FROM riv");
$count=mysql_num_rows($query);
while($riv=mysql_fetch_assoc($query)) {
      
	   echo"<tr>";
	   echo"<td><input type=checkbox name=checkbox[] id=checkbox[] value=<?php echo $riv[id]; ??></td>";
       echo"<td>$riv[name]</td>";
       echo"<td>$riv[comp]</td>";
	   echo"</tr>";
}	 
?>

// Check if delete button active, start this 
if(isset($_POST['delete'])){
for($i=0;$i<$count;$i++){

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

        $del_id = $id[$i];

        echo $del_id;

        $sql = "DELETE FROM riv WHERE id='$del_id'";

        $result = mysql_query($sql);}

      }

     }	

?>

What I have tried:

Tried & created a single delete code which works fine but having problems with checkbox & multiple delete.

解决方案

query=mysql_query("SELECT * FROM riv");

count=mysql_num_rows(

query); while(

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