load array load all items from an array while in a sqlite load sql loop [ php ] - KruXoR

php

load array load all items from an array while in a sqlite load sql loop

Posted in php

2

8:36 am, October 7, 2021

load array load all items from an array while in a sqlite load sql loop

i find this useful when loading a bunch of items in a class while looping through data, rather than assigning variables manually i just add the array of item names into the class to begin with and then you can call the array in the load loop and use that to load each item.

PHP

// this code will only work in a class format, i have just added the seperate bits here for reference. 
// so the load_array is set in the class. and then the sql query is within a function of that class.

public $load_array = [
    "id",
    "uid",
    "insdate",
    "title",
    "additional",
    "category",
    ];

$sql = "select * from table_name limit 10";

$result = $this->db->query($sql);

while($row = $result->fetchArray()) {

            $template = new template($template_file);

            // load each item in the load array into the template
            // in this loop also add auto formatting for items, to show optional on view pages.

            foreach($this->load_array as $load_title) {
                $template->set($load_title, $row[$load_title]);
                // also set the items.. so they can be re-used, if for a single loaded item. this will not work for multiple
                // $this->$load_title = $row[$load_title];
                // i think this breaks stuff... it seems to replace things on the view page, so not a good idea
            }
}

Posted in php

2

8:36 am, October 7, 2021

View Statistics

This Week

81

This Month

407

This Year

0

No Items Found.

Add Comment

Other Items in php

fixing error Call to undefined function simplexml_load_string get the content of a url get the content of a link with php and test if the result is empty php check if url is valid with filter_var php save csv from array to file php export csv from string to browser download convert json string to a php array how to json encode an array in php how to decode xml in php php get file and save it php function to remove the query string from a url using php parse_url function to remove the query string from a url add every value in the load_array array into the out for testing Fix for PHP Warning Trying to get property '*name*' of non-object write the contents of a url into a file with php sqlite fetchArray into another array php return json header and content list_all_array an early stages of list all function that uses an array to pass in main variables replace singular variable assignment with an array loop and variable variables using the $_SERVER['HTTP_REFERER'] to check referring pages timeline class and function php html template class system views list function for checking what views have been made on the current week load array load all items from an array while in a sqlite load sql loop create a 200 character summary from a longer html string using strlen to check the length of a string and do something about it How to record your own page views with PHP, and make them into weekly monthly and yearly charts load from fields array php class function get the current week as a number with php creating embedded php code from a database field test php bundle write check if a file exists with php check if the file is a directory or check if the directory exists in php get the current working directory in php create directory with php create folder with php check if a product already exists by its md5 load random videos module using template PHP/SQLite - Load Random Item split a string into links using the comma extract youtube image from video url simple php ip blocker preg replace clean a string only allow a-zA-Z0-9 characters get last month as a number with php verify the google recapture server php rtrim strip white space or strings from the end of a string get the current month as a number show the difference between two dates in years, months, days, hours and seconds counting the occurrence of words in a multidimensional array write string contents to a file with php unable to access the $_FILES when submitting a form php check column exists in table sqlite

Related Search Terms

php loadarray 7

php category 11

php Template 11

php variable 16

php multiple 17

php function 13

php template 15

php Function 16

php load array 15

Code Articles Forster Links Tools