[Resolved] writing to MySQL

rayzun

How to record the number of page loads per page..

Does anyone have a code snippet for this idea??

Basically I use a single PHP template for my whole site. Each page is numbered
1 through to 7628

example:
domain.com/templates/1.php/1/good
domain.com/templates/7628.php/7628/good

Using MySQL I believe would be best and fastest approach.

and Explode to grab the URL information:

example:
domain.com/templates/7628.php/7628/good

list($first, $last) = explode('/', substr($PATH_INFO,1));

$first = 7628
$last = good

bradgrafelman

Here's an example:

if($address = strstr($_SERVER['REQUEST_URI'], '.php')) { 

list($first, $last) = explode('/', substr(strstr($_SERVER['REQUEST_URI'], '.php/'), 5));

$query = "UPDATE hits SET total = (total+1) WHERE pageID = '".$first."'";
$exec = mysql_query($query) or die('MySQL Query error: ' . mysql_error());

} else {

// The URL was not in the format of 'something.php/something/something'

}

You should customize it to your liking, and the SQL query was written in a rush (hoping to catch some Z's soon), so you should validate/make '$first' safe (i.e. addslashes() or mysql_real_escape_string(), etc.).

That code should give you a good start, though.

rayzun

Please help how to re-write my code?
Ive added 2 fields to the table:
hits and total
do these need any thing other than type - varchar(255)?

include("/home/db.inc.php");

if($address = strstr($_SERVER['REQUEST_URI'], '.php')) {

list($first, $last) = explode('/', substr(strstr($_SERVER['REQUEST_URI'], '.php/'), 5)); 

$query = "UPDATE hits SET total = (total+1) WHERE line = '".$first."'"; 
$exec = mysql_query($query) or die('MySQL Query error: ' . mysql_error());

} else {

// The URL was not in the format of 'something.php/something/something'

}

mysql_close();

bradgrafelman

A few things:

'hits' is not a field.. 'hits' is the name of a table.
'total' should be an integer type, i.e. SMALLINT, MEDIUMINT, INT, etc.
instead of 'hits' you need to add a column called 'line' (and yes, VARCHAR will be fine for that field).