How To Create Visitor Counter With Php and Mysql-Full Guide In Hindi

php visitor counter

Make a Simple Visitor Counter Using Php(In Hindi)

App Sbhi Ne  Website Me Dekha Hoga Ki Wanha Footer Section Me Total Number Of Visitor Means Kitne Visitor(Logo) Ne Hmare Website Ko Open Kiya Hai Ye Sare Detail Kisi Be Website Me Aap Dekh Sakte Ho
Ajj Me Apko Php And Mysql Ki Codding Karke Btaunga Ki Aap Kis Prakar Apne Website Me Total Number Of Visiter Ka Option Add Kar Sakte Ho Easily.

Create A Visitor Counter For Our Website Using PHP-
Aap Ek File Bana Lijiye-
Index.php 


<?php



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



   $year = date("Y");

  $month = date("m");

  $day = date("d");



  //for user id address

  $user_ip=$_SERVER['REMOTE_ADDR'];

//check ip of user

  $ip_checking = mysqli_query($con,"select userip from pageview where page='yourpage' and userip='$user_ip'");

  if(mysqli_num_rows($ip_checking)>=1)

  {

  }

  else

  {

    $insertindatabase = mysqli_query($con,"insert into pageview values('','yourpage','$user_ip','$year','$month','$day')");

  }

?>

<html>

<body>

<h1>VISITOR COUNTER DETAIL</h1>

Total Visitor In <?php echo date("Y"); ?>

[

<?php

$result = mysqli_query($con,"SELECT * FROM pageview where page='yourpage' and year='$year'");

$get_ip = mysqli_num_rows($result);

echo $get_ip;

?>]

<br>

Total Visitor In <?php echo date("M"); ?>



[<?php

$result=mysqli_query($con,"SELECT * FROM pageview where page='yourpage' and year='$year' and month='$month'");

$get_ip = mysqli_num_rows($result);

echo $get_ip;

?>]

</br>

Total Visitor Today- <?php echo date("D"); ?>[

<?php

$result = mysqli_query($con,"SELECT * FROM pageview where page='yourpage' and year='$year' and month='$month' and day='$day'");

$get_ip = mysqli_num_rows($result);

echo $get_ip;

?>]

<br>

Total Visitor of these website In All Time

[

<?php

$result = mysqli_query($con,"SELECT * FROM pageview where page='yourpage'");

$get_ip = mysqli_num_rows($result);

echo $get_ip;

?>]

</body>

</html>


·         Ab Aap Database Bana Lijiye  Sample2 Name Se
·         Yanha Apko Table Create Karne Hai Pagewiew Name Se Ya Simple Aap
·         Apne Browser Me Locahost/Phpmyadmin Section Open Karke  Query Me Niche Nig Ye Statement Ko Execute Karde Apke Wanha Automatically Database And Table Create Ho Jayege



-- phpMyAdmin SQL Dump

-- version 4.7.0

-- https://www.phpmyadmin.net/

--

-- Host: 127.0.0.1

-- Generation Time: Apr 28, 2018 at 01:21 PM

-- Server version: 10.1.26-MariaDB

-- PHP Version: 7.1.8



SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

SET AUTOCOMMIT = 0;

START TRANSACTION;

SET time_zone = "+00:00";





/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

/*!40101 SET NAMES utf8mb4 */;



--

-- Database: `sample2`

--



-- --------------------------------------------------------



--

-- Table structure for table `pageview`

--



CREATE TABLE `pageview` (

  `id` int(11) NOT NULL,

  `page` text NOT NULL,

  `userip` text NOT NULL,

  `year` int(11) NOT NULL,

  `month` int(11) NOT NULL,

  `day` int(11) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1;



--

-- Dumping data for table `pageview`

--



INSERT INTO `pageview` (`id`, `page`, `userip`, `year`, `month`, `day`) VALUES

(1, 'yourpage', '::1', 2017, 10, 5),

(2, 'yourpage', '127.0.0.1', 2017, 10, 31),

(3, 'yourpage', '', 2018, 4, 28);



--

-- Indexes for dumped tables

--



--

-- Indexes for table `pageview`

--

ALTER TABLE `pageview`

  ADD PRIMARY KEY (`id`);



--

-- AUTO_INCREMENT for dumped tables

--



--

-- AUTO_INCREMENT for table `pageview`

--

ALTER TABLE `pageview`

  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;COMMIT;



/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;



Is Parkar Aap Ise Apne Website Me Integrate Kar Sakte Hai Ab Jab Be Koi Visitor Apne Computer Ya Mobile Se Hmare Website Par Ayega To Uska Ip Address Ke Addar Par Hmare Website Me Wo Count Hoga .Is Visitor counter Ki Sabse Badi bat ye hai ki yeh Unique Visitor ko He Count karege means ye Ip Address par based hai ek Ip address ko sirf ek bar Count Karegea
Me Ummid Karta Hu Ki Apko Mere Ye Post Achi Lagi Hogi Agar Apka Koi Be Swal Ho To Aap Mujse Comment Section Me Puch Sakte Ho Me Apki Puri Sahayta Karunga
Thank You
Team Gajabwap Web In Hindi
Previous
Next Post »

2 comments

Click here for comments
sam thakur
admin
28 April 2018 at 05:02 ×

nice information. bro your all code are working I like it bro

Reply
avatar
Soniya
admin
28 April 2018 at 05:04 ×

nice article sir mere email ID par yeah code bhej dijiye soniyasharma123@gmail.com

Reply
avatar
Thanks for your comment