Jump to content

Adding a number every visit


teknospr

Recommended Posts

Good day:

 

Im trying to add a number every time a person visits the page. here is the code Im using. Any help will be appreciated.

 

<?php
$aid = $_GET['aid'];
  $connection = mysql_connect("localhost",
        "username",
        "password");

    mysql_select_db("articles", $connection); 
$query="SELECT visits FROM articles_description WHERE id=$aid";
$result=mysql_query($query);

$num=mysql_numrows($result);

<?php

while ($j < $num) {
$visits = $num[0] + 1;
}
$query = "UPDATE articles_description SET visits = $visits WHERE id = $aid";
if(mysql_query($sql_query)) {
echo "Record updated successfully";
$j++;
}
mysql_close();
?>

Link to comment
https://forums.phpfreaks.com/topic/229823-adding-a-number-every-visit/
Share on other sites

SET visits = $visits+1

 

You wouldn't use a variable $visits - just the field name

 

$connection = mysql_connect("localhost", "username", "password");
mysql_select_db("articles", $connection); 

$aid = mysql_real_esacpe_string($_GET['aid']);
$query = "UPDATE articles_description SET visits = visits + 1 WHERE id = $aid";
$result = mysql_query($query) or die(mysql_error());
echo "Record updated successfully";
mysql_close();

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.