PHP - Mysql 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??

 

If anybody could give me code for that gets site views, that would be really nice.

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!    

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 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

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?

This topic has been moved to Application Frameworks.

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

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?

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.

Hi all,

I'm trying to create a PHP script for user's profile to display the amount of times they've been viewed. I'm looking to have this script increase on a unique view, and it should update the variable in the database.

Profiles are accessed by the following link: userprofile.php?userid=X (where X is the ID, e.g. 1, 2, 1001, 345982, etc.).

The database variable I'm looking to update is called ProfileViews.

I began developing the script, which is as follows:

Code: [Select]
$_SESSION['Viewed'] = 0;

if ($_SESSION['Viewed'] == 0) {

$profileViewsQuery = mysql_query("SELECT ProfileViews FROM Users WHERE UserID='????'");

$getProfileViews = mysql_fetch_array($profileViewsQuery);

$profileViews = $getProfileViews['ProfileViews'];

$profileViews = $profileViews + 1;

mysql_query("UPDATE Users SET ProfileViews='$profileViews' WHERE UserID='????'");

$_SESSION['Viewed'] = 1;

}

However, I'm stumped on a couple things. Could you possibly help me out?

1. How can I get the script to recognize the link accessed's ID? E.g. when a user goes to userprofile.php?userid=1001, how can I get the script to identify the ID to update should be 1001? This is where the "????" would be replaced in the code.
2. On page load, the variable is always going to be $_SESSION['Viewed'] = 0, which isn't going to produce unique hits. Do you have any recommendations how I could achieve unique hits using this method?

Thanks very much for reading.

I made this for my site and decided to share with the community.

Depending on how you do the code and where, this can keep count of the views in different ways.

Please read the somewhat directions have in the code, make a folder called counters, and be sure to include this below function file. I named the function file index.php and belongs in the counters folder you make.

<?php
/*
name this file index.php and place it into a folder called counters

the function will create a unique text file for each unique item, good for posts or pages and store all the files in the counters folder

For the total website views,add this to your header file or top of your page
<?php
include('counters/index.php');
$website_view_url = "http://".$_SERVER['HTTP_HOST'];
}
$website_views = getViews("$website_view_url");
echo "<br />".$website_views."<br />";
?>

For the total pages or scripts views,add this to your header file or top of your page
<?php
include('counters/index.php');
$total_page_view_url = "http://".$_SERVER['HTTP_HOST'].$_SERVER['SCRIPT_NAME'];
}
$total_page_views = getViews("$total_page_view_url");
echo "<br />".$total_page_views."<br />";
?>

For entire urls including queries,add this to your header file or top of your page
<?php
include('counters/index.php');
$page_queries_view_url = "http://".$_SERVER['HTTP_HOST'].$_SERVER['SCRIPT_NAME'];
if (!empty($_SERVER["QUERY_STRING"])) {
$page_queries_view_url .= "?".$_SERVER['QUERY_STRING'];
}
$page_queries_views = getViews("$page_queries_view_url");
echo "<br />".$page_views."<br />";
?>

for usage in posts like by id:
if do not want the pages counted and did not do the above code,include the below somewhere near the beginning of your page

<?php include('counters/index.php');?>

Then in the posts loop, you can associate your $row['id']; or some other unique value

<?php
$post_views = $row['id'];
$post_views = getViews("$post_views");
echo "<br />Post Views ".$post_views."<br />";
?>

if would like to combine any the above or use them all, just be sure to just include include('counters/index.php'); only one time
*/


function getViews($views_count_value)
{
    $views_count_value = md5("$views_count_value");
    $views_count_file_name = "counters/$views_count_value.txt";
if (!file_exists($views_count_file_name)) {
    $views_count =0;
    $file_handle = fopen($views_count_file_name, 'w') or die("can't open file");
    fwrite($file_handle, "$views_count");
    fclose($file_handle);

}

    $file_handle = fopen($views_count_file_name, "r");
    $views_count = fread($file_handle, filesize("$views_count_file_name"));
    fclose($file_handle);
    if ($views_count <= 0){
    $views_count =1;
    } else {
    ++$views_count;
    }
    $file_handle = fopen($views_count_file_name, "w+");
    fwrite($file_handle, "$views_count");
    fclose($file_handle);
    return("$views_count");

}
?>