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