php functions
Posted in
6312
5:51 am, November 3, 2021
list all array json function list_all_array_json
I wrote this a while ago, and i always forget the complex functions i write so ill add it here.
This loads all fields and then returns them as json.
PHP
// list all but pass in an array, so additional things can be passed in easily
/*
$fields_array = [
"start" => 0,
"max" => 50,
"list_type" => "latest",
"template_file" => "list-all-array-item.html",
"order_by" => "field_name",
"order_type" => "desc"
];
list_types: latest, orderby (uses the order_by and order_type)
// just adding one function for this. then add the array one sep.
*/
public function list_all_array_json($fields_array) {
global $functions;
global $base_directory;
global $image_base_directory;
// assign all fields array to variable names.
$db_table_name = $this->db->escapeString($this->db_table_name);
foreach ($fields_array as $field_name => $field_value) {
//${$field_name} = $field_value;
${$field_name} = $this->db->escapeString($field_value);
}
$sql = "";
$out = "";
$has_results = false;
if($list_type == "latest") {
$sql = "select * from $db_table_name order by insdate desc limit $start,$max";
}
// use the order by fields
if($list_type == "orderby") {
$sql = "select * from $db_table_name order by $order_by $order_type limit $start,$max";
}
$result = $this->db->query($sql);
$row = array();
$i = 0;
while($res = $result->fetchArray()) {
foreach($this->load_array as $load_title) {
$row[$i][$load_title] = $res[$load_title];
}
$i++;
}
return $row;
while($row = $result->fetchArray()) {
$has_results = true;
$return_array = array();
}
if(isset($return_array)) {
return $return_array;
}
if(!$has_results) {
// no results message or false...
return false;
}
return $out;
}
View Statistics
This Week
195
This Month
1264
This Year
1950
Add Comment
Other Items in php functions
show views list function
list page links function list_page_links
Return a file extention from a string
shorten string php, string length php, clip string length php
get file name from path name in php
imgur upload from php
simplepie error : XML or PCRE extensions not loaded!
loading a non processed item using the load_from_fields_array function
simple file cache and check in php
loop through $_GET in php
php strip non numbers from string - remove all non-numeric characters from a string
get string between other strings function php
php validate email function
convert a string into its html entitles using php htmlentities function
make a nice readable date using a timestamp string function make_nice_date
get php to validate its self with php check syntax
Spam IP Database and delete button
youtube search api request function
list all array json function list_all_array_json
php get file extension from a file name
php post data back to a url with a function
generate random username function in 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