Update database on page onLoad

[theo]

Is it possible to update a MySQL database on page load instead of on the click of a button? I am trying to incorporate a hit counter to my dynamic pages and need to add a count everytime a visitor loads the page.

[tuf-web_co_uk]

just add

$sql = "UPDATE table set viewed=viewed+1 where page='".$page."'";
$query = mysql_query($sql);

to anywhere on your page, top bottom left middle right 😉

[theo]

Thank you for you reply.

I don't seem to be able to get it to update. I have entered the name of the table and changed 'viewed' to my column name and I already have a column 'page' for the url- as this correct?

[tuf-web_co_uk]

yes thats correct, have you made sure that before you run the script you connect 😉

if that doesnt work could i see your table structure
and the variable you use for your url

thanks

[theo]

What do you mean by the variable for the url - i haven't set a variable - that might be the problem - what do i need to do?

[tuf-web_co_uk]

well your database will have records in, or should otherwise what are you updating?!

one of the fields would contain which url is being viewed and updated.

the url could be the whole url (http://www.yourweb.com/page.php) or just page.php

either way you need a way of finding this out from your php script so you know which record needs updating

for the complete url its $SERVER[REQUEST_URI]
and for the page its $SERVER[PHP_SELF]

$page = $_SERVER[REQUEST_URI];
or
$page = $_SERVER[PHP_SELF];

$sql = "UPDATE table set viewed=viewed+1 where page='".$page."'"; 
$query = mysql_query($sql);

[theo]

Still no luck

the code I have is as follows

<?php
$page = $_SERVER[REQUEST_URI];
$sql = "UPDATE dogservicesListing set Counter=Counter+1 where page='".$page."'";
$query = mysql_query($sql);?>

I have 2 columns set up in my database one called Counter (which contains a number) and the other called page (which contains the url).

Does it work on dynamic pages? The page I need the counter for is detail.php which uses detail.php?ID=1, detail.php?ID=2 etc.

[tuf-web_co_uk]

ok seen as your using dynamic pages, it has to be within the script that loads the dynamic page

eg

if (isset($_GET[id])) {

$sql = "SELECT url from table where id='$_GET[id]'";
$query = mysql_query($sql);

$row = mysql_fetch_array($query);

include($row[url]);

$page = $row[url];
$sql = "UPDATE dogservicesListing set Counter=Counter+1 where page='".$page."'"; 
$query = mysql_query($sql);

} 

[theo]

It's working - excellent thanks

[theo]

My Mistake - it didn't work - I tried to update the counter using the ID field rather than the url field. I did work - however it uploads the counter to ALL records - not just the one I want to update. I know I need a WHERE clause after; "UPDATE dogservicesListing set Counter=Counter+1" I have tried everything but can't get it to work. Any ideas?

[theo]

Sorry forgot to add the code:

$colname_RS_counter = "1";
if (isset($HTTP_GET_VARS['ID'])) {
$colname_RS_counter = (get_magic_quotes_gpc()) ? $HTTP_GET_VARS['ID'] : addslashes($HTTP_GET_VARS['ID']);
}
mysql_select_db($database_georgeconnect, $georgeconnect);
$query_RS_counter = sprintf("SELECT ID, Counter, page FROM dogservicesListing WHERE ID = %s", $colname_RS_counter);
$RS_counter = mysql_query($query_RS_counter, $georgeconnect) or die(mysql_error());
$row_RS_counter = mysql_fetch_assoc($RS_counter);
$totalRows_RS_counter = mysql_num_rows($RS_counter);
$sql = "UPDATE dogservicesListing set Counter=Counter+1 ";

$query = mysql_query($sql);

[tuf-web_co_uk]

$sql = "UPDATE dogservicesListing set Counter=Counter+1 where id ='".$_GET[id]."'"; 

[theo]

Great thanks!!