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 - Assistance :: Countries (a_countries.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

Database Host: Database Name: * Database User: * Database Password:

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)
	Caption Type Table Field Key Operator Width Sensitivity Comparison Country textbox countries country_name %like% No string
+ Add New Field

VIEW Mode Settings

Table : *	-- select -- accessaccountsaccounts_customeraccounts_docaccounts_employeeaccounts_employee_salaryaccounts_expenseaccounts_expense_categoryaccounts_expense_customeraccounts_expense_mismatchaccounts_expense_purchaseaccounts_expense_saleaccounts_movementaccounts_objectaccounts_paymentaccounts_payment_categoryaccounts_payment_customeraccounts_payment_expenseaccounts_payment_modeaccounts_payment_officeaccounts_payment_supplieraccounts_payment_walletaccounts_propertyaccounts_registeraccounts_register_closeaccounts_register_openaccounts_supplieraccounts_transactionaccounts_transaction_movementaccounts_transaction_productaccounts_transaction_statusaccounts_transaction_typeaccounts_userbanksbanks_accountbrandsbrands_docbrands_doc_relationcasescitiesconstitutionscontactscordinatorscountriesdepartmentsdepartments_guidelinedepartments_managerdesignationsdistrictsdoc_typesdocumentsestimates_categoryestimates_category_relationestimates_category_subestimates_category_sub_alertestimates_category_sub_itemestimates_category_sub_item_standardestimates_category_sub_taskfollowsform_1form_2form_2_aform_2_bform_2_cform_3form_3_aform_3_bformsleadsleads_sourceleads_statusmenusmenus_categorymenus_category_submenus_itemsmodelsmodels_primarynotesoffersofficesoffices_docoffices_employeeoffices_payment_recepientoffices_useropportunitiesprocess_1process_10process_10_aprocess_11process_11_aprocess_12process_12_alertprocess_12_attendeeprocess_12_csatprocess_12_eventprocess_12_photoprocess_12_standardprocess_12_taskprocess_12_videoprocess_2process_3process_4process_5process_7process_8process_9processesproductsproducts_categoryreports_workstatestasksuqcvendorsvendors_typevendors_user
Query:	SELECT * FROM TABLE (standard)Custom
Fields:	All fields (*) - auto generatedSpecify by one
Layout:	Tabular (horizontal)Columnar (vertical)
Width:	% px em pt
Default Order:	country_idcountry_namecountry_abbrcountry_currency     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  country_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_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 country_abbr 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_currency 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 -- accessaccountsaccounts_customeraccounts_docaccounts_employeeaccounts_employee_salaryaccounts_expenseaccounts_expense_categoryaccounts_expense_customeraccounts_expense_mismatchaccounts_expense_purchaseaccounts_expense_saleaccounts_movementaccounts_objectaccounts_paymentaccounts_payment_categoryaccounts_payment_customeraccounts_payment_expenseaccounts_payment_modeaccounts_payment_officeaccounts_payment_supplieraccounts_payment_walletaccounts_propertyaccounts_registeraccounts_register_closeaccounts_register_openaccounts_supplieraccounts_transactionaccounts_transaction_movementaccounts_transaction_productaccounts_transaction_statusaccounts_transaction_typeaccounts_userbanksbanks_accountbrandsbrands_docbrands_doc_relationcasescitiesconstitutionscontactscordinatorscountriesdepartmentsdepartments_guidelinedepartments_managerdesignationsdistrictsdoc_typesdocumentsestimates_categoryestimates_category_relationestimates_category_subestimates_category_sub_alertestimates_category_sub_itemestimates_category_sub_item_standardestimates_category_sub_taskfollowsform_1form_2form_2_aform_2_bform_2_cform_3form_3_aform_3_bformsleadsleads_sourceleads_statusmenusmenus_categorymenus_category_submenus_itemsmodelsmodels_primarynotesoffersofficesoffices_docoffices_employeeoffices_payment_recepientoffices_useropportunitiesprocess_1process_10process_10_aprocess_11process_11_aprocess_12process_12_alertprocess_12_attendeeprocess_12_csatprocess_12_eventprocess_12_photoprocess_12_standardprocess_12_taskprocess_12_videoprocess_2process_3process_4process_5process_7process_8process_9processesproductsproducts_categoryreports_workstatestasksuqcvendorsvendors_typevendors_user
Fields:	All fields (*) - auto generatedSpecify by one
Layout:	Tabular (horizontal)Columnar (vertical)
Width (for modes):	Add/Edit: % px em pt     Details: % px em pt
Fields Definition:
PK  Field Visible Header Type Align Width Required Validation Len Readonly Unique Default  Extra #1   Extra #2   Extra #3  country_id textbox textarea label date datetime (Ymd) datetime (dmY) datetime (mdY) time money enum print checkbox image file link foreign_key blob hidden validator left center right No Yes any text (English) alphanum numeric integer float login email password zipcode verified checkbox URL No Yes No Yes Simple Wysiwyg country_name textbox textarea label date datetime (Ymd) datetime (dmY) datetime (mdY) time money enum print checkbox image file link foreign_key blob hidden validator left center right No Yes any text (English) alphanum numeric integer float login email password zipcode verified checkbox URL No Yes No Yes Simple Wysiwyg country_abbr textbox textarea label date datetime (Ymd) datetime (dmY) datetime (mdY) time money enum print checkbox image file link foreign_key blob hidden validator left center right No Yes any text (English) alphanum numeric integer float login email password zipcode verified checkbox URL No Yes No Yes Simple Wysiwyg country_currency textbox textarea label date datetime (Ymd) datetime (dmY) datetime (mdY) time money enum print checkbox image file link foreign_key blob hidden validator left center right No Yes any text (English) alphanum numeric integer float login email password zipcode verified checkbox URL No Yes No Yes Simple Wysiwyg

Foreign Keys Settings

+ Add New Field

Master/Details Keys Settings

+ Add New Field

[ Switch to Code ]  [ : Back ]