Today we are Learning to Update or Delete multiple rows using PHP
We need to delete and update multiple rows in the backend of our website at times. Suppose you can manually delete and update a single project, but in a large project, you have to use delete and update multiple rows.
This can also save our time and we can also make your backend more attractive.
let’s start Update or Delete Multiple Rows Using PHP.
Table of Contents
Step 1: Create New Database and Table
Create a new chart named database
Then
Create a new table name for its users and add some value to it.
CREATE TABLE `users` (
`userId` int(8) NOT NULL,
`userName` varchar(55) NOT NULL,
`password` varchar(55) NOT NULL,
`firstName` varchar(55) NOT NULL,
`lastName` varchar(55) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Step 2: Create config.php File.
Step 3: Create index.php File.
alert('Insert Data');";
}else{
echo "error";
}
}
?>
Insert Data
Insert Your Data
Step 4: Create show_data.php File.
For each user row, we will use checkboxes here and show our data
Users Show Data List
Show your DATA
Step 5: Create edit_user.php File.
Edit Multiple User
Step 6: Create delete_user.php File.
Step 7: Create users.js File.
function setUpdateAction() {
document.frmUser.action = "edit_user.php";
document.frmUser.submit();
}
function setDeleteAction() {
if(confirm("Are you sure want to delete these rows?")) {
document.frmUser.action = "delete_user.php";
document.frmUser.submit();
}
}
Step 8: Create a style.css File.
To make our UI design more attractive we will create a style.css file here and write the style code in it.
body {
font-family:Arial;
margin: 0;
padding: 0;
}
.insert{
text-align: center;
}
.insert
table{
margin: auto;
}
.insert h1{
text-transform: uppercase;
color: #000f65;
font-size: 25px;
}
.show{
text-align: center;
}
.show table{
margin: auto;
}
.show
h1{
text-transform: uppercase;
color: #000fff;
font-size: 25px;
}
input {
font-family:Arial;
font-size:14px;
}
label{
font-family:Arial;
font-size:14px;
color:#999999;
}
.tblSaveForm {
border-top:2px #999999 solid;
background-color: #f8f8f8;
}
.tableheader {
background-color: yellow;
}
.tablerow {
background-color: #A7D6F1;
color:white;
}
.btnSubmit {
background-color:#fd9512;
padding:5px;
border-color:#FF6600;
border-radius:4px;
color:white;
}
.message {
color: #FF0000;
text-align: center;
width: 100%;
}
.txtField {
padding: 5px;
border:#fedc4d 1px solid;
border-radius:4px;
}
.evenRow {
background-color: #E2EDF9;
font-size:12px;
color:#101010;
}
.evenRow:hover {
background-color: #ffef46;
}
.oddRow {
background-color: #B3E8FF;
font-size:12px;
color:#101010;
}
.oddRow:hover {
background-color: #ffef46;
}
.tblListForm {
border-top:2px #999999 solid;
}
.listheader {
background-color: yellow;
font-size:12px;
font-weight:bold;
}