MENU

• Open All | Close All
• Creating & Calling
• General
• Printing & Exporting
• Sorting & Paging
• Filtering
• VIEW Mode
• ADD/EDIT/DETAILS Modes
• Foreign Keys
• Master/Details Keys
• : Back

DataGrid Wizard - Test Page (test.php)

[ Switch to Code ]  [ : Back ]

Creating & Calling

PHP Extension: PDO Database Type: MySQLPostgreSQLSQLiteOracleCubridFirebird / Interbase 6FreeTDS / MSSQL / Sybase (dblib)Microsoft SQL Server (sqlsrv)IBM DB2IBM Informix Dynamic ServerODBC v3 (IBM DB2,unixODBC,win32 ODBC) DataGrid Unique Prefix (ex.: ab_): * Debug Mode: On Off

General Settings

PostBack Method:	GET POST AJAX
Language:	ArabicBulgarianCatalaChineseCzechDanishEnglishEspanolFinnishFrenchGermanGreekHebrewBosnian/CroatianHungarianItalianoJapaneseKoreanLithuanianNetherlandsBrazilian PortuguesePolishRomanianRussianSwedishSerbianThaiTurkish     Direction: Left-to-Right Right-to-Left     Collation: -- select -- armscii8_binarmscii8_general_ciascii_binascii_general_cibig5_binbig5_chinese_cibinarycp1250_bincp1250_croatian_cicp1250_czech_cscp1250_general_cicp1250_polish_cicp1251_bincp1251_bulgarian_cicp1251_general_cicp1251_general_cscp1251_ukrainian_cicp1256_bincp1256_general_cicp1257_bincp1257_general_cicp1257_lithuanian_cicp850_bincp850_general_cicp852_bincp852_general_cicp866_bincp866_general_cicp932_bincp932_japanese_cidec8_bindec8_swedish_cieucjpms_bineucjpms_japanese_cieuckr_bineuckr_korean_cigb2312_bingb2312_chinese_cigbk_bingbk_chinese_cigeostd8_bingeostd8_general_cigreek_bingreek_general_cihebrew_binhebrew_general_cihp8_binhp8_english_cikeybcs2_binkeybcs2_general_cikoi8r_binkoi8r_general_cikoi8u_binkoi8u_general_cilatin1_binlatin1_danish_cilatin1_general_cilatin1_general_cslatin1_german1_cilatin1_german2_cilatin1_spanish_cilatin1_swedish_cilatin2_binlatin2_croatian_cilatin2_czech_cslatin2_general_cilatin2_hungarian_cilatin5_binlatin5_turkish_cilatin7_binlatin7_estonian_cslatin7_general_cilatin7_general_csmacce_binmacce_general_cimacroman_binmacroman_general_cisjis_binsjis_japanese_ciswe7_binswe7_swedish_citis620_bintis620_thai_ciucs2_binucs2_czech_ciucs2_danish_ciucs2_esperanto_ciucs2_estonian_ciucs2_general_ciucs2_hungarian_ciucs2_icelandic_ciucs2_latvian_ciucs2_lithuanian_ciucs2_persian_ciucs2_polish_ciucs2_roman_ciucs2_romanian_ciucs2_slovak_ciucs2_slovenian_ciucs2_spanish2_ciucs2_spanish_ciucs2_swedish_ciucs2_turkish_ciucs2_unicode_ciujis_binujis_japanese_ciutf8_binutf8_czech_ciutf8_danish_ciutf8_esperanto_ciutf8_estonian_ciutf8_general_ciutf8_hungarian_ciutf8_icelandic_ciutf8_latvian_ciutf8_lithuanian_ciutf8_persian_ciutf8_polish_ciutf8_roman_ciutf8_romanian_ciutf8_slovak_ciutf8_slovenian_ciutf8_spanish2_ciutf8_spanish_ciutf8_swedish_ciutf8_turkish_ciutf8_unicode_ci
CSS Class:	DefaultBlueGrayGreenPinkX-BlueX-GrayX-Green
Caption:
Footer:
Allowed Mode Operations:	Add | Edit | Delete | Details
Multi-Row Operations:	Edit | Details | Clone | Delete       Enable: On Off

Printing & Exporting Settings

Allow Printing:	NoYes
Allow Exporting:	CSV | XLS | PDF | XML       Enable: NoYes     Export all records: NoYes

Sorting & Paging Settings

Allow Column Sorting:	NoYes
Allow Paging:	NoYes    Rows Numeration: NoYes    Default Size: 510152025501002505001000    Pager Positions: BottomTopBoth    Dropdownlist: NoYes

Filtering Settings

Allow Filtering:	NoYes     Layout: Tabular (horizontal)Columnar (vertical)Advanced (inline)
+ Add New Field

VIEW Mode Settings

Table : *	-- select -- apdgw_testapdgw_test_countriesapdgw_test_regions
Query:	SELECT * FROM TABLE (standard)Custom
Fields:	All fields (*) - auto generatedSpecify by one
Layout:	Tabular (horizontal)Columnar (vertical)
Width:	% px em pt
Default Order:	idcountryfirst_namelast_nameuser_nameemaildate_updatedpercentageavatardescription     Sort By: ASC DESC
Fields Definition:
PK  Field Visible Header Type Align Sort Width Wrap Case Len Tooltip Sum  Extra #1   Extra #2   Extra #3  id label image checkbox linktoview linktoedit linktodelete link money password barchart enum blob Left Center Right No Yes No Yes normal upper lower camel No Yes No SUM AVG MAX MIN SUM_TIME country label image checkbox linktoview linktoedit linktodelete link money password barchart enum blob Left Center Right No Yes No Yes normal upper lower camel No Yes No SUM AVG MAX MIN SUM_TIME first_name label image checkbox linktoview linktoedit linktodelete link money password barchart enum blob Left Center Right No Yes No Yes normal upper lower camel No Yes No SUM AVG MAX MIN SUM_TIME last_name label image checkbox linktoview linktoedit linktodelete link money password barchart enum blob Left Center Right No Yes No Yes normal upper lower camel No Yes No SUM AVG MAX MIN SUM_TIME user_name label image checkbox linktoview linktoedit linktodelete link money password barchart enum blob Left Center Right No Yes No Yes normal upper lower camel No Yes No SUM AVG MAX MIN SUM_TIME email label image checkbox linktoview linktoedit linktodelete link money password barchart enum blob Left Center Right No Yes No Yes normal upper lower camel No Yes No SUM AVG MAX MIN SUM_TIME date_updated label image checkbox linktoview linktoedit linktodelete link money password barchart enum blob Left Center Right No Yes No Yes normal upper lower camel No Yes No SUM AVG MAX MIN SUM_TIME percentage label image checkbox linktoview linktoedit linktodelete link money password barchart enum blob Left Center Right No Yes No Yes normal upper lower camel No Yes No SUM AVG MAX MIN SUM_TIME avatar label image checkbox linktoview linktoedit linktodelete link money password barchart enum blob Left Center Right No Yes No Yes normal upper lower camel No Yes No SUM AVG MAX MIN SUM_TIME description label image checkbox linktoview linktoedit linktodelete link money password barchart enum blob Left Center Right No Yes No Yes normal upper lower camel No Yes No SUM AVG MAX MIN SUM_TIME

ADD/EDIT/DETAILS Modes Settings

Table : *	-- select -- apdgw_testapdgw_test_countriesapdgw_test_regions
Fields:	All fields (*) - auto generatedSpecify by one
Layout:	Tabular (horizontal)Columnar (vertical)
Width (for modes):	Add/Edit: % px em pt     Details: % px em pt

Foreign Keys Settings

+ Add New Field

Master/Details Keys Settings

+ Add New Field

[ Switch to Code ]  [ : Back ]