load oldest item based on insdate then update the insdate to now - load_latest_single_update [ site documentation ] - KruXoR

site documentation

load oldest item based on insdate then update the insdate to now - load_latest_single_update

Posted in site documentation

5

1:19 am, June 11, 2021

load oldest item based on insdate then update the insdate to now - load_latest_single_update

i keep finding these functions that i wrote ages ago and forgot about so ill list them here so maybe i can remember them.

I think this one was to loop through items, so it grabs the oldest item and then updates the insdate to now, so might be good for cycling through items depending on their insdate.

PHP

// Load and Update Insdate or Processed Date
    // load oldest item based on insdate then update the insdate to now.
    public function load_latest_single_update() {
        $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 asc 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;

            // set new insdate for loop
            $new_insdate = date("Y-m-d H:i:s");
            $this->insdate = $new_insdate;
            $this->update();

            return true;
        }
        return false;
    }

Posted in site documentation

5

1:19 am, June 11, 2021

View Statistics

This Week

12

This Month

52

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

site documentation order 8

site documentation loadarray 6

site documentation the 9

site documentation finding 16

site documentation limit 24

site documentation good 27

site documentation date 22

site documentation Latest 19

site documentation single 23

site documentation test 30

site documentation list 29

site documentation function 25

site documentation Single 25

site documentation this 27

site documentation think 30

site documentation that 24

site documentation site documentation 26

site documentation select 23

site documentation return 27

site documentation result 25

site documentation name 24

site documentation latest 20

site documentation item 27

site documentation insdate 30

site documentation array 30

site documentation abs 28

site documentation Order 25

site documentation Document 32

site documentation remember 24

site documentation sql 43

site documentation from 29

site documentation loop 23

site documentation Function 26

site documentation based 23

site documentation document 33

site documentation here 32

site documentation false 33

site documentation ending 31

Code Articles Forster Links Tools