php

load from fields array php class function

Posted in php
6
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
6
12:28 pm, September 22, 2021

View Statistics
This Week
36
This Month
223
This Year
0

No Items Found.

Add Comment
Type in a Nick Name here
 
Other Items in php
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 check if the file is a directory or check if the directory exists in php get the current working directory in php create directory with php create folder with php check if a product already exists by its md5 load random videos module using template PHP/SQLite - Load Random Item split a string into links using the comma extract youtube image from video url simple php ip blocker preg replace clean a string only allow a-zA-Z0-9 characters get last month as a number with php verify the google recapture server php rtrim strip white space or strings from the end of a string get the current month as a number show the difference between two dates in years, months, days, hours and seconds counting the occurrence of words in a multidimensional array write string contents to a file with php unable to access the $_FILES when submitting a form php check column exists in table sqlite
Related Search Terms
php bunch 7
php only 7
php above 4
php loadarray 6
php into 8
php load from 9
php value 17
php rtrim 12
php results 16
php multiple 14
php based 12
php where 13
php view 12
php this 14
php the 15
php template 14
php target 14
php sql 24
php select 16
php running 15
php return 15
php nice 18
php limit 14
php just 12
php item 17
php html 18
php here 19
php function 13
php from 16
php file 16
php array 15
php Template 10
php Links 13
php Function 20
php Bunch 14
php variable 19
php php 24
php result 18
php false 15
php remember 12
php name 15
Other Categories in Code
c testing apache apps asp bat bootstrap bootstrap templates core css css grid design elements fancybox fonts foundation framework gimp git html icons ideas images javascript jquery js linux mac nginx node php php functions php simple html dom pi400 python react sections site bugs site documentation sql sqlite sublime svg templates tools virtual box webdev windows wordpress
Code Articles Forster Links Tools
Search Code
Search Code by entering your search text above.
Welcome

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
In this case my anchor this week becomes driving almost 2hrs outside of Atlanta to one of my favorite hard core gyms in the world.. MetroFlex aka The Dungeon. The gym owners turn the heat way up so it becomes a fun sweat box and the gym members just watch from afar and leave me alone. I happily drive myself long distances to find MY ANCHOR. Our anchor allows us to have balance, focus and be as productive as possible. And if you're in the middle of a heavy set and your headphones start to fall off your head, like mine did here.. well.. f*ck the headphones. Let em break and fall. You can always get a new pair, but the iron ain't ever gonna lift itself.
Unknown