function to load one latest item with a start val load_latest_single_num [ site documentation ] - KruXoR

site documentation

function to load one latest item with a start val load_latest_single_num

Posted in site documentation

926

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;
    }

Posted in site documentation

926

4:06 am, September 2, 2021

View Statistics

This Week

195

This Month

935

This Year

3202

No Items Found.

Add Comment

Other Items in site documentation

function to load one latest item with a start val load_latest_single_num make the view number zoom when mouse over or active moving the hits widget into the post header and footer for auto filled fields, need to change the text and background colours use a list group for listing by category page [todo] Comments Listing should be a custom list rather than using search load the latest single item only load oldest item based on insdate then update the insdate to now - load_latest_single_update change this to a list group - other items hero widget header - creates a nice looking hero item from a target uid and class dropdown section Latest from Code Widget

Related Search Terms

site documentation fetchArray 1

site documentation good 1

site documentation the 3

site documentation select 1

site documentation actually 1

site documentation insdate 1

site documentation Kruxor 1

site documentation KruXoR 1

site documentation fetcharray 2

site documentation http 2

site documentation spec 3

site documentation all 1

site documentation table 1

site documentation documentation 1

site documentation return 3

site documentation limit 1

site documentation based 1

site documentation Sql 2

site documentation loadarray 1

site documentation date 1

site documentation sql 5

site documentation but 3

site documentation Function 11

site documentation name 2

site documentation order 2

site documentation test 11

site documentation latest 18

site documentation access 3

site documentation from 2

site documentation href 5

site documentation post 5

site documentation false 1

site documentation KruXoRcom 1

site documentation Start 17

site documentation ads 1

site documentation site documentation 5

site documentation this 5

site documentation like 1

site documentation dat 1

site documentation code 2

site documentation Order 3

site documentation document 1

site documentation Document 5

site documentation result 5

site documentation with 17

site documentation Latest 14

site documentation start 18

site documentation star 18

site documentation item 18

site documentation function 9

site documentation view 4

site documentation https 7

site documentation single 16

site documentation Single 15

site documentation kruxor 3

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