Gurú Sistemas Ltd.

Facility	Speed	Support
Even a novice programmer can generate a php DataGrid complete with a professional finish in a few minutes applying a few lines of code.	With just a few lines of code, obtain a complete and professional DataGrid for your site.	Receive quick answers to your questions about phpMyDataGrid, receive customized examples and support 24 hours a day.

Interactive Documentation

Installation

Properties

Methods

You can modify the value of the parameters input boxes, see the generated code in the Example of use Box and copy the code into your own scripts

Properties

ButtonWidth

Description:

Specifies the width of the icons used as buttons on phpMyDataGrid.

Allowed values:

ButtonWidth

Integer.
Default: 25

Example of use:

$objGrid -> ButtonWidth = '25';

<<• >>

backtick

Description:

Some databases like MySQL allow to enclose the name of the fields, table names or database names, by using a special character, for example ` the character

Allowed values:

backtick

Character.
Default: `

Example of use:

$objGrid -> backtick = '`';

<<• >>

liquidTable

Description:

Defines whether or not phpMyDataGrid will fit automatically the width available on the screen.

Allowed values:

liquidTable

Boolean.
Default: false

Example of use:

$objGrid -> liquidTable = false;

<<• >>

width

Description:

It complements the property liquidTable defining the percentage of which will fit the screen automatically.

Allowed values:

width

String, Defining a percentage.
Default: 100%

Example of use:

$objGrid -> width = '100%';

<<• >>

condition

Description:

It is now possible to condition the style of certain records giving them another output format, as easy as define the conditions that must be fulfilled.

Allowed values:

condition

String, conditional statement.

Example of use:

$objGrid -> condition = "['activo']==1";

Atention: It is possible to use any field used within the grid, simply type the field name between [' ... ']

<<• >>

conditionalStyle

Description:

This property complements the use of condition property, in this property are defined the styles to display the records that meet the specified condition.

Allowed values:

conditionalStyle

CSS style list

Example of use:

$objGrid -> conditionalStyle = "style='background:#600;color:#FFF;'";

<<• >>

conditionEdit

Description:

If you want to limit the editing records only those who meet certain conditions, use the following property to define the condition that must be fulfilled.

Allowed values:

conditionEdit

String, conditional statement.

Example of use:

$objGrid -> conditionEdit = "['activo']==1";

Atention: It is possible to use any field used within the grid, simply type the field name between [' ... ']

<<• >>

conditionDelete

Description:

If you want to limit the deleting records only those who meet certain conditions, use the following property to define the condition that must be fulfilled.

Allowed values:

conditionDelete

Example of use:

$objGrid -> conditionDelete = "['activo']==1";

Atention: It is possible to use any field used within the grid, simply type the field name between [' ... ']

<<• >>

moneySign

Description:

Define the sign to display in Money field types

Allowed values:

moneySign

1 character.
Default: $

Example of use:

$objGrid -> moneySign = '$';

<<• >>

zebraLines

Description:

Defenes the way in which the interlined will be displayed

Allowed values:

zebraLines

Integer
Default: 1

Example of use:

$objGrid -> zebraLines = '1';

<<• >>

showToOf

Description:

This property defines if the message Displaying records X to Y is displayed or not

Allowed values:

showToOf

Boolean.
Default: true

Example of use:

$objGrid -> showToOf = true;

<<• >>

AllowChangeNumRows

Description:

phpMyDataGrid allows to end user to modify the amount of records per page to display, if you don't like to allow the user to do that, set this property to false

Allowed values:

AllowChangeNumRows

Boolean.
Default: true

Example of use:

$objGrid -> AllowChangeNumRows = true;

<<• >>

sqlDataCoding

Description:

Defines the database encoding

Allowed values:

sqlDataCoding

Example of use:

$objGrid -> sqlDataCoding = "SET NAMES 'utf8'";

<<• >>

charset

Description:

Allow to define the page coding in which the page will be rendered.

Allowed values:

charset

Default: ISO-8859-1

Example of use:

$objGrid -> charset = 'UTF-8';

<<• >>

defaultdateformat

Description:

Defines the default format to date type fields

Allowed values:

defaultdateformat

Combination of dmy characters
Default: dmy

Example of use:

$objGrid -> defaultdateformat = 'ymd';

<<• >>

defaultdateseparator

Description:

Defines the date separator char.

Allowed values:

defaultdateseparator

1 Character.
Default: /

Example of use:

$objGrid -> defaultdateseparator = '-';

<<• >>

csvSeparator

Description:

Character used to separate the values exported in CSV (Comma Separated Values)

Allowed values:

csvSeparator

1 character
<5strong>Default: ;

Example of use:

$objGrid -> csvSeparator = ';';

<<• >>

uploadDirectory

Description:

This property is used to define the folder where images will be uploaded

Allowed values:

uploadDirectory

path to images folder, it may be relative or absolute
Default: /

Example of use:

$objGrid -> uploadDirectory = '/images/upload/';

Atention: Specified path must have write permissions.

<<• >>

show404image

Description:

Defines if phpMyDataGrid would display a 404 image when the related image is not found.

Allowed values:

show404image

Boolean.
Default: false

Example of use:

$objGrid -> show404image = false;

<<• >>

retcode

Description:

By default, phpMyDataGrid is rendered at the end of the script execution, but if this property is changed to true, then the HTML code will be returned as value to be stored in a variable.

Allowed values:

retcode

Boolean
Default: false

Example of use:

$objGrid -> retcode = false;

<<• >>

getMyOwnButtons

Description:

It allows the developer to control the position of the buttons New / Search / Export, by not displaying them directly on the grid, but allows to be positioned in any section of your website.

Allowed values:

getMyOwnButtons

Boolean.
Default: false

Example of use:

$objGrid -> getMyOwnButtons = false;

Atention: Note: To function, property retcode must be set to true.

<<• >>

strAddBtn:

Function name:

This property complements getMyOwnButtons property, returning the HTML for add button

Example of use:

echo $objGrid -> strAddBtn;

<<• >>

strSearchBtn:

Function name:

This property complements getMyOwnButtons property, returning the HTML for search button

Example of use:

echo $objGrid -> strSearchBtn;

<<• >>

strExportBtn:

Function name:

This property complements getMyOwnButtons property, returning the HTML for export button

Example of use:

echo $objGrid -> strExportBtn;

<<• >>

cssPrinter

Description:

Define the CSS styles filename that will be used for printing.

Allowed values:

cssPrinter

Path and CSS filename
Default: css/b-w-print.css

Example of use:

$objGrid -> cssPrinter = '/css/my_css_file.css';

<<• >>

PDFfont

Description:

Set the font to use when exporting to PDF

Allowed values:

PDFfont

FontName
Default: Arial

Example of use:

$objGrid -> PDFfont = 'Times New Roman';

<<• >>

PDFfontsize

Description:

Set the font size to use when exporting to PDF

Allowed values:

PDFfontsize

Numeric.
Default: 7

Example of use:

$objGrid -> PDFfontsize = '8';

<<• >>

PDFfill

Description:

It defines the RGB values for the background color for titles when exporting to PDF

Allowed values:

PDFfill

Default: array("R"=>192,"G"=>192,"B"=>192);

Example of use:

$objGrid -> PDFfill = array("R"=>0,"G"=>192,"B"=>192);

<<• >>

PDFdraw

Description:

It defines the RGB values for the color of the letter to export to PDF

Allowed values:

PDFdraw

Default: array("R"=>0,"G"=>0,"B"=>0);

Example of use:

$objGrid -> PDFdraw = array("R"=>0,"G"=>192,"B"=>192);

<<• >>

actHeader

Descripción:

It is used to generate a header in the options: New, Edit, View.

Valores posibles:

actHeader ['']

$objGrid -> actHeader['add'] = 'Header for <strong>New</strong>';

<<• >>

actFooter

Descripción:

It is used to generate a footer in the options: New, Edit, View.

Valores posibles:

actFooter ['']

$objGrid -> actFooter['add'] = 'Footer for <strong>New</strong>';

<<• >>

images

Descripción:

This property is a vector containing the names of the image files to be used as icons in the Datagrid.

Valores posibles:

images ['']

$objGrid -> images['add'] = 'add.png';

Importante: If you change something in the name of image, make sure that the image exists in the folder of images

<<• >>

message

Descripción:

This property is a vector that contains the descriptive texts to be used in the Datagrid, changing their values, you'll customize the datagrid to use your own texts

Valores posibles:

message ['']

$objGrid -> message['cancel'] = 'Cancel';

<<• >>

debug

Description:

Generates messages to debug the results of phpMyDataGrid

Allowed values:

debug

Boolean.
Default: false

Example of use:

$objGrid -> debug = false;

<<• >>

poweredby

Description:

Defines whether the phpMyDataGrid logo is shown

Allowed values:

poweredby

Boolean.
Default: false

Example of use:

$objGrid -> poweredby = false;

<<• >>

Home ¦ News ¦ Documentation ¦ Samples ¦ Downloads ¦ Buy ¦ Support ¦ Terms of Use