phpMyDataGrid Professional - Sample of use
Sample No-Layers Grid
Este ejemplo enseña a cambiar la presentación normal de phpMyDataGrid a una presentación sin capas/ventanas
This sample teach how to change the layout of datagrid removing all the layers/windows
{"emp_id" : {"strfieldName" : "emp_id","strHeader" : "ID","fieldWidth" : "40","maxlength" : "50","columnwidth" : "93px","align" : "left","mask" : "text","default" : "","select" : "","cutChar" : "0","datatype" : "text","inputtype" : "1","ordering" : "1"},"active" : {"strfieldName" : "active","strHeader" : "Status","fieldWidth" : "13","maxlength" : "1","columnwidth" : "60px","align" : "left","mask" : "check:Inactive:Active","default" : "","select" : {0 : "Inactive",1 : "Active"},"cutChar" : "0","datatype" : "check","inputtype" : "0","ordering" : "1"},"fname" : {"strfieldName" : "fname","strHeader" : "Name","fieldWidth" : "13","maxlength" : "20","columnwidth" : "95px","align" : "left","mask" : "text","default" : "","select" : "","cutChar" : "0","datatype" : "text","inputtype" : "0","inputwidth" : "200","ordering" : "1"},"minit" : {"strfieldName" : "minit","strHeader" : "Middle Name","fieldWidth" : "5","maxlength" : "1","columnwidth" : "80px","align" : "left","mask" : "text","default" : "","select" : "","cutChar" : "0","datatype" : "text","inputtype" : "0","ordering" : "1"},"lname" : {"strfieldName" : "lname","strHeader" : "Last Name","fieldWidth" : "5","maxlength" : "30","columnwidth" : "95px","align" : "left","mask" : "text","default" : "","select" : "","cutChar" : "0","datatype" : "text","inputtype" : "0","inputwidth" : "200","ordering" : "1"},"birth_date" : {"strfieldName" : "birth_date","strHeader" : "Birth Date","fieldWidth" : "5","maxlength" : "10","columnwidth" : "85px","align" : "left","mask" : "date:ymd:-","default" : "","select" : "","cutChar" : "0","datatype" : "date","inputtype" : "0","ordering" : "1"},"salary" : {"strfieldName" : "salary","strHeader" : "Salary","fieldWidth" : "5","maxlength" : "30","columnwidth" : "95px","align" : "right","mask" : "2:x:.","default" : "","select" : "","cutChar" : "0","datatype" : "number","inputtype" : "0","ordering" : "1"},"days" : {"strfieldName" : "days","strHeader" : "Days","fieldWidth" : "5","maxlength" : "30","columnwidth" : "45px","align" : "right","mask" : "integer:x:.","default" : "","select" : "","cutChar" : "0","datatype" : "number","inputtype" : "0","ordering" : "1"},"total_salary" : {"strfieldName" : "total_salary","strHeader" : "Value Days","fieldWidth" : "10","maxlength" : "10","columnwidth" : "120px","align" : "right","mask" : "scalc:((salary/30)*days)//money:$","default" : "","select" : "","cutChar" : "0","datatype" : "calc","inputtype" : "1","ordering" : "1"}};
New
Search
Export
Export to ...
ID
Status
Name
Middle Name
Last Name
Birth Date
Salary
Days
Value Days
111124127
Inactive
$ 0.00
111124128
Inactive
$ 0.00
100660
Inactive
j
R
Salamanca
1961-01-20
68,762.00
15
$ 34,381.00
100661
Active
Martin
L
Saavedra
1965-10-05
43,288.00
23
$ 33,187.47
100662
Inactive
Rafael
I
Villegas
1985-04-24
81,096.00
25
$ 67,580.00
100663
Inactive
Cesar
R
1988-09-22
77,185.00
3
$ 7,718.50
100664
Active
Alejandro
P
Silva
1987-04-07
46,554.00
25
$ 38,795.00
100665
Inactive
Magaly
M
Ascanio
1990-04-18
64,206.00
8
$ 17,121.60
100666
Inactive
Dios
M
Leon
1967-12-01
85,139.00
20
$ 56,759.33
100667
Inactive
Ana
A
Eduardo
1969-08-25
64,352.00
9
$ 19,305.60
530,582.00
128
$ 274,848.50
Quick search:
Name
Last Name
5
10
15
20
25
40
Page
of 442
Displaying rows 1 to 10 of 4,417
Tip: Hold shift key while click the ordering arrows to order by multiple columns
Sugerencia: Mantenga presionada la tecla Shift mientras hace clic en las flechas de ordenamiento para ordenar por múltiples columnas