Posted in site documentation
12:02 am, June 17, 2021

use a list group for listing by category page [todo]

change this to a list group, should make it neater.

Page to update: 

so for some reason this is listed using this function


$list_wiki_menu = $class->list_wiki_menu();

not sure why i called it that, anyway...

here is the full function, it selects all the distinct categories and then lists all the items under each one. 


public function list_wiki_menu($mode = "widget", $start = 0, $max = 1000) {
    $out = "";
    $db_table_name = $this->db->escapeString($this->db_table_name);
    $start = $this->db->escapeString($start);
    $max = $this->db->escapeString($max);
    $db_table_name = $this->db->escapeString($this->db_table_name);
    $sql = "select distinct category from $db_table_name";
    $result =  $this->db->query($sql);
    if($result) {
        while($row = $result->fetchArray()) {
            $category = $row['category'];
            $sql_cat = "select * from $db_table_name where category = '$category' order by title asc limit $start,$max";
            $result_cat = $this->db->query($sql_cat);
            if($mode == "home") {
                $out .= "<div class='col-lg-12'>";
            $out .= "<ul>$category";
            while($row_cat = $result_cat->fetchArray()) {
                $nice_link = $this->generate_view_link();
                $title = $row_cat['title'];
                $out .= "<li><a href='$nice_link'>$title</a></li>";
            $out .= "</ul>";
            if($mode == "home") {
                $out .= "</div>";
    if($mode == "widget") {
        /*$out = "<h2><i class=\"far fa-file-alt\"></i> $this->nice_name</h2>$out";*/
    if($mode == "home") {
        $out = "<div class='row'>$out</div>";
    return $out;

Maybe a card style for each category with the list group inside it, something like this? i think this looks a bit neater.

No Items Found.

Add Comment
Type in a Nick Name here
Page Views

This page has been viewed 364 times.

Search Code
Search Code by entering your search text above.

This is my test area for webdev. I keep a collection of code snippits here, mostly for my reference. Also if i find a good site, i usually add it here.


Random Quote
Be Yourself, Back Yourself
Kristie Bennett, Survivor