Posted in php functions
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. 


// 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];
      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
This Month
This Year

No Items Found.

Add Comment
Type in a Nick Name here
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.

Join me on Substack if you want me to send you a collection of the things i have done or found or read for the week. Or follow me on twitter if you prefer, i dont post much but i probably should!


Random Quote