load from fields array php class function [ php ] - KruXoR

php

load from fields array php class function

Posted in php

5971

12:28 pm, September 22, 2021

load from fields array php class function

this class function loads from multiple fields from an array, much easier than passing in a bunch of variables into a function nice and clean, the only issue is you need to remember what fields to add in.

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;

    }

Posted in php

5971

12:28 pm, September 22, 2021

View Statistics

This Week

172

This Month

760

This Year

1722

No Items Found.

Add Comment

Other Items in php

php redirect echo the page id from wordpress sqlite escape string Deprecated: parse_str(): Calling parse_str() without the result argument is deprecated getcwd usage in php to get the current working directory for file includes write to file php save string to file php using preg_match to extract text from elements encode spaces in items passed to url to %20 not + php function load as table - load_as_table turn on or off error reporting php get json with php from a url and display it php convert number with k on the end to full number extract variables from url string php No 'Access-Control-Allow-Origin' header is present on the requested resource. Fatal error: Uncaught Exception: Required extension GD is not loaded. php check if a class exists Uncaught Error: Call to undefined function mb_convert_encoding() get the subdomain name from the domain string in php - sub domain fixing error Call to undefined function simplexml_load_string get the content of a url get the content of a link with php and test if the result is empty php check if url is valid with filter_var php save csv from array to file php export csv from string to browser download convert json string to a php array how to json encode an array in php how to decode xml in php php get file and save it php function to remove the query string from a url using php parse_url function to remove the query string from a url add every value in the load_array array into the out for testing Fix for PHP Warning Trying to get property '*name*' of non-object write the contents of a url into a file with php sqlite fetchArray into another array php return json header and content list_all_array an early stages of list all function that uses an array to pass in main variables replace singular variable assignment with an array loop and variable variables using the $_SERVER['HTTP_REFERER'] to check referring pages timeline class and function php html template class system views list function for checking what views have been made on the current week load array load all items from an array while in a sqlite load sql loop create a 200 character summary from a longer html string using strlen to check the length of a string and do something about it How to record your own page views with PHP, and make them into weekly monthly and yearly charts load from fields array php class function get the current week as a number with php creating embedded php code from a database field test php bundle write check if a file exists with php

Related Search Terms

php fetcharray 49

php fetchArray 41

php loadfromfieldsarray 136

php loadfrom 21

php loadarray 41

php load from 109

php results 112

php multiple 102

php template 91

php running 116

php function 90

php Template 111

php Function 105

php variable 111

php remember 105

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...