Part 7-Admin Panel(Registration): Total Number of Data (Row Count) in Database in php
As per the video, we have already downloaded the files and linked the CSS and JS.
Step 1: Create a index.php page and paste the below:
<?php
include('security.php');
?>
<div class="col-xl-3 col-md-6 mb-4">
<div class="card border-left-primary shadow h-100 py-2">
<div class="card-body">
<div class="row no-gutters align-items-center">
<div class="col mr-2">
<div class="text-xs font-weight-bold text-primary text-uppercase mb-1">Total Registered Admin</div>
<div class="h5 mb-0 font-weight-bold text-gray-800">
<?php
$query = "SELECT id FROM register ORDER BY id";
$query_run = mysqli_query($connection, $query);
$row = mysqli_num_rows($query_run);
echo '<h4> Total Admin: '.$row.'</h4>';
?>
</div>
</div>
<div class="col-auto">
<i class="fas fa-calendar fa-2x text-gray-300"></i>
</div>
</div>
</div>
</div>
</div>
Step 2: 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 3: 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");
}
?>