Posted in site documentation
7
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: https://kruxor.com/list-category/code/ 

so for some reason this is listed using this function

PHP

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

PHP

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()) {
                $this->load_from_id($row_cat['id']);
                $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.

View Statistics
This Week
83
This Month
431
This Year
0

No Items Found.

Add Comment
Type in a Nick Name here
 
Related Search Terms
Search Code
Search Code by entering your search text above.
Welcome

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.

Join me on Substack if you want me to send you a collection of the things i have done or found or read for the week. Or follow me on twitter if you prefer, i dont post much but i probably should!

❤👩‍💻🕹

Random Quote
For a long time it had seemed to me that life was about to begin - real life. But there was always some obstacle in the way, something to be gotten through first, some unfinished business, time still to be served, or a debt to be paid. Then life would begin. At last it dawned on me that these obstacles were my life.
Alfred D. Souza