使用php在mysql中创建一个ip访问计数器

Question

I am a very novice programmer and am just beginning to use php. I am using php to get the user ip store it in mysql. try inserting the ip to the mysql db. if it is already there then update the visit count. But none of my queries are working. It is returning that I am connected to my db This is what i have so far:

 $ipaddress = $_SERVER["REMOTE_ADDR"];
 print "$ipaddress <br>";

 $rv = mysqli_real_query("INSERT INTO visit ( ipaddress, count) VALUES (  '$ipaddress', 1)");
if ($rv === false){
 mysqli_real_query($con,"UPDATE visit SET count=count+1
 WHERE ipaddress = '$ipaddress'");
 mysqli_close($con);
 }
 mysqli_close($rv);
$count = mysqli_real_query("SELECT count from visit where ipaddress = '$ipaddress'");
print "You have visited this site $count time(s)";

Answer 1

1.) Where's your $con for your first query in $rv?

2.) Your queries need backticks for reserved words such as count:

$rv = mysqli_real_query($con, "INSERT INTO `visit`(`ipaddress`, `count`) VALUES('$ipaddress', 1)");

3.) Your inside if statement will only fire if there is an error in your first line. This means you'll never actually UPDATE the count, unless something went wrong.

Suggestion 1: - Open up your table in phpmyadmin and insert a row in manually with your IP address and some random count number. Then work on being able to display the line You have visited this site x time(s). Once that is working, then work on inserting/updating your table.

Suggestion 2: You should do it the other way around. That is, check to see if the ip address exists in the table. If it does - update it. If it doesn't exist, then add a new row.