Website hits tracker code in PHP MySQL

This code of website hits tracker is developed in PHP and linked with MySQLi.

<?php 
$con = mysqli_connect("localhost", "root", "", "counter");
// retreive from database
$sql = "Select * from counter";

$result = mysqli_query($con, $sql);
$row = mysqli_fetch_assoc($result);

$id = $row['id'];
$count = $row['count'];

echo '<p>Count # ' . $count .' </p>';
$count = (int)$count;
$count++;
$sqlUp = "update counter set count = '$count'";
mysqli_query($con, $sqlUp);
?>

<?php

$con = mysqli_connect("localhost", "root", "", "counter");

// retreive from database

$sql = "Select * from counter";

$result = mysqli_query($con, $sql);

$row = mysqli_fetch_assoc($result);

$id = $row['id'];

$count = $row['count'];

echo '<p>Count # ' . $count .' </p>';

$count = (int)$count;

$count++;

$sqlUp = "update counter set count = '$count'";

mysqli_query($con, $sqlUp);

Database view in PHP Myadmin

Figure: PHP MyAdmin View of Website hits tracker code in PHP MySQLi

Code to redirect all visitors of website to another website without wordpress pulgin
Health Tracker for Diabetic Patients Project in PHP or ASP.NET
More views on my website for the success of website
inner join program code in PHP, MySQL
Time table code in PHP and MySQL
Difference between PHP mySql and mySqli code

Website hits tracker code in PHP MySQL
By: Prof. Dr. Fazal Rehman | Last updated: March 3, 2022

Website hits tracker code in PHP MySQL

Related Posts:

Leave a Comment