Posted in
5817
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;
}
View Statistics
This Week
142
This Month
606
This Year
1568
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
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