Part 5-Admin Panel(Registration): Edit and Update Data into Database in php

As per the video, we have already downloaded the files and linked the CSS and JS.

Step 1: Create a page register.php and paste the below code.

<?php

     include('security.php');

?>

<div class="container-fluid">

<!-- DataTales Example -->

<div class="card shadow mb-4">

  <div class="card-header py-3">

    <h6 class="m-0 font-weight-bold text-primary"> EDIT Admin Profile </h6>

  </div>

  <div class="card-body">

<?php

if(isset($_POST['edit_btn']))

{

    $id = $_POST['edit_id'];

    

    $query = "SELECT * FROM register WHERE id='$id' ";

    $query_run = mysqli_query($connection, $query);

    foreach($query_run as $row)

    {

        ?>

          <form action="code.php" method="POST">

                

              <input type="hidden" name="edit_id" value="<?php echo $row['id'] ?>" >

              

              <div class="form-group">

                  <label> Username </label>

                  <input type="text" name="edit_username" value="<?php echo $row['username'] ?>" class="form-control" placeholder="Enter Username">

              </div>

              <div class="form-group">

                  <label>Email</label>

                  <input type="email" name="edit_email" value="<?php echo $row['email'] ?>" class="form-control" placeholder="Enter Email">

              </div>

              <div class="form-group">

                  <label>Password</label>

                  <input type="password" name="edit_password" value="<?php echo $row['password'] ?>" class="form-control" placeholder="Enter Password">

              </div>

              <a href="register.php" class="btn btn-danger" > CANCEL  </a>

              <button type="submit" name="updatebtn" class="btn btn-primary"> Update </button>

          </form>

    <?php

    }

}

?>

  </div>

  </div>

</div>

</div>

<!-- /.container-fluid -->

Step 2: Create a page with the name code.php and paste the below code.

<?php

include('security.php');

if(isset($_POST['updatebtn']))

{

    $id = $_POST['edit_id'];

    $username = $_POST['edit_username'];

    $email = $_POST['edit_email'];

    $password = $_POST['edit_password'];

    $query = "UPDATE register SET username='$username', email='$email', password='$password' WHERE id='$id' ";

    $query_run = mysqli_query($connection, $query);

    if($query_run)

    {

        $_SESSION['status'] = "Your Data is Updated";

        $_SESSION['status_code'] = "success";

        header('Location: register.php'); 

    }

    else

    {

        $_SESSION['status'] = "Your Data is NOT Updated";

        $_SESSION['status_code'] = "error";

        header('Location: register.php'); 

    }

}

?>

Step 3: Create a folder called database and then create a file named dbconfig.php and paste the below code.

<?php

$server_name = "localhost";

$db_username = "root";

$db_password = "";

$db_name = "adminpanel";

$connection = mysqli_connect($server_name,$db_username,$db_password,$db_name);

if(!$connection)

{

    die("Connection failed: " . mysqli_connect_error());

    echo '

        <div class="container">

            <div class="row">

                <div class="col-md-8 mr-auto ml-auto text-center py-5 mt-5">

                    <div class="card">

                        <div class="card-body">

                            <h1 class="card-title bg-danger text-white"> Database Connection Failed </h1>

                            <h2 class="card-title"> Database Failure</h2>

                            <p class="card-text"> Please Check Your Database Connection.</p>

                            <a href="#" class="btn btn-primary">:( </a>

                        </div>

                    </div>

                </div>

            </div>

        </div>

    ';

}

?>

Step 4: Create a page security.php and paste the below code.

<?php

session_start();

include('database/dbconfig.php');

if($connection)

{

    // echo "Database Connected";

}

else

{

    header("Location: database/dbconfig.php");

}

?>