Delete multiple rows by selecting checkboxes using PHP

Question

I want to delete multiple rows from MYSQL database  I have created this delete php file to select various links and delete them using checkboxes     lt html gt   lt head gt    lt title gt Links Page lt  title gt    lt  head gt    lt body gt    lt h2 gt Choose and delete selected links  lt  h2 gt    lt  php   dbc   mysqli connect  localhost   root   admin   sample   or die  Error connecting to MySQL server      query    select   from links ORDER BY link id     result   mysqli query  dbc  query  or die  Error querying database      count mysqli num rows  result     gt    lt table width  400  border  0  cellspacing  1  cellpadding  0  gt   lt tr gt   lt td gt  lt form name  form1  method  post  action    gt   lt table width  400  border  0  cellpadding  3  cellspacing  1  bgcolor   CCCCCC  gt   lt tr gt   lt td bgcolor   FFFFFF  gt  amp nbsp  lt  td gt   lt td colspan  3  bgcolor   FFFFFF  gt  lt strong gt Delete multiple links lt  strong gt   lt  td gt   lt  tr gt   lt tr gt   lt td align  center  bgcolor   FFFFFF  gt   lt  td gt   lt td align  center  bgcolor   FFFFFF  gt  lt strong gt Link ID lt  strong gt  lt  td gt   lt td align  center  bgcolor   FFFFFF  gt  lt strong gt Link Name lt  strong gt  lt  td gt   lt td align  center  bgcolor   FFFFFF  gt  lt strong gt Link URL lt  strong gt  lt  td gt   lt  tr gt    lt  php  while   row mysqli fetch array  result       gt    lt tr gt   lt td align  center  bgcolor   FFFFFF  gt  lt input name  checkbox  type  checkbox  value   lt  php echo  row  link id      gt   gt  lt  td gt   lt td bgcolor   FFFFFF  gt  lt  php echo  row  link id      gt  lt  td gt   lt td bgcolor   FFFFFF  gt  lt  php echo  row  link name      gt  lt  td gt   lt td bgcolor   FFFFFF  gt  lt  php echo  row  link url      gt  lt  td gt   lt  tr gt    lt  php     gt    lt tr gt   lt td colspan  4  align  center  bgcolor   FFFFFF  gt  lt input name  delete  type  submit  value  Delete  gt  lt  td gt   lt  tr gt   lt table width  400  border  0  cellspacing  1  cellpadding  0  gt   lt tr gt   lt td gt  lt form name  form1  method  post  action    gt   lt table width  400  border  0  cellpadding  3  cellspacing  1  bgcolor   CCCCCC  gt    lt tr gt   lt td bgcolor   FFFFFF  gt  amp nbsp  lt  td gt   lt td colspan  3  bgcolor   FFFFFF  gt  lt strong gt Delete multiple links lt  strong gt   lt  td gt   lt  tr gt   lt tr gt   lt td align  center  bgcolor   FFFFFF  gt   lt  td gt   lt td align  center  bgcolor   FFFFFF  gt  lt strong gt Link ID lt  strong gt  lt  td gt   lt td align  center  bgcolor   FFFFFF  gt  lt strong gt Link Name lt  strong gt  lt  td gt   lt td align  center  bgcolor   FFFFFF  gt  lt strong gt Link URL lt  strong gt  lt  td gt    lt  tr gt    lt  php  while   row mysqli fetch array  result       gt    lt tr gt   lt td align  center  bgcolor   FFFFFF  gt  lt input name  checkbox  type  checkbox  value   lt  php echo  row  link id      gt   gt  lt  td gt   lt td bgcolor   FFFFFF  gt  lt  php echo  row  link id      gt  lt  td gt   lt td bgcolor   FFFFFF  gt  lt  php echo  row  link name      gt  lt  td gt   lt td bgcolor   FFFFFF  gt  lt  php echo  row  link url      gt  lt  td gt   lt  tr gt    lt  php     gt    lt tr gt   lt td colspan  4  align  center  bgcolor   FFFFFF  gt  lt input name  delete  type  submit  value  Delete  gt  lt  td gt   lt  tr gt      lt  php     Check if delete button active  start this   if isset   POST  delete            checkbox     POST  checkbox     for  i 0  i lt count  checkbox   i       del id    checkbox  i    sql    DELETE FROM links WHERE link id   del id     result   mysqli query  sql        if successful redirect to delete multiple php  if  result   echo   lt meta http-equiv   refresh   content   0 URL view links php   gt          mysqli close  dbc      gt    lt  table gt   lt  form gt   lt  td gt   lt  tr gt   lt  table gt    lt  body gt    lt  html gt    This doesn t seem to delete any row  My data is populated in the table  I guess the problem is with the PHP code  Please help me out here

User · Answer

Use array notation like name  checkbox    in your input element   This will give you   POST  checkbox   as array  In the query you can utilize it as   sql    DELETE FROM links WHERE link id in     sql        implode       array values   POST  checkbox             Thats one single query to delete them all   Note  You need to escape the values passed in   POST  checkbox   with mysql real escape string or similar to prevent SQL Injection

User · Answer

Something that sometimes crops up you may maynot be aware of    Won t always be picked up by by   POST  delete   when using IE   Firefox and chrome should work fine though   I use a seperate  isntead which solves the problem for IE  As for your not deleting in your code above you appear to be echoing out 2x sets of check boxes both pulling the same data  Is this just a copy   paste mistake or is this actually how your code is   If its how your code is that ll be the problem as the user could be ticking one checkbox array item but the other one will be unchecked so the php code for delete is getting confused   Either rename the 2nd check box or delete that block of html surely you don t need to display the same list twice

User · Answer

lt  php  sql    SELECT   FROM guest book                                res   mysql query  sql                               if  mysql num rows  res                                  query   mysql query  SELECT   FROM guest book ORDER BY id                                 i 1                              while  row   mysql fetch assoc  query                                  gt     lt input type  checkbox  name  checkboxstatus  lt  php echo  i    gt    value   lt  php echo  row  id      gt      gt    lt  php  i         gt     lt input type  submit  value  Delete  name  Delete    gt   if   REQUEST  Delete                if  empty   REQUEST  checkboxstatus                checked values     REQUEST  checkboxstatus            foreach  checked values as  val                 sqldel    DELETE from guest book WHERE id     val               mysql query  sqldel

User · Answer

You should treat it as an array like this    lt input name  checkbox    type  checkbox  value   lt  php echo  row  link id      gt   gt    Then only  you can take its count and loop it for deletion   You also need to pass the database connection to the query    result   mysqli query  dbc   sql     Yours did not include it    result   mysqli query  sql

User · Answer

Delete Multiple checkbox using PHP Code   lt input type  checkbox  name  chkbox    value    row 0     gt   lt input type  submit  name  delete  value  delete   gt   lt  php if isset   POST  delete         cnt array      cnt count   POST  chkbox      for  i 0  i lt  cnt  i              del id   POST  chkbox    i         query  delete from  tablename where Id    del id       mysql query  query

User · Answer

deleted     POST  checkbox      sql    DELETE FROM  tbl name WHERE id IN    implode       deleted

[php] Delete multiple rows by selecting checkboxes using PHP

Examples related to php

Examples related to html

Examples related to mysql

Examples related to checkbox

Examples related to isset