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

292

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

292

1:19 am, June 11, 2021

View Statistics

This Week

93

This Month

503

This Year

2046

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 abs 1

site documentation from 1

site documentation forgot 2

site documentation Function 2

site documentation documentation 1

site documentation remember 1

site documentation site documentation 2

site documentation string 1

site documentation fetchArray 1

site documentation table 1

site documentation For Loop 6

site documentation Sql 1

site documentation name 2

site documentation think 1

site documentation list 1

site documentation array 3

site documentation ending 2

site documentation false 2

site documentation good 1

site documentation about 2

site documentation order 2

site documentation select 4

site documentation this 2

site documentation limit 3

site documentation based 6

site documentation sql 6

site documentation latest 4

site documentation loop 3

site documentation document 2

site documentation Document 2

site documentation that 4

site documentation insdate 5

site documentation Latest 5

site documentation test 4

site documentation single 3

site documentation Single 3

site documentation item 7

site documentation date 9

site documentation the 7

site documentation dat 4

site documentation Order 1

site documentation result 2

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