Posted in php functions
4811
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
134
This Month
642
This Year
449

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

'Dawnie' used to say, "It's really quite simple: Be kind, and the rest takes care of itself. Never do anything that's not kind".


Dawn Atherton
Random CSS Property

<easing-function>

The <easing-function> CSS data type denotes a mathematical function that describes the rate at which a numerical value changes.
steps() css reference