How to get
website visitor in PHP MySQL
In this
tutorial, I will show you how we can implement website visitors in our website. So
we can understand visitors is come from where.
What we will
learn in this tutorial:
1. How to get User Public IP
2. How to get website URL or Domain Name
3. How to Get Current Page he is
visiting
4. What browser he is visiting
5. Get Current Date and Time.
To Get
visitor its take only one step:
1.Make a PHP file to get visitor
details
Step 1. Make a PHP file to get visitor details
We make a PHP
file and save it with a name get_details.php
// Database Structure
CREATE TABLE `visitor_details` (
`ip` text NOT NULL,
`current_page` text NOT NULL,
`referrer` text NOT NULL,
`time` text NOT NULL,
`user_agent` text NOT NULL,
) ENGINE=MyISAM AUTO_INCREMENT=5
DEFAULT CHARSET=latin1
<html>
<body>
<div id="wrapper">
<div id="detail_div">
<?php
$ipaddress = $_SERVER['REMOTE_ADDR'];
$page = "http://".$_SERVER['HTTP_HOST']."".$_SERVER['PHP_SELF'];
$referrer = $_SERVER['HTTP_REFERER'];
$datetime = date("F j, Y, g:i a");
$useragent = $_SERVER['HTTP_USER_AGENT'];
echo "<p>IP Address : ".$ipaddress."</p>";
echo "<p>Current Page : ".$page."</p>";
echo "<p>Referrer : ".$referrer."</p>";
echo "<p>Current Time : ".$datetime."</p>";
echo "<p>Browser : ".$useragent."</p>";
$host="localhost";
$username="root";
$password="";
$databasename="sample";
$connect=mysql_connect($host,$username,$password);
$db=mysql_select_db($databasename);
mysql_query("insert into visitor_details values('','$ipaddress','$page','$referrer','$datetime','$useragent')");
?>
</div>
</div>
</body>
</html>
In this step we create a database table called 'visitor_details'
and add 5 columns to store 5 details of visitor all the functions we use are
already predefined by PHP and after getting all the details we store them in
our database.You may also like get
address, longitude and latitude using PHP.
That's all, this is how to get visitor details using PHP and
HTML.You can customize this code further as per your requirement. And please
feel free to give comments on this tutorial.
