Delete and Update Multiple Rows Using PHP

In this tutorial, we will select multiple rows through checkboxes and we will update/delete them.

First, you will have to make a database:

Index.php:

<body><center>
<div style="width:500px;">
<form name="frmUser" method="post">
<table border="0" cellpadding="20" cellspacing="2" width="500" class="tblListForm">
<tr class="head">
<td></td>
<td><h2>UserName</h2></td>
<td><h2>First Name</h2></td>
<td><h2>Last Name</h2></td>
</tr>
<?php
$i=0;
while($row = mysqli_fetch_array($result)) {
?>
<tr class="rows">
<td><input type="checkbox" name="members[]" value="<?php echo $row["ID"]; ?>" ></td>
<td><?php echo $row["Username"]; ?></td>
<td><?php echo $row["FirstName"]; ?></td>
<td><?php echo $row["lastName"]; ?></td>
</tr>
<?php
$i++;
}
?>
<tr class="head">
<td colspan="4"><input id="update" type="button" name="Edit" value="Edit" onClick="setUpdateAction();" /> 
				<input id="del" type="button" name="delete" value="Delete"  onClick="setDeleteAction();" />
</td>
</tr>
</table>
</form>
</div></center>
</body>

<td><h2>UserName</h2></td>

<td><h2>First Name</h2></td>

</tr>

<?php

$i=0;

while($row = mysqli_fetch_array($result)) {

</tr>

<?php

$i++;

}

</td>

</tr>

</table>

</form>

</div></center>

</body>

Output:

Update.php

<body>
<form name="frmUser" method="post" action="">
	<center>
<div style="width:500px;">
<table border="0" cellpadding="10" cellspacing="0" width="500" align="center">
<tr class="head">
<td>Edit Member</td>
</tr>
<?php
$count = count($_POST["members"]);
for($i=0;$i<$count;$i++) {
$result = mysqli_query($conn, "SELECT * FROM members WHERE ID='" . $_POST["members"][$i] . "'");
$row[$i]= mysqli_fetch_array($result);
?>
<tr>
<td>
<table border="0" cellpadding="20" cellspacing="0" width="500" align="center" class="tblSaveForm">
<tr>
<td><label>Username</label></td>
<td><input type="hidden" name="ID[]" class="txtField" value="<?php echo $row[$i]['ID']; ?>"><input type="text" name="Username[]" class="txtField" value="<?php echo $row[$i]['Username']; ?>"></td>
</tr>
<tr>
<td><label>Password</label></td>
<td><input type="password" name="password[]" class="txtField" value="<?php echo $row[$i]['password']; ?>"></td>
</tr>
<td><label>First Name</label></td>
<td><input type="text" name="FirstName[]" class="txtField" value="<?php echo $row[$i]['FirstName']; ?>"></td>
</tr>
<td><label>Last Name</label></td>
<td><input type="text" name="lastName[]" class="txtField" value="<?php echo $row[$i]['lastName']; ?>"></td>
</tr>
</table>
</td>
</tr>
<?php
}
?>
<tr>
<td colspan="2"><input type="submit" name="submit" value="Submit" class="btnSubmit"></td>
</tr>
</table>
</div></center>
</form>
</body>

<body>

<td>Edit Member</td>

</tr>

<?php

$count = count($_POST["members"]);

for($i=0;$i<$count;$i++) {

$result = mysqli_query($conn, "SELECT * FROM members WHERE ID='" . $_POST["members"][$i] . "'");

$row[$i]= mysqli_fetch_array($result);

<tr>

<td>

<tr>

<td><label>Username</label></td>

</tr>

<tr>

<td><label>Password</label></td>

</tr>

<td><label>First Name</label></td>

</tr>

</tr>

</table>

</td>

</tr>

<?php

}

<tr>

</tr>

</table>

</div></center>

</form>

</body>

Output:

Delete.php

<?php
require_once "conn.php";
$Count = count($_POST["members"]);
for($i=0;$i<$Count;$i++) {
mysqli_query($conn, "DELETE FROM members WHERE ID='" . $_POST["members"][$i] . "'");
}
header("Location:index.php");
?>

<?php

require_once "conn.php";

$Count = count($_POST["members"]);

for($i=0;$i<$Count;$i++) {

mysqli_query($conn, "DELETE FROM members WHERE ID='" . $_POST["members"][$i] . "'");

}

header("Location:index.php");

Output:

CSS:

You can download the CSS code from the download link below.

Download Code – delmultiplerows

Delete and Update Multiple Rows Using PHP

Related Posts: