load from fields array php class function

PHP

// pass in multiple fields to match and load based on this
    // usually 1 item as max?
    // $fields_array["field_name"] = "field_value";
    // this replaces the load from load_from_fields_two and three functions which were a bit complex.
    /*
    $fields_array = [
      "field_name" => "field val",
    ];
    */
    public function load_from_fields_array($fields_array, $max = 1) {
      global $bugs;
      $bugs .= "running function ". __FUNCTION__ . " <br />";
      $max = $this->db->escapeString($max);

      $load_sql = "";
      foreach($fields_array as $field_name => $field_value) {
        $field_name = $this->db->escapeString($field_name);
        $field_value = $this->db->escapeString($field_value);
        $load_sql .= "$field_name = '$field_value' and ";
      }
      $load_sql = rtrim($load_sql,"and ");

      $db_table_name = $this->db_table_name;
      $sql = "select * from $db_table_name where $load_sql limit $max";

      $bugs .= "\$load_sql:$load_sql<br />";
      $bugs .= "\$sql:$sql<br />";

      $result = $this->db->query($sql);
      while($row = $result->fetchArray()) {
          $bugs .= "Item Loaded<br />";
          // auto load all items from the $load_array
          foreach($this->load_array as $load_title) {
              $this->$load_title = $row[$load_title];
          }
          $this->loaded = true;
          return true;
      }
      $bugs .= "No Item Found";
      return false;

    }

    /*
    $fields_array = [
      "field_name" => "field val",
    ];
    if the template is blank it will just return an array...
    maybe just return an array.
    */
    // same as the above function load_from_fields_array but returns multiple results, and can use a template?...
    // rather than just loading the item
    public function load_from_fields_array_multi($fields_array, $max = 1, $template_file = "title-links.html") {
      global $bugs;
      global $template;
      $bugs .= "running function ". __FUNCTION__ . " <br />";
      $max = $this->db->escapeString($max);
      $out_array = array();
      $out = "";

      $load_sql = "";
      foreach($fields_array as $field_name => $field_value) {
        $field_name = $this->db->escapeString($field_name);
        $field_value = $this->db->escapeString($field_value);
        $load_sql .= "$field_name = '$field_value' and ";
      }
      $load_sql = rtrim($load_sql,"and ");

      $db_table_name = $this->db_table_name;
      $sql = "select * from $db_table_name where $load_sql limit $max";

      $bugs .= "\$load_sql:$load_sql<br />";
      $bugs .= "\$sql:$sql<br />";

      $result = $this->db->query($sql);
      while($row = $result->fetchArray()) {
          $bugs .= "Item Loaded";
          // auto load all items from the $load_array
          $template_item = new template($template_file);
          foreach($this->load_array as $load_title) {
            $template_item->set($load_title,$row[$load_title]);
              // $this->$load_title = $row[$load_title];
              // $out_array[$load_title] = $row[$load_title];
          }

          $template_item->set("db_table_name",$db_table_name);
          $view_link = $this->view_link_target($row['title'],$row['uid']);
          $template_item->set("view_link",$view_link);
          $out .= $template_item->output();
      }
      return $out;
      //$bugs .= "No Item Found";
      //return false;

    }