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

6270

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

6270

4:06 am, September 2, 2021

View Statistics

This Week

170

This Month

950

This Year

1923

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 documentation 2

site documentation http 24

site documentation fetchArray 45

site documentation fetcharray 49

site documentation https 78

site documentation kruxorcom 30

site documentation with 87

site documentation order 95

site documentation post 100

site documentation loadarray 43

site documentation start 96

site documentation based 106

site documentation latest 121

site documentation test 104

site documentation sql 153

site documentation date 108

site documentation the 101

site documentation single 100

site documentation spec 122

site documentation like 114

site documentation Access 112

site documentation site documentation 141

site documentation Document 110

site documentation Single 112

site documentation good 96

site documentation Latest 116

site documentation name 94

site documentation Order 109

site documentation kruxor 91

site documentation insdate 111

site documentation view 118

site documentation from 120

site documentation result 105

site documentation code 105

site documentation href 106

site documentation item 109

site documentation array 100

site documentation Start 86

site documentation actually 87

site documentation document 106

site documentation false 105

site documentation select 96

site documentation KruXoRcom 64

site documentation return 111

site documentation Function 103

site documentation star 97

site documentation this 103

site documentation function 92

site documentation limit 132

site documentation access 113

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