Posted in php functions
6325
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
208
This Month
1277
This Year
1963

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

Please dont do this! 😜


Unknown Web Developer
Random CSS Property

<length>

The <length> CSS data type represents a distance value. Lengths can be used in numerous CSS properties, such as width, height, margin, padding, border-width, font-size, and text-shadow.
length#vh css reference