deleting multiple rows from database in php

Replies

• 

  Manish Goyal

  can you post complete file here?
• 

  manojsinghrana

  here is the complete file.
  
  
  $host="localhost"; // Host name
  $username="root"; // Mysql username
  $password=""; // Mysql password
  $db_name="test"; // Database name
  $tbl_name="test_mysql"; // Table name
  
  // Connect to server and select databse.
  mysql_connect("localhost", "root", "")or die("cannot connect");
  mysql_select_db("test")or die("cannot select DB");
  
  $sql="SELECT * FROM $tbl_name";
  $result=mysql_query($sql);
  
  $count=mysql_num_rows($result);
  
  ?>
  
  
  
  
  

  while($rows=mysql_fetch_array($result)){ ?> } ?> // Check if delete button active, start this if($_POST['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 redirect to delete_multiple.php if($result){ echo ""; } } mysql_close(); ?>   Delete multiple rows in mysql # Id Name Lastname Email

• 

  Manish Goyal

  hey check this code ,it works
  
  Modify it according to your requirement
  
  Please post your code in code tags next time thanks
  
  

  
  
      
  
          
  
              
  
                  $value)
                              {
                              $sql="Delete from chandigarh where id='$value'";
                              $final=mysql_query($sql);
                              if($final)
                              {
                              echo "";
                              }                                            } 
                                  }
                                  }
                      // Check if delete button active, start this
                              
                              
  
  // if successful redirect to delete_multiple.php
                              
  mysql_close();
  ?>
  
                      
  
                          
   
                          
  [b]Delete multiple rows in mysql[/b] 
                      
                      
  
                          
  #
                          
  [b]Id[/b]
                          
  [b]Area ID[/b]
                          
  [b]Name[/b]
      
                      
  
                      
  
                          
  
                          
  
                          
  
                          
  
                      
                                          
  
  
                      
  
                          
  
                      
                      
  
  
  
  

• 

  Manish Goyal

  hey check this code ,it works
  
  Modify it according to your requirement
  
  Please post your code in code tags next time thanks
  
  

  
  
      
  
          
  
              
  
                  $value)
                              {
                              $sql="Delete from chandigarh where id='$value'";
                              $final=mysql_query($sql);
                              if($final)
                              {
                              echo "";
                              }                                            } 
                                  }
                                  }
                      // Check if delete button active, start this
                              
                              
  
  // if successful redirect to delete_multiple.php
                              
  mysql_close();
  ?>
  
                      
  
                          
   
                          
  [b]Delete multiple rows in mysql[/b] 
                      
                      
  
                          
  #
                          
  [b]Id[/b]
                          
  [b]Area ID[/b]
                          
  [b]Name[/b]
      
                      
  
                      
  
                          
  
                          
  
                          
  
                          
  
                      
                                          
  
  
                      
  
                          
  
                      
                      
  
  
  
  

• 

  Saandeep Sreerambatla

  I have checked the link and its not an advertisement.
  But please refrain from posting links , answer in your own words. If not explain what you learn. It doesnt help pasting links from google.
  
  If CE is accessible so is google for everyone.