checking values of database if its already viewed

[dvayne]

how to check if this url

http://www.domain.com/file.php?id=1 , http://www.domain.com/file.php?id=2...

is already visited once??

please help me.. thanks..

 

[stuffradio]

You could simply insert the value in to a table called view or something... the view table would contain the view_number.

 

$number = $_GET['p'];

if (!is_numeric($number)) {
echo "Not a valid number!";
exit;
}

$check = mysql_query("SELECT view_number FROM `table` WHERE `view_number`='$number'");
$query = mysql_num_rows($check);

if ($query > 0) {
echo "This page has already been viewed!";
}
?>

[dvayne]

You could simply insert the value in to a table called view or something... the view table would contain the view_number.

 

$number = $_GET['p'];

if (!is_numeric($number)) {
echo "Not a valid number!";
exit;
}

$check = mysql_query("SELECT view_number FROM `table` WHERE `view_number`='$number'");
$query = mysql_num_rows($check);

if ($query > 0) {
echo "This page has already been viewed!";
}
?>

thanks, please explain your code...

i'm newbie in php