Posted in php
9439
8:54 am, October 7, 2021
 

views list function for checking what views have been made on the current week

this is related to the views class that i added with monthly week number and yearly views, this is the function that i use to extract the top viewed pages for the week num, month num and year num.

I have found that recently i prefer to pass an array into the functions rather than function variables, im not sure if this is a good idea or not, but it seems to make my functions a lot neater. 

the example below shows the views page running the function from the views class extend. so its seperated into two parts. the formatting is just basic at the moment, i may add a template to the items later. 

One issue is that before each function you need to list the fields_array items otherwise you tend to forget what to pass into the function later on. But it is much neater to do it this way i find, and you can set each item or just leave them out. 

PHP

// on the views page
$views->fields_array = array(); // reset the array each time.
$views->fields_array["order_num"] = date('W');
$views->fields_array["order_type"] = "week_num"; // or... year_num, month_num or week_num
$views->fields_array["max"] = 10; // max items to show.
$views_week_top = $views->views_list();

$page_content .= $views_week_top;

// function within the views extend class
/*
  shows a list of views ordered by the fields array order_by value. for listing top hits per month, week or year.
  $this->fields_array = array(); // reset the array each time.
  $this->fields_array["order_num"] = date('y');
  $this->fields_array["order_type"] = "year_num"; // or... month_num or week_num
  $this->fields_array["max"] = 10; // max items to show.
  */
  public function views_list() {
    global $functions;
    $out = "";
    $db_table_name = $this->db->escapeString($this->db_table_name);
    $order_type = $this->db->escapeString($this->fields_array["order_type"]);
    $order_num = $this->db->escapeString($this->fields_array["order_num"]);
    $max = $this->db->escapeString($this->fields_array["max"]);
    echo $sql = "select * from $db_table_name where
      $order_type = '$order_num'
      order by views desc limit $max
      ";
    $result = $this->db->query($sql);
    $views_total = 0;
    while($row = $result->fetchArray()) {
      foreach($this->load_array as $load_title) {
          //$template->set($load_title, $row[$load_title]);
          // also set the items.. so they can be re-used, if for a single loaded item. this will not work for multiple
          $this->$load_title = $row[$load_title];
          // i think this breaks stuff... it seems to replace things on the view page, so not a good idea
      }
      // now all values should be set so can add the output
      $title_safe = htmlentities($this->title);
      $out .= "<div class='views-list-item'>
        <a href='/view/$this->linked_class/$this->linked_uid/'>$title_safe</a> $this->views
      </div>";
    }
    return $out;
  }

View Statistics
This Week
374
This Month
1521
This Year
2911

No Items Found.

Add Comment
Type in a Nick Name here
 
Other Items in php
php redirect echo the page id from wordpress sqlite escape string Deprecated: parse_str(): Calling parse_str() without the result argument is deprecated getcwd usage in php to get the current working directory for file includes write to file php save string to file php using preg_match to extract text from elements encode spaces in items passed to url to %20 not + php function load as table - load_as_table turn on or off error reporting php get json with php from a url and display it php convert number with k on the end to full number extract variables from url string php No 'Access-Control-Allow-Origin' header is present on the requested resource. Fatal error: Uncaught Exception: Required extension GD is not loaded. php check if a class exists Uncaught Error: Call to undefined function mb_convert_encoding() get the subdomain name from the domain string in php - sub domain fixing error Call to undefined function simplexml_load_string get the content of a url get the content of a link with php and test if the result is empty php check if url is valid with filter_var php save csv from array to file php export csv from string to browser download convert json string to a php array how to json encode an array in php how to decode xml in php php get file and save it php function to remove the query string from a url using php parse_url function to remove the query string from a url add every value in the load_array array into the out for testing Fix for PHP Warning Trying to get property '*name*' of non-object write the contents of a url into a file with php sqlite fetchArray into another array php return json header and content list_all_array an early stages of list all function that uses an array to pass in main variables replace singular variable assignment with an array loop and variable variables using the $_SERVER['HTTP_REFERER'] to check referring pages timeline class and function php html template class system views list function for checking what views have been made on the current week load array load all items from an array while in a sqlite load sql loop create a 200 character summary from a longer html string using strlen to check the length of a string and do something about it How to record your own page views with PHP, and make them into weekly monthly and yearly charts load from fields array php class function get the current week as a number with php creating embedded php code from a database field test php bundle write check if a file exists with php
Search Code
Search Code by entering your search text above.
Welcome

This is my test area for webdev. I keep a collection of code here, mostly for my reference. Also if i find a good link, i usually add it here and then forget about it. more...

Subscribe to weekly updates about things i have added to the site or thought interesting during the last week.

You could also follow me on twitter or not... does anyone even use twitter anymore?

If you found something useful or like my work, you can buy me a coffee here. Mmm Coffee. ☕

❤️👩‍💻🎮

🪦 2000 - 16 Oct 2022 - Boots
Random Quote

'Dawnie' used to say, "It's really quite simple: Be kind, and the rest takes care of itself. Never do anything that's not kind".


Dawn Atherton
Random CSS Property

vertical-align

The vertical-align CSS property sets vertical alignment of an inline, inline-block or table-cell box.
vertical-align css reference