[RESOLVED] How do I count dynamic page hits?

Wales

Looking for a tutorial or some hints about coding this:

www.mypage.com/mypage.php?id=random id number here

When users view the above/similiar page how do I record a page view?
I want to insert that page view into the database.
Once it is in the database I want to be able to count that page number and display the results.

My problem is I can't think of anything that counts and inserts page views.

Please suggest ideas that are familiar to the above if there are any.

Thanks.

benracer

Can you use php on myspace?

Wales

benracer wrote:
Can you use php on myspace?

I think you read it wrong. No I think it's just css and html.

benracer

Sorry...

You would have the data in a table and use auto increment to get a unique id. Use a SELECT query and WHERE id='$_GET['id']' .
http://www.tizag.com/phpT/postget.php

planetsim

Id have a setup something like this

page | query | hits

You should make sure page and query are indexed as they will be used in the WHERE clause. I would also make these as two fields rather than just one because you may want to search based on page and see all the different queries.

Then code below

// you may want to use the database specific escape function
$page = addslashes( $_SERVER["PHP_SELF"] );
$query = addslashes( $_SERVER["QUERY_STRING"] );

$cond = array();
$cond[] = "page='$page'";
$cond[] = "query='$query'";
$cond = join( " AND ", $cond );

query( "SELECT page FROM mytblname WHERE $cond" );
if ( next_record() )
{
	query( "UPDATE mytblname SET hits = hits + 1 WHERE $cond" );
}
else
{
	query( "INSERT INTO mytblname VALUES( '$page', '$query', 1 )" );
}

Of course you can make this a function, no actually i recommend you do so. I hope this helps