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

1062

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

1062

1:19 am, June 11, 2021

View Statistics

This Week

232

This Month

981

This Year

2817

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

site documentation for loop 2

site documentation return 5

site documentation all 2

site documentation here 5

site documentation fetcharray 1

site documentation function 3

site documentation finding 2

site documentation abs 1

site documentation from 2

site documentation forgot 2

site documentation Function 5

site documentation documentation 1

site documentation remember 1

site documentation site documentation 6

site documentation string 2

site documentation fetchArray 2

site documentation table 1

site documentation For Loop 18

site documentation Sql 1

site documentation name 4

site documentation think 2

site documentation list 2

site documentation array 3

site documentation ending 2

site documentation false 2

site documentation good 1

site documentation about 2

site documentation order 6

site documentation select 6

site documentation this 6

site documentation limit 3

site documentation based 14

site documentation sql 14

site documentation latest 19

site documentation loop 3

site documentation document 3

site documentation Document 9

site documentation that 10

site documentation insdate 16

site documentation Latest 21

site documentation test 20

site documentation single 11

site documentation Single 13

site documentation item 22

site documentation date 15

site documentation the 21

site documentation dat 14

site documentation Order 3

site documentation result 3

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