!C99Shell v. 2.0 [PHP 7 Update] [25.02.2019]!
Software: nginx/1.23.4. PHP/5.6.40-65+ubuntu20.04.1+deb.sury.org+1 uname -a: Linux foro-restaurado-2 5.15.0-1040-oracle #46-Ubuntu SMP Fri Jul 14 21:47:21 UTC 2023 aarch64 uid=33(www-data) gid=33(www-data) groups=33(www-data) Safe-mode: OFF (not secure) /home/wwwroot/frames/ drwxrwxr-x Free 83.3 GB of 96.73 GB (86.12%) Encoder Tools Proc. FTP brute Sec. SQL PHP-code Update Feedback Self remove Logout

!C99Shell v. 2.0 [PHP 7 Update] [25.02.2019]!

Software: nginx/1.23.4. PHP/5.6.40-65+ubuntu20.04.1+deb.sury.org+1

uname -a: Linux foro-restaurado-2 5.15.0-1040-oracle #46-Ubuntu SMP Fri Jul 14 21:47:21 UTC 2023
aarch64

uid=33(www-data) gid=33(www-data) groups=33(www-data)

Safe-mode: OFF (not secure)

/home/wwwroot/frames/ drwxrwxr-x
Free 83.3 GB of 96.73 GB (86.12%)
Encoder Tools Proc. FTP brute Sec. SQL PHP-code Update Feedback Self remove Logout

Viewing file: dataGrid.html (55.05 KB) -rw-rw-r--
Select action/file-type:
(+) |

(+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |

Docs For Class dataGrid

dataGrid

[ ] [ ] [ ]

ChangeLog

License

ReadMe

Packages:
dataGrid

Files:

dataGrid

Classes:

dataGrid

Class: dataGrid

Source Location: /class.datagrid.php

Class Overview

A class used to display data resulted from a MySQL query or from an array, in an accessible way for the end-user

Author(s):

Stefan Gabos <[email protected]>

Version:

1.0 BETA 3 (last revision: May 15, 2007)

Copyright:

Class Details

[line 38]
A class used to display data resulted from a MySQL query or from an array, in an accessible way for the end-user

Some of the highlights:

the class executes a given SQL query and generates a template driven HTML code that displays the query results
automatically provides means of navigation trough pages and lets user decide how many rows to be displayed on each page
automatically let user sort by available columns - or you can restrict this feature for specific columns
if requested, it can automatically display a "selector" column - a column to let users mark specific rows as selected
you set what columns from the query result to be displayed
you can alter the content of a column's fields on the fly by creating callback functions
you can add JavaScript actions for when user clicks on displayed rows or on specific column's cells
you can extend the functionality of the data grid by adding custom columns - columns whose content is not generated by the query but added by you - you can add any HTML and/or JavaScript to perform any action
everything is template driven
multi-language support

See the documentation for more info.

Read the LICENSE file, provided with the package, to find out how you can use this PHP script.

If you don't find this file, please write an email to noname at nivelzero dot ro and you will be sent a copy of the license file

For more resources visit http://stefangabos.blogspot.com

Tags:

copyright:	(c) 2006 - 2007 Stefan Gabos
author:	Stefan Gabos <[email protected]>
version:	1.0 BETA 3 (last revision: May 15, 2007)
name:	dataGrid

[ Top ]

Class Variables

$defaultPage =

[line 66]

The page to starts showing records from.

default is 1

Type:

integer

[ Top ]

$formAction =

[line 204]

Where should the grid go upon submit

this is a read-only property

Type:

string

[ Top ]

$formName =

[line 215]

The form name is automatically generated every time.

Read this property to find out what is the form's generated name

this is a read-only property

Type:

string

[ Top ]

$maxNavigationPages =

[line 97]

The maximum number of pages to be shown at once in the navigation tab

default is 10

Type:

integer

[ Top ]

$noDataMsg =

[line 195]

Message to display if there are no records to display

By default, the strLang_noRecords message is displayed from the language file

If this property is anything else than an empty string, it will be used as the message for when there are no records to display

Default is "" (an empty string)

Type:

string

[ Top ]

$recordsOnPageArray =

[line 130]

Array of items to be shown in "records on page" select box in the navigation tab

default is array(5, 10, 15, 20, 25, 50, 100)

Type:

array

[ Top ]

$rowsOnPage =

[line 121]

The default number of rows to be displayed on a single page

Note that if the value of this property doesn't exists in recordsOnPageArray, it's value be lost upon the first submit and will revert to the first value in recordsOnPageArray

default is 15

Type:

integer

[ Top ]

$scrollNavigationPagesFromPage =

[line 109]

The selected page from which to start scrolling the pages in the navigation tab

(i.e suppose you have 20 pages. at first, pages from 1 through 10 are shown in the navigation tab (if $maxNavigationPages is set to 10) but when you click on page 7 then pages from 2 to 12 will be shown in the navigation tab - that is, if $scrollNavigationPagesFromPage is set to 5)

default is 5

Type:

integer

[ Top ]

$showBottomCustomTab =

[line 88]

When set to TRUE, a custom tab will be displayed at the bottom of the table (above the bottom navigation tab)

Use addToCustomTab method to add items to the custom tab

default is TRUE

Type:

boolean

[ Top ]

$showBottomNavigation =

[line 57]

When set to TRUE, a navigation tab will be displayed at the bottom of the table

default is TRUE

Type:

boolean

[ Top ]

$showTopCustomTab =

[line 77]

When set to TRUE, a custom tab will be displayed at the top of the table (underneath the top navigation tab)

Use addToCustomTab method to add items to the custom tab

default is TRUE

Type:

boolean

[ Top ]

$showTopNavigation =

[line 48]

When set to TRUE, a navigation tab will be displayed at the top of the table

default is TRUE

Type:

boolean

[ Top ]

$URLa =

[line 182]

The data grid uses POST which is not SEO friendly but might suit some of the implementations.

If you want the data grid to be SEO friendly you should set the useSEO property to TRUE and set this property to a value of your choice, representing the prefix of the page you're currently on, in the data grid. This value will then be appended to the URL where the data grid is shown.

So if you have your data grid at

http://www.mysite.com/example.php

...and you set this property's value to "?page=", upon navigating to another page of the data grid, the URL will become

http://www.mysite.com/example.php?page=X (where X is the current page in the data grid)

...while setting it to "/" will make the URL look like

http://www.mysite.com/example.php/X (where X is the current page in the data grid)

Note that this only work if the useSEO property is set to TRUE

Default is '?page=' (without the quotes)

Type:

string

[ Top ]

$useSEO =

[line 155]

The data grid uses POST which is not SEO friendly but might suit some of the implementations.

If you want the data grid to be SEO friendly you should set this property to TRUE and set the URLa property to a value * of your choice, representing the prefix of the page you're currently on, in the data grid. This value will then be appended to the URL where the data grid is shown.

So if you have your data grid at

http://www.mysite.com/example.php

...and you set URLa to "?page=", upon navigating to another page of the data grid, the URL will become

http://www.mysite.com/example.php?page=X (where X is the current page in the data grid)

...while setting it to "/" will make the URL look like

http://www.mysite.com/example.php/X (where X is the current page in the data grid)

Default is FALSE

Type:

boolean

[ Top ]

Class Methods

constructor dataGrid [line 253]

void dataGrid(
string
$source, 
&$db, [string
$formAction = ""], string
$db)

Initializes the grid

Parameters:

string	$source	a SELECT SQL to be used to generate grid data OR an associative array you wish to display in the grid, where the keys of the array will be the column names Notes If you are passing a MySQL SELECT query, you must not use ORDER BY and LIMIT statements in it as they are appended automatically!

string	$db	a reference to an instantiated "Zebra PHP Framework MySQL Database Wrapper" object. you should use this approach for logging and debugging purposes but the class will work even if you don't specify this reference. in this case the class will assume that there is already a connection to a MySQL database Notes In case source is an array or you simply don't want to use use Zebra's MySQL Database Wrapper, this argument must still be a variable! So, instead of passing an empty string, you should pass something like $void

string	$formAction	(optional) Where should the grid go upon submit Default is an empty string and is interpreted as the current path Notes You should leave this like it is unless you know what you're doing!

	&$db

[ Top ]

method addJavaScript [line 347]

void addJavaScript(

$script)

Ads an user-defined javascript code block (javascript function or stand-alone commands) that will be outputted with the grid and that can be called by the grid's methods

Do not specify <script></script> headers as they will be automatically added!

You can call this method as many times as you want. Previously set code will not be overwritten

Parameters:

	$script

[ Top ]

method addToCustomTab [line 369]

void addToCustomTab(
string
$HTMLBlock, [integer
$position = ""])

Adds an HTML block (refered to as 'item') to the custom tab

Parameters:

string	$HTMLBlock	HTML code block to add (this will be further refered to as 'item')

integer	$position	(optional) by default items are added from left to right. if you want your item in a specific position, specify it here. (this is 0 based index - position 0 will be the first item in the custom tab therefore the leftmost)

[ Top ]

method disableSorting [line 434]

void disableSorting(
string
$columnName)

Disables sorting possibility for column (by default all columns are sortable)

This method is also available for custom columns

Parameters:

string

$columnName

identifier name of a column previously set with the showColumn or showCustomColumn method, for which to disable sorting

Notes

This argument can also be an array, if you want to disable sorting for multiple columns at once

[ Top ]

method enableSorting [line 471]

void enableSorting(
string
$columnName)

Enables sorting for a column on which sorting was previously disabled by using the disableSorting method

Parameters:

string

$columnName

identifier name of a column previously set with the showColumn or showCustomColumn method, for which to enable sorting

Notes

This argument can also be an array, if you want to enable sorting for multiple columns at once

[ Top ]

method render [line 500]

boolean render(
[
$toVar = false])

Outputs the grid

Tags:

return:

TRUE on success or FALSE on failure

Parameters:

	$toVar

[ Top ]

method setActionFunction [line 1251]

void setActionFunction(
string
$columnName, string
$actionFunctionName)

Binds to a column an user defined PHP function that returns the javascript to be run whenever the onclick event occurs on any of column's fields

The user defined function takes as parameter the value of the field where the onclick event occurred and, optionally, an array containing all the available fields and their respective values for that particular row

By calling this method you will unset any previously set actions by the setRowActionFunction method for the specified column

Parameters:

string	$columnName	identifier name of a column previously set with the showColumn or showCustomColumn method

string	$actionFunctionName	name of the user defined function

[ Top ]

method setCallBackFunction [line 1277]

void setCallBackFunction(
string
$columnName, string
$callbackFunctionName)

Sets a callback function to be run on each value of a specific column before displaying it

Parameters:

string	$columnName	identifier name of a column previously set with the showColumn or showCustomColumn method Notes This argument can also be an array, if you want to set the same callback function for multiple columns at once

string	$callbackFunctionName	name of the user defined function

[ Top ]

method setColumnHTMLProperties [line 1318]

void setColumnHTMLProperties(
string
$columnName, string
$HTMLProperties)

Sets HTML attributes for specific column

The properties must be valid HTML markup for the <td> element (or whatever element you are using in the template)

Parameters:

string	$columnName	identifier name of a column previously set with the showColumn or showCustomColumn method Notes This argument can also be an array, if you want to set the attributes for multiple columns at once

string	$HTMLProperties	HTML attributes

[ Top ]

method setDefaultSortColumn [line 1352]

void setDefaultSortColumn(
string
$columnName, [string
$sortDirection = "ASC"])

Sets the default column to sort the records by, and the direction of sorting

Parameters:

string	$columnName	identifier name of a column previously set with the showColumn or showCustomColumn by which to sort the data initially

string	$sortDirection	the direction of sorting. possible values are "ASC" and "DESC" default is "ASC"

[ Top ]

method setFieldHTMLProperties [line 1376]

void setFieldHTMLProperties(

$columnName, 
$HTMLProperties)

Alias of setColumnHTMLProperties

Tags:

deprecated:

This method is deprecated - please use setColumnHTMLProperties instead

Parameters:

	$columnName

	$HTMLProperties

[ Top ]

method setFooterHTML [line 1390]

void setFooterHTML(
string
$HTML)

Sets the HTML code to be displayed after the rendering of the table but INSIDE the form

Parameters:

string	$HTML	HTML code to be displayed

[ Top ]

method setHeaderHTML [line 1404]

void setHeaderHTML(
string
$HTML)

Sets the HTML code to be displayed before the rendering of the table but INSIDE the form

Parameters:

string	$HTML	HTML code to be displayed

[ Top ]

method setLanguage [line 1423]

void setLanguage(

$languageFile, string
$language)

Sets a new language

Default language of the data grid is english

Parameters:

string	$language	The name of the php language file you wish to use from the /languages folder must be specified Without the extension! (i.e. "german" for the german language not "german.php")

	$languageFile

[ Top ]

method setRowActionFunction [line 1448]

void setRowActionFunction(
string
$actionFunctionName)

Specifies a user defined PHP function that returns the javascript to be run whenever the onclick event occurs on any field of any row

After calling this method you can still set specific actions for individual column fields by calling the setActionFunction method.

Parameters:

string	$actionFunctionName	name of the user defined function

[ Top ]

method setSecondarySortColumns [line 1474]

void setSecondarySortColumns(
string
$columnNames)

If you need additional sorting columns, after the primary sort column, use this method to set them

The column set with setDefaultSortColumn or at run-time by the user is known as "the primary sorting column"

Parameters:

string	$columnNames	Identifier names of columns you wish to further order the results by (and optionally ASC or DESC - as you would normally use when writing MySQL ORDER BY clauses), separated by commas

[ Top ]

method setTemplate [line 1493]

void setTemplate(
string
$template)

Sets a new template to be used

Default template of the data grid is "default"

Parameters:

string	$template	The folder of the template you wish to use. Inside the folder there must be a template.xtpl file which will be automatically used

[ Top ]

method setTitleHTMLProperties [line 1539]

void setTitleHTMLProperties(
string
$columnName, string
$HTMLProperties)

Sets HTML attributes for specific column's title

The properties must be valid HTML markup for the <td> element (or whatever element is used in the template)

Parameters:

string	$columnName	identifier name of a column previously set with the showColumn or showCustomColumn method Notes This argument can also be an array, if you want to set the attributes for multiple column titles at once

string	$HTMLProperties	HTML attributes

[ Top ]

method showColumn [line 1580]

void showColumn(
string
$columnName, [string
$title = ""])

Sets a column for displaying in the grid (none are displayed by default)

Parameters:

string	$columnName	name of an existing column Notes If data source is an SQL, you can also refer to column names as <tablename.columnname> All methods that require you to specify the "identifier name of the column" as parameter refer to this property!

string	$title	(optional) text to be displayed instead of the column name

[ Top ]

method showCustomColumn [line 1606]

void showCustomColumn(
string
$columnName, [string
$title = ""])

Specifies a custom column to be shown

A custom column is a column whose data is not found in the data source

The content of a custom column is generated by using the setCallBackFunction method

Parameters:

string	$columnName	a name for the column Notes All methods that require you to specify the "identifier name of the column" as parameter refer to this property!

string	$title	(optional) text to be displayed instead of the column name

[ Top ]

method showSelectorColumn [line 1639]

void showSelectorColumn(
string
$columnName, string
$controlName, string
$valueSeed)

Enables a "selector" column - a column with checkboxes enabling the user to mark specific rows as selected

Parameters:

string	$columnName	string to be displayed as column title

string	$controlName	a unique name to identify the checkbox controls array Notes All methods that require you to specify the "identifier name of the column" as parameter refer to this property! Each checkbox's ID will be $controlName + underscore + specific value; So, if the control's name is "checkbox" and $valueSeed's first value's is 1, the first checkbox's ID will be "checkbox_1"

string	$valueSeed	the identifier name of a column in data source to be used for values for each checkbox Notes this column must be a column that holds data that uniquely identifies data from each row

[ Top ]

method unsetActionFunction [line 1744]

void unsetActionFunction(
string
$columnName, [string
$block = false])

Unsets the action function

By calling this method you will unset any previously set actions by the setRowActionFunction or the setActionFunction methods for the specified column

Parameters:

string	$columnName	identifier name of a column previously set with the showColumn or showCustomColumn method Notes This argument can also be an array, if you want to unset the action for multiple columns at once

string	$block	if set to true, further calling of the setRowActionFunction function will have no effect on the $columnName column. you can still set an action to this column by calling the setActionFunction method explicitly for $columnName