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");

}

?>