PHP/MySQL Counter

La_Parka

I have searched all over the net for a free counter script, but no avail.

My pages are derived from a DB so that in index.php?id=x, for every x value, a new page is called from the database...

e.g.
index.php?id=1
index.php?id=2
index.php?id=3

derive from the DB from a table with 'id' as the primary key field.

I am looking for a script that will count each time an id=x page is viewed, and then in turn, be able to display the "Ten Most-Viewed Pages" among those.

NoFear

Do you want to use MySQL to keep track of this?

La_Parka

Originally posted by NoFear
Do you want to use MySQL to keep track of this?

I guess, if that's the best option.

Edit-Should I just create a field called 'pageviews' in the table, and have the page insert an 'i++' into the DB, or would it be more complicated than that?

-JJ

here.
Use this. I made it yesterday.

This will keep track of peoples IP's and tell you how many people have visited your site.
(also, in the database, you can change the IP feild to UNIQUE so they can only submit once.)

<table border="1" bordercolor="#000000" width="20" height="15" cellpadding="0" cellspacing="0" background="stat.gif">
<tr>
<td bordercolor="#FFFFFF"><center>
<?php
$ipaddy = getenv("REMOTE_ADDR");
?>
<?php
$connection = mysql_pconnect("localhost", "root", "XXXXXXX")
or die ("Couldn't connect to server.");

$db = mysql_select_db("info", $connection)
or die ("Couldn't select database.");

$sql = "INSERT INTO hits (theip)
VALUES ('$ipaddy')";

$sql_result = mysql_query($sql,$connection);
?>

<?php
//Script made by Jared Whittington

$db = mysql_connect("localhost", "root", "XXXXXX");
mysql_select_db("info",$db);
$sql="SELECT count(theip) FROM hits";
$result=mysql_query($sql,$db);

while ($row = mysql_fetch_array($result))
{
$id = $row["0"];
echo "<font face=\"verdana\" size=\"1\">b>$id</b></font>";}
?>
</center></td>
</tr>
</table>
</td>
</tr>
</table>

Weedpacket

Originally posted by La Parka

I guess, if that's the best option.

Edit-Should I just create a field called 'pageviews' in the table, and have the page insert an 'i++' into the DB, or would it be more complicated than that?

Nah, it's probably that simple.

"UPDATE pagecounts SET pageviews=pageviews+1 WHERE id=$id"

It doesn't keep track of anything else, of course - that's another matter.