Posted in site documentation
1:24 am, June 11, 2021

load the latest single item only

this function loads the lastest item from the selected class

PHP

// load the latest single item only
    public function load_latest_single() {
        $out = "";
        $db_table_name = $this->db->escapeString($this->db_table_name);
        //$uid = $this->db->escapeString($uid);
        $sql = "select * from $db_table_name order by insdate desc limit 1";
        $result = $this->db->query($sql);
        while($row = $result->fetchArray()) {
            $this->status = "Item Loaded";
            // auto load all items from the $load_array
            foreach($this->load_array as $load_title) {
                $this->$load_title = $row[$load_title];
            }
            $this->loaded = true;
            return true;
        }
        return false;
    }

No Items Found.

Add Comment
Type in a Nick Name here
 
Page Views

This page has been viewed 278 times.

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.

❤👩‍💻🕹

Random Quote
"We're tight-fisted with property and money, yet think too little of wasting time, the one thing about which we should all be the toughest misers.”
Seneca