Update and Delete Multiple User Account In PHP

Submitted by rinvizle on Wednesday, August 3, 2016 - 15:04.

In this tutorial we will teach you how to create and implement a Update and Delete Multiple User Account from the database using PHP. To select or identify multiple user accounts, we have to used check boxes and passed the ID of each user which were brought from the database to the check box assigned to each user in a html form. To submit the selected check boxes which holds the ID of each user detail for an update or deletion purpose, javascript is used for redirection to the pages with the scripts that performs the actions needed for each operation. See the sample code below.

Sample Code

Index.php - This script of file is compose of PHP and Html Form, this file is for displaying the users accounts from the database through the html form so the user will not go directly in the mysql database and they can easily viewed through the html interface.

<!DOCTYPE html>
<html>
<head>
        <title>Update & Delete Multiple User Account In PHP</title>
        <link rel="stylesheet" type="text/css" href="css/styles.css" />
<script language="javascript" type="text/javascript">
function update_data() 
        {
        document.form_name.action = "users-update.php";
        document.form_name.submit();
        }
function delete_data() 
{
if(confirm("Do you really mean to delete the details?")) 
        {
        document.form_name.action = "users-deletion.php";
        document.form_name.submit();
        }
}
</script>
</head>
<?php
        include "config.php";
        $users_details = mysql_query("select * from `user_update` order by `id` asc");
?>
<body>
<div style="width:500px; margin:0 auto; margin-top: 100px;">
        <form name="form_name" method="post" action="">
        <div class="header_title" align="center"><h1>Update & Delete Multiple User Account In PHP</h1></div>
                <table border="0" cellpadding="10" cellspacing="1" width="500" class="table_wrapper">
                        <tr class="table_header">
                                <td>First Name</td>
                                <td>Last Name</td>
                                <td>Username</td>
                                <td>Password</td>
                                <td style="text-align:center;">Action</td>
                        </tr>
                <?php
                $tclass = "dark";
                while($get_data = mysql_fetch_array($users_details)) 
                {
                ?>
                        <tr class="<?php echo isset($tclass) ? $tclass : ''; ?>">
                                <td><?php echo trim(strip_tags($get_data["firstname"])); ?></td>
                                <td><?php echo trim(strip_tags($get_data["lastname"])); ?></td>
                                <td><?php echo trim(strip_tags($get_data["username"])); ?></td>
                                <td><?php echo trim(strip_tags($get_data["password"])); ?></td>
                                <td style="text-align:center;"><input type="checkbox" name="users[]"  class="users" id="users" value="<?php echo trim(strip_tags($get_data["id"])); ?>" ></td>
                        </tr>
                <?php
                }
                ?>
                        <tr class="table_header">
                                <td colspan="5" align="center">
                                        <input class="button" type="button" name="update" value="Update" onClick="update_data();" /> 
                                        <input class="button" type="button" name="delete" value="Delete"  onClick="delete_data();" />
                                </td>
                        </tr>
                </table>
        </form>
</div>
</body>
</html>

User_Update.php - This script is for the updating the users acount or information.

<?php
session_start();
include "config.php";
if(isset($_POST["submit"]) && trim($_POST["submit"]) != "") 
{
        $counted_users = count($_POST["userId"]);
echo $counted_users;
for($i=0; $i<$counted_users; $i++) 
{
        mysql_query("update `user_update` set `firstname` = '".mysql_real_escape_string(trim(strip_tags($_POST["firstname"][$i])))."', `lastname` = '".mysql_real_escape_string(trim(strip_tags($_POST["lastname"][$i])))."', `username` = '".mysql_real_escape_string(trim(strip_tags($_POST["username"][$i])))."', `password` = '".mysql_real_escape_string(trim(strip_tags($_POST["password"][$i])))."' where `id` = '".mysql_real_escape_string(trim(strip_tags($_POST["userId"][$i])))."'");
}
        header("location:index.php");
}
?>
<!DOCTYPE html>
<html>
<head>
        <title>Update & Delete Multiple User Account In PHP</title>
        <link rel="stylesheet" type="text/css" href="css/styles.css" />
</head>
<body>
<div style="width:523px; margin: 0 auto; margin-top: 100px;"  align="center">
        <div class="header_title"><h1>Update & Delete Multiple User Account In PHP</h1></div>
<?php
$users_id = count($_POST["users"]);
if($users_id == 0)
{
?>
<div style="margin:0 auto; padding:10px; background:#FFFFEA; line-height:20px; border:1px solid #F1F1F1;">It seems you did not check any item to update.<br>Please click on the button below to go back and then check on an item to update.</div><br><br>
<div align="center" class="button" onClick="window.location.replace('index.php');">Back</div>
<?php
}
else
{
?>
<form name="frmUser" method="post" action="<?php echo isset($_SERVER['PHP_SELF']) ? trim($_SERVER['PHP_SELF']) : ""; ?>">
        <table border="0" cellpadding="10" cellspacing="0" width="500" align="center" class="table_wrapper">
        <tr class="table_header">
        <td>Update User Information</td>
        </tr>
        <?php
        for($i=0; $i<$users_id; $i++) 
        {
        $users_details = mysql_query("select * from `user_update` where `id` = '".mysql_real_escape_string(trim(strip_tags($_POST["users"][$i])))."'");
        $getdetail[$i] = mysql_fetch_array($users_details);
        ?>
                <tr>
                        <td>
                                <table border="0" cellpadding="10" cellspacing="0" width="500" align="center" class="inner_table">
                                        <tr>
                                                <td><label>First Name</label></td>
                                                <td><input type="text" name="firstname[]" class="field" value="<?php echo $getdetail[$i]['firstname']; ?>"></td>
                                        </tr>
                                        <tr>
                                                <td><label>Last Name</label></td>
                                                <td><input type="text" name="lastname[]" class="field" value="<?php echo $getdetail[$i]['lastname']; ?>"></td>
                                        </tr>
                                        <tr>
                                                <td><label>Username</label></td>
                                                <td>
                                                        <input type="hidden" name="userId[]" class="field" value="<?php echo $getdetail[$i]['id']; ?>">
                                                        <input type="text" name="username[]" class="field" value="<?php echo $getdetail[$i]['username']; ?>"></td>
                                        </tr>
                                        <tr>
                                                <td><label>Password</label></td>
                                                <td><input type="password" name="password[]" class="field" value="<?php echo $getdetail[$i]['password']; ?>"></td>
                                        </tr>
                                </table>
                        </td>
                </tr>
        <?php
        }
        ?>
                                        <tr>
                                                <td colspan="2" align="center"><input type="submit" name="submit" value="Save Changes" class="button"></td>
                                        </tr>
        </table>
</form>
<?php
}
?>
</div>
</body>
</html>

User_Deletion.php - This short script of code is for deleting a one or group of users account in the database.

<?php
session_start();
include "config.php";
        $users_id = count($_POST["users"]);
for($i=0; $i<$users_id; $i++) 
{
        mysql_query("delete from `user_update` where `id` = '".mysql_real_escape_string(trim(strip_tags($_POST["users"][$i])))."'");
}
        header("location: index.php");
?>

Hope that you learn in this project and enjoy coding. Don't forget to LIKE & SHARE this website.

Add new comment

2364 views