Har en räknare som har räknat antalet klick på just den artikeln.
Använde mig tidigare av header location och sen vidare till den aktuella filen, nu så försöker jag lagra den aktuella filens innehåll i databasen istället men då slutade räknaren att fungera :(
Koden som jag använt till räknaren ser ut såhär
<?php
$dbname = 'xxxx';
$dbhost = 'localhost'; change this value
$dbusername = 'xxxx';
$dbpassword = 'xxxx';
$connection=mysql_connect($dbhost, $dbusername, $dbpassword) or die(mysql_error());
$dbase=mysql_select_db($dbname) or die(mysql_error());
$q="SELECT * from tutorial where tutorial_id='$id'";
$result= mysql_query($q, $connection) or die
("Could not execute query : $q." . mysql_error());
while ($row = mysql_fetch_array($result))
{
$id=$row["tutorial_id"];
$category=$row["gategory"];
$name=$row["name"];
$tut_id=$row["tut_id"];
$tuturl = $row["tuturl"];
$dsc = $row["description"];
$req = $row["req"];
$date = $row["date"];
$views = $row["views"];
header('Location:' .$tuturl);
$q="update tutorial set views=views+1 where tutorial_id='$id'";
$result2= mysql_query($q, $connection) or die
("Could not execute query 2 : $q." . mysql_error());
}
?>
Den använder jag som sagt var inte utan använder mig av den här numera som direkt visar innehållet istället, dit jag även försökt peta in koden som uppdaterar räknaren=views
<?php
session_start();
// database connection code here
// Check if there's a $tut_id variable passed in, output correct query
if(isset($tut_id))
{
$query = "SELECT * from tutorial where tut_id='$tut_id' ";
}
// execute query
$result= mysql_query($query) or die
("Could not execute query : $query." . mysql_error());
// PUT INCLUDE STATEMENT HERE
include('top.php');
$total_items = @mysql_num_rows($result);
echo "Antalet tutorials: $total_items";
echo "<p class=\"content\">";
$rows_per_page=3;
$total_records=mysql_num_rows($result);
$pages = ceil($total_records / $rows_per_page);
mysql_free_result($result);
if (!isset($screen))
$screen=0;
$start = $screen * $rows_per_page;
$query .="LIMIT $start, $rows_per_page";
$result= mysql_query($query) or die
("Could not execute query : $query." . mysql_error());
while ($row = mysql_fetch_array($result))
{
$id=$row["tutorial_id"];
$category=$row["gategory"];
$name=$row["name"];
$tut_id=$row["tut_id"];
$dsc = $row["description"];
$req = $row["req"];
$date = $row["date"];
$views = $row["views"];
$author = $row["author"];
// query category table for category name.
$catquery = "SELECT tut_name from tutlist where tut_id='$tut_id' ";
$result2= mysql_query($catquery) or die
("Could not execute query : $catquery." . mysql_error());
$cname = mysql_fetch_array($result2);
// start actual query
$q = "SELECT * from tutorial order by tut_id desc ";
$result3 = mysql_query($q) or die
("Could not execute q : $q." . mysql_error());
?>
INNEHÅLLET HÄR
<?php
// free memory
mysql_free_result($result);
?>
<? include('footer.php'); ?>