Part 4-Admin Panel(Registration): Retrieve/Edit data from Database into Textbox 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>
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");
}
?>
Thanks for reading...