Jump to content

My Most Viewed Posts script - what do you think?


V

Recommended Posts

I made my first script today for showing most viewed posts by unique IP addresses. I'm pretty proud of this one :) It seems to work fine, I'm just anticipating your thoughts and approval  :shy:

 

How it works: I have a unique_views table that records all IP addresses visiting a post and the post id. Then in the "posts" table I have a "views" field that shows the number of unique IP addresses that visited the post.

 

 

The script that inserts IPs into the unique_views table

 

require_once("functions.php");

$connection = dbConnect(); //connects to the DB

$_SERVER['REMOTE_ADDR']; //retrieves visitor's IP 

$ip = $_SERVER['REMOTE_ADDR'];

$post=$_GET['post']; //gets the post id

$sql = "SELECT * FROM unique_views WHERE ip = '$ip' AND post_id = '$post'";

$result = $connection->query($sql) or die(mysqli_error($connection));

if (mysqli_num_rows($result) == 0)
{

$sql = "INSERT INTO unique_views
                 (ip, post_id)
          VALUES ('$ip', '$post')";
	  		  
	    $result = $connection->query($sql) or die(mysqli_error($connection));	


$sql = "UPDATE posts set views=views+1 where post_id='$post'"; //adds +1 to the views field in posts table whenever a unique visitor visits the post

	$result = $connection->query($sql) or die(mysqli_error($connection));	

}

else { //show the total number of unique visitors
$unique = mysqli_num_rows($result);
echo "Unique views: $unique <br /><br />";
}

 

 

and this script displays the most viewed posts

 

 

require_once("functions.php");

$connection = dbConnect();

$sql = "SELECT post_title, views FROM posts WHERE views>1 ORDER BY views DESC";

$result = $connection->query($sql) or die(mysqli_error($connection));

while ($row = $result->fetch_assoc()) {	

		$post_title=$row['post_title'];
		echo $post_title;
		echo "<br />";

	}

 

Link to comment
Share on other sites

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.