php

load from fields array php class function

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

View Statistics
This Week
232
This Month
965
This Year
2008

No Items Found.

Add Comment
Type in a Nick Name here
 
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 55
php fetchArray 47
php loadfromfieldsarray 145
php loadfrom 21
php what 112
php links 124
php Where 76
php bunch 121
php only 100
php above 85
php loadarray 43
php into 106
php load from 114
php value 104
php rtrim 104
php results 121
php multiple 107
php based 113
php where 95
php view 107
php this 104
php the 105
php template 94
php target 113
php sql 143
php select 117
php running 121
php return 118
php nice 107
php limit 111
php just 115
php item 111
php html 118
php here 126
php function 93
php from 108
php file 111
php array 91
php Template 114
php Links 106
php Function 108
php Bunch 86
php variable 115
php php 130
php result 106
php false 102
php remember 108
php name 101
Other Categories in Code
alpine js apps c css factorio font awesome images linux quick modals sqlite site bugs site updates slick slider sliders testing windows apps apache api apps asp bat bootstrap bootstrap templates charts cookies core css css filters css grid design elements docker domains emoji fancybox fonts foundation framework gimp git html icons ideas image formatting images javascript javascript functions jquery js linux mac misc modals mysql nginx node php php errors php function php functions php simple html dom pi400 python react regex sections simple_html_dom simplepie php site bugs site documentation slick slider sql sqlite ssh sublime svg svg css templates tools virtual box vscode vue webdev windows windows 11 windows commands wordpress
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
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
Random CSS Property

url()

The url() CSS function is used to include a file. The parameter is an absolute URL, a relative URL, a blob URL, or a data URL. The url() function can be passed as a parameter of another CSS functions, like the attr() function. Depending on the property for which it is a value, the resource sought can be an image, font, or a stylesheet. The url() functional notation is the value for the <url> data type.
<url> css reference