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
40
This Month
292
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
The problem with hoarding is you end up living off your reserves. Eventually, you’ll become stale. If you give away everything you have, you are left with nothing. This forces you to look, to be aware, to replenish. . . . Somehow the more you give away, the more comes back to you.
Paul Arden