Databases
StackOverflow2013
Postsdbo
POPHP to delete SQL row with multiple checkboxes
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POPHP to delete SQL row with multiple checkboxes
    primarykey
    data
    text
    <p>I am trying to delete multiple rows with chekboxes. Below is my code </p> <pre><code> &lt;?php $host="localhost"; // Host name $username="****"; // Mysql username $password="****"; // Mysql password $db_name="****"; // Database name $tbl_name="****"; // Table name // Connect to server and select database. mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select DB"); $result = mysql_query("SELECT * FROM members WHERE dealer='Panzer Protection'"); ?&gt; &lt;form name="form1" method="post" action=""&gt; &lt;?php while($rows=mysql_fetch_array($result)){ ?&gt; &lt;tr&gt; &lt;td bgcolor="#666666"&gt;&lt;input name="checkbox[]" type="checkbox" id="checkbox[]" value="&lt;? echo $rows['member_id']; ?&gt;"&gt;&lt;/td&gt; &lt;td bgcolor="#666666"&gt;&lt;? echo $rows['member_id']; ?&gt;&lt;/td&gt; &lt;td bgcolor="#666666"&gt;&lt;center&gt; &lt;? echo $rows['member_msisdn']; ?&gt;&lt;/td&gt; &lt;td bgcolor="#666666"&gt;&lt;center&gt; &lt;? echo $rows['member_name']; ?&gt;&lt;/td&gt; &lt;td bgcolor="#666666"&gt;&lt;div align="center"&gt;&lt;? echo $rows['dealer']; ?&gt;&lt;/div&gt; &lt;/td&gt; &lt;td align="center" bgcolor="#FFFFFF"&gt;&lt;a href="control_clientinfo.php?member_id= &lt;? echo $rows['member_id']; ?&gt;" class="update"&gt;Look Up&lt;/a&gt;&lt;/td&gt; &lt;/tr&gt; &lt;?php } ?&gt; &lt;tr&gt; &lt;td colspan="6" align="center" bgcolor="#FFFFFF"&gt;&lt;input name="delete" type="submit" id="delete" value="Delete"&gt;&lt;/td&gt; &lt;/tr&gt; &lt;/form&gt; //Forgot form close in past &lt;?php // Check if delete button active, start this if($_POST['delete']){ for($i=0;$i&lt;$count;$i++){ $i = 0; while(list($key, $val) = each($_POST['checkbox'])) { $sql = "DELETE FROM $tbl_name WHERE id='$val'"; mysql_query($sql); $i += mysql_affected_rows(); } } // if successful redirect to if($result){ echo "&lt;meta http-equiv=\"refresh\" content=\"0;URL=control_clientlistdel.php\"&gt;"; } } mysql_close(); ?&gt; </code></pre> <p>It shows me the list i call and i can tick the boxes. If i hit delete button it just refreshes the screen and the one i ticked is still there</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USTrevor Ackermann
    1. USTrevor Ackermann
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    3. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COYour DELETE query is prone to SQL injection. Properly escape user contents or, better, learn about parametrized queries. Note that `mysql_*` functions are deprecated (see the [red box](http://php.net/mysql_query)). And use `htmlspecialchars` when outputting database fields to your HTML markup to prevent XSS. And the `bgcolor` and `align` attributes are deprecated. And the `center` element, too.
      singulars
      1. POPHP to delete SQL row with multiple checkboxes
      1. USMarcel Korpel
    2. COWhere does your form close?
      singulars
      1. POPHP to delete SQL row with multiple checkboxes
      1. USitsols
    3. COAlso, to capture the button being clicked you should use something like $_POST["delete"]. Do NOT use just $delete. This used to be a method with the old PHP 4 and earlier but this is no longer accepted. Furthermore, you should check for the delete BEFORE you print the results. Otherwise it will print the records and then delete. Makes no sense
      singulars
      1. POPHP to delete SQL row with multiple checkboxes
      1. USitsols
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload