Posted in php functions
4809
5:51 am, November 3, 2021
 

list all array json function list_all_array_json

I wrote this a while ago, and i always forget the complex functions i write so ill add it here. 

This loads all fields and then returns them as json. 

PHP

// list all but pass in an array, so additional things can be passed in easily
    /*
    $fields_array = [
      "start" => 0,
      "max" => 50,
      "list_type" => "latest",
      "template_file" => "list-all-array-item.html",
      "order_by" => "field_name",
      "order_type" => "desc"
    ];
    list_types: latest, orderby (uses the order_by and order_type)
    // just adding one function for this.  then add the array one sep.
    */


    public function list_all_array_json($fields_array) {

      global $functions;
      global $base_directory;
      global $image_base_directory;

      // assign all fields array to variable names.
      $db_table_name = $this->db->escapeString($this->db_table_name);
      foreach ($fields_array as $field_name => $field_value) {
    		//${$field_name} = $field_value;
    		${$field_name} = $this->db->escapeString($field_value);
      }

      $sql = "";
      $out = "";
      $has_results = false;

      if($list_type == "latest") {
        $sql = "select * from $db_table_name order by insdate desc limit $start,$max";
      }

      // use the order by fields
      if($list_type == "orderby") {
        $sql = "select * from $db_table_name order by $order_by $order_type limit $start,$max";
      }

      $result = $this->db->query($sql);
      $row = array();
      $i = 0;
      while($res = $result->fetchArray()) {
        foreach($this->load_array as $load_title) {
            $row[$i][$load_title] = $res[$load_title];
        }
        $i++;
      }
      return $row;

      while($row = $result->fetchArray()) {
          $has_results = true;
          $return_array = array();
      }
      if(isset($return_array)) {
        return $return_array;
      }

      if(!$has_results) {
        // no results message or false...
        return false;
      }

      return $out;

    }

View Statistics
This Week
132
This Month
640
This Year
447

No Items Found.

Add Comment
Type in a Nick Name here
 
Search Code
Search Code by entering your search text above.
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...

Subscribe to weekly updates about things i have added to the site or thought interesting during the last week.

You could also follow me on twitter or not... does anyone even use twitter anymore?

If you found something useful or like my work, you can buy me a coffee here. Mmm Coffee. ☕

❤️👩‍💻🎮

🪦 2000 - 16 Oct 2022 - Boots
Random Quote
You want to be the best, you MUST put the long yards in! Nothing comes easy in life so stop wishing and start DOING! So many people would rather bitch and moan than help themselves. Dont be one of those negative drainers, start today, make a small change and keep going forwards with this attitude!
Unknown
Random CSS Property

scroll-margin-left

The scroll-margin-left property defines the left margin of the scroll snap area that is used for snapping this box to the snapport. The scroll snap area is determined by taking the transformed border box, finding its rectangular bounding box (axis-aligned in the scroll container's coordinate space), then adding the specified outsets.
scroll-margin-left css reference