Posted in site documentation
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. 


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

            return true;
        return false;

No Items Found.

Add Comment
Type in a Nick Name here
Page Views

This page has been viewed 10 times.

Search Code
Search Code by entering your search text above.

This is my test area for webdev. I keep a collection of code snippits here, mostly for my reference. Also if i find a good site, i usually add it here.


Random Quote
1. Show your work to the world instead of keeping in your head๐Ÿ’†. 2. Do the work consistently๐Ÿ‘Œ 3. Respect your work๐Ÿฅฐ 4. Don't postpone your work 5. Make mistakes ๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿ”ฅ