I have a Small problem I want to create a page counter to know how many people are visiting each page in my site. And I want to do this using php.
I added a column in my DB called Counter
I need to add one on a page event Load.
But this dose not always happened just when they see a specific section.
This is what I have
The Upload function that need to be called
Code: Select all
<?php
$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}
if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form1")) {
$updateSQL = sprintf("UPDATE CONTENT SET Counter=%s WHERE contentID=%s",
GetSQLValueString($_POST['Counter'], "int"),
GetSQLValueString($_POST['contentID'], "int"));
mysql_select_db($database_DinamicPortfolio, $DinamicPortfolio);
$Result1 = mysql_query($updateSQL, $DinamicPortfolio) or die(mysql_error());
}
?>Code: Select all
<body onload="e;<?php echo $editFormAction; ?>"e;>Code: Select all
<form name="e;form1"e; id="e;form1"e; method="e;POST"e;>
<p>XX This is invisible Page Counter <input name="e;Counter"e; type="e;hidden"e; id="e;Counter"e; value="e;<?php echo ++ $row_ShowContentї'Counter']; ?>"e; />
<input name="e;contentID"e; type="e;hidden"e; id="e;contentID"e; value="e;<?php echo $row_ShowContentї'contentID']; ?>"e; size="e;3"e; /> XX
<input type="e;hidden"e; name="e;MM_update"e; value="e;form1"e;>
</form>