Delete multiple rows from mysql database
<p>I want to delete multiple rows from mysql database using php code this my code but i have this message error how to solve this ?</p>

<blockquote>
  <p>You have an error in your SQL syntax; check the manual that
  corresponds to your MySQL server version for the right syntax to use
  near 'on' at line 1</p>
</blockquote>

<pre><code>$files_query=mysqli_query($conn,"select * from tbl_files where db_isdeleted='1'")or die(mysqli_error($conn));
          if(mysqli_num_rows($files_query)&gt;0){
          echo"&lt;table class='table table-hover table-responsive table-bordered'&gt;&lt;tr&gt;";
          echo"&lt;td style='background:#f7ac01;font-size:16px;text-align: center;'&gt;&lt;input type='checkbox' class='allcb' data-child='chk'/&gt;&lt;/td&gt;
               &lt;td style='background:#f7ac01;font-size:16px;text-align: center;'&gt;FileName&lt;/td&gt;
               &lt;td style='background:#f7ac01;font-size:16px;text-align: center;'&gt;Date&lt;/td&gt;";
        echo"&lt;/tr&gt;";      
          while($row=mysqli_fetch_array($files_query)){
              $id=$row['db_id'];
              $name=$row['name'];
              $date=$row['db_date'];
              echo"&lt;tr&gt;";
         echo'&lt;form method="post" action=""&gt;';
        echo"&lt;input type='hidden' name='txt_table' value='tbl_files'&gt;";
        echo"&lt;input type='hidden' name='txt_action' value='files'&gt;";    
         echo"&lt;td style='text-align: center;'&gt;&lt;input type='checkbox' name='item[]'  class='chk'/&gt;&lt;/td&gt;";        

         echo"&lt;td style='text-align: center;'&gt;$name&lt;/td&gt;";

         echo"&lt;td style='text-align: center;'&gt;$date&lt;/td&gt;";

          }
      echo"&lt;/tr&gt;";
      echo"&lt;/table&gt;";
            echo"&lt;input type='submit' name='delete' value='Delete' class='btn btn-danger'&gt;&amp;nbsp;";
            echo"&lt;input type='submit' name='restore' value='Restore' class='btn btn-success'&gt;";
             echo"&lt;/form&gt;";
      } 
</code></pre>

<p>/************************</p>

<pre><code>&lt;?php
  if(isset($_POST['delete'])){
      $table=$_POST['txt_table'];
      $action=$_POST['txt_action'];
       foreach($_REQUEST['item'] as $id) {
        // delete the item with the id $id
    $delete_query=mysqli_query($conn,"DELETE FROM {$table} WHERE db_id=$id")or die(mysqli_error($conn));
    header("location:recyclebin.php?action=$action&amp;msg=1");       
    }
  }  
?&gt;
</code></pre>