环境：centos6.9；mysql5.1；php7.2

1.创建一个存储数据的表

create table wp_jc_count(id int not null auto_increment primary key,ip varchar(20) not null,times int default 0);

2.创建一个php脚本

<?php
class visitorInfo
{//获取访客ippublic function getIp(){$ip=false;if(!empty($_SERVER["HTTP_CLIENT_IP"])){$ip = $_SERVER["HTTP_CLIENT_IP"];}if (!empty($_SERVER['HTTP_X_FORWARDED_FOR'])) {$ips = explode (", ", $_SERVER['HTTP_X_FORWARDED_FOR']);if ($ip) { array_unshift($ips, $ip); $ip = FALSE; }for ($i = 0; $i < count($ips); $i++) {if (!eregi ("^(10│172.16│192.168).", $ips[$i])) {$ip = $ips[$i];break;}}}return ($ip ? $ip : $_SERVER['REMOTE_ADDR']);}//获取网站来源public function getFromPage(){return $_SERVER['HTTP_REFERER'];}
}$visitor =new visitorInfo();//连接数据库$conn=mysqli_connect("localhost","user_naem","password","db_name");if($conn){//echo "成功"."<br>";//echo $_SERVER['REMOTE_ADDR']."<br>";}else{echo "失败\n";die(mysqli_connect_error());}//设置数据库编码方式mysqli_set_charset($conn,"utf8") or die(mysqli_connect_error());//记录访客的ip地址$address=$visitor->getIp();//查询当前访客来访的次数的sql语句$sql="select times from wp_jc_count where ip='$address'";//查询结果存到$result变量$result=mysqli_query($conn,$sql) or die(mysqli_connect_error());if(!$row=$result->fetch_row()){$sql="insert into wp_jc_count(ip, times) values('$address','1')";}else{$times=$row['0']+1;$sql="update wp_jc_count set times='$times' where ip ='$address'";}$result=mysqli_query($conn,$sql) or die(mysqli_connect_error());//获取总的访问人数即数据表中所有ip的数量$sql="select count(ip) from wp_jc_count";$result=mysqli_query($conn,$sql) or die(mysqli_connect_error());if($row=$result->fetch_row()){$num=$row[0];}echo "您是第".$num."位访客";mysqli_close($conn);
?>

3.将上述代码贴到footer.php中要输出信息的位置即可

当前功能较少，后续会增加一些功能；

---

参考资料：https://www.cnblogs.com/jianqingwang/p/7017495.html
参考资料：https://www.jianshu.com/p/343ed80b4dca
参考资料：(https://blog.csdn.net/ld0807/article/details/54178652](https://blog.csdn.net/ld0807/article/details/54178652)
原文:http://blog.isdevil.com/cjerrybird/2019/02/phpmysql%e5%ae%9e%e7%8e%b0%e7%bb%9f%e8%ae%a1%e7%bd%91%e7%ab%99%e8%ae%bf%e9%97%ae%e9%87%8f%e4%b8%80.html