Posted in site documentation
459
4:06 am, September 2, 2021
 

function to load one latest item with a start val load_latest_single_num

This is the same as load oldest item based on insdate then update the insdate to now - load_latest_single_update but it allows you to add a start number to the range, so allows you to access the 2nd, 3rd, etc... newest items. 

Actually this loads the newest item with a number range. not the oldest like the linked post. 

Good for loading feature items ordered by the insdate. 

PHP

/*
the same as load_latest_single but you can specify the range it will load.
for example, if you want to load the 2nd lates single item from the class
then add -- load_latest_single_num(1) and it will start at 1, rather than 0.
*/

    /*public*/ function load_latest_single_num($start_num) {
        $out = "";
        $db_table_name = $this->db->escapeString($this->db_table_name);
        $start_num = $this->db->escapeString($start_num);
        $sql = "select * from $db_table_name order by insdate desc limit $start_num,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;
    }

View Statistics
This Week
210
This Month
716
This Year
2735

No Items Found.

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

This is my test area for webdev. I keep a collection of code here, mostly for my reference. Also if i find a good link, i usually add it here and then forget about it. more...

You could also follow me on twitter. I have a couple of youtube channels if you want to see some video related content. RuneScape 3, Minecraft and also a coding channel here Web Dev.

If you found something useful or like my work, you can buy me a coffee here. Mmm Coffee. ☕

❤️👩‍💻🎮

🪦 2000 - 16 Oct 2022 - Boots
Random Quote
When I realized that, no individual step is hard in any process. Building this airport I'm standing in right now started with a guy writing the architectural plans on paper. That's not hard for him to do. Then laying the first beam isn't had. The whole thing is really hard. So, just take each step kind of piece by piece and when I was able to do that and stop trying to chase this prize and started putting in the work, things just started coming together.
Unknown
Random CSS Property

:disabled

The :disabled CSS pseudo-class represents any disabled element. An element is disabled if it can't be activated (selected, clicked on, typed into, etc.) or accept focus. The element also has an enabled state, in which it can be activated or accept focus.
:disabled css reference