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

6

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

6

4:06 am, September 2, 2021

View Statistics

This Week

67

This Month

375

This Year

0

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 order 9

site documentation post 12

site documentation loadarray 8

site documentation start 14

site documentation based 14

site documentation latest 13

site documentation test 15

site documentation sql 26

site documentation date 20

site documentation the 14

site documentation single 19

site documentation spec 22

site documentation like 24

site documentation Access 14

site documentation site documentation 19

site documentation Document 21

site documentation Single 19

site documentation good 18

site documentation Latest 18

site documentation name 17

site documentation Order 21

site documentation kruxor 14

site documentation insdate 24

site documentation view 16

site documentation from 20

site documentation result 23

site documentation code 19

site documentation href 21

site documentation item 21

site documentation array 20

site documentation Start 16

site documentation actually 14

site documentation document 25

site documentation false 18

site documentation select 19

site documentation KruXoRcom 4

site documentation return 16

site documentation Function 21

site documentation star 17

site documentation this 18

site documentation function 15

site documentation limit 30

site documentation access 21

Code Articles Forster Links Tools