phpMyDataGrid Professional - Sample of use
Sample #1 - A full Sample
Este ejemplo demuestra algunas de las opciones de phpMyDataGrid interactuando entre si
This sample shows a full working Grid, featuring the use of some of the options in the grid
Sort ascending
Sort descending
Attach sort ascending
Attach sort descending
New
View
Edit
Delete
Refresh
Export to ...
{"image_1" : {"strfieldName" : "image_1","strHeader" : "View dates","fieldWidth" : "25","maxlength" : "0","columnwidth" : "20px","align" : "center","mask" : "imagelink:images/calendar.gif:citas(%s),emp_id","default" : "","select" : "","cutChar" : "0","datatype" : "imagelink","inputtype" : "4","ordering" : ""},"active" : {"strfieldName" : "active","strHeader" : "","fieldWidth" : "25","maxlength" : "0","columnwidth" : "40px","align" : "center","mask" : "imagelink:favorites_sample_images/star%s.gif:favorite(%s\\,this),active","default" : "","select" : "","cutChar" : "0","datatype" : "imagelink","inputtype" : "3","permissions" : "R","ordering" : ""},"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"},"fname" : {"strfieldName" : "fname","strHeader" : "Name","fieldWidth" : "13","maxlength" : "20","columnwidth" : "95px","align" : "left","mask" : "text","default" : "","select" : "","cutChar" : "0","datatype" : "text","inputtype" : "0","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","ordering" : "1"},"birth_date" : {"strfieldName" : "birth_date","strHeader" : "Birth Date","fieldWidth" : "5","maxlength" : "10","columnwidth" : "105px","align" : "left","mask" : "date:ymd:-","default" : "","select" : "","cutChar" : "0","datatype" : "date","inputtype" : "0","ordering" : "1"},"job_id" : {"strfieldName" : "job_id","strHeader" : "Job Name","fieldWidth" : "5","maxlength" : "30","columnwidth" : "195px","align" : "left","mask" : "related:select job_desc from jobs where job_id=%s","default" : "2","select" : "","cutChar" : "0","datatype" : "related","inputtype" : "1","ordering" : "1"},"hire_date" : {"strfieldName" : "hire_date","strHeader" : "Hire Date","fieldWidth" : "5","maxlength" : "19","columnwidth" : "195px","align" : "left","mask" : "datetime:mdy:-:His,:","default" : "","select" : "","cutChar" : "0","datatype" : "datetime","inputtype" : "2","permissions" : "X+"},"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" : "95px","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"},"photo" : {"strfieldName" : "photo","strHeader" : "Photo","fieldWidth" : "25","maxlength" : "0","columnwidth" : "150px","align" : "center","mask" : "image:upload_images_folder/%s","default" : "","select" : "","cutChar" : "0","datatype" : "image","inputtype" : "3","imageWidth" : "95","imageHeight" : "127","permissions" : "RUM","ordering" : ""}};
New
Export
Export to ...
View dates
ID
Name
Middle Name
Last Name
Birth Date
Job Name
Salary
Days
Value Days
Photo
111124067
Operations Manager
10.00
3
$ 1.00
111124143
New Hire - Job not specified
$ 0.00
111124149
New Hire - Job not specified
$ 0.00
111124150
New Hire - Job not specified
$ 0.00
11112367
000
2018-06-04
Programacion de Software
23,000.00
12
$ 9,200.00
595188
aaa
z
tuile
2019-01-28
Marketing Manager
0.00
0
$ 0.00
111123985
aaa
a
aaa
Acquisitions Manager
12.00
$ 0.00
101479
Aladino
F
1969-03-02
Managing Editor
444.00
9
$ 133.20
101789
Aladino
L
christian
1965-05-09
Managing Editor
5.00
28
$ 4.67
102361
Alais
F
DelgadoOo
1990-12-12
Marketing Manager
83,425.00
5
$ 13,904.17
103120
Alais
S
Albarracin
1959-07-21
Public Relations Manager
53,937.00
7
$ 12,585.30
102341
Alais
P
Parra
1982-07-01
Publisher Eto es una prueba ggg g trhjye
83,835.00
13
$ 36,328.50
103524
Alais2
I
Nuncira
1967-02-01
Designer
53,527.00
30
$ 53,527.00
11112103
alan.diaz
a
a.d.l
2015-11-17
New Hire - Job not specified
123.00
$ 0.00
102392
Alba
A
Cisternas
1976-08-12
Sales Representative
53,117.00
22
$ 38,952.47
100845
Alba
A
Soutullo
1957-07-23
Productions Manager
83,015.00
28
$ 77,480.67
101559
Alba
P
Cardenas
1962-04-13
Public Relations Manager
82,810.00
9
$ 24,843.00
101835
Alba
F
Rojas
1970-10-24
Managing Editor
82,400.00
2
$ 5,493.33
101250
Alba
T
Carolina
1980-05-03
Marketing Manager
52,912.00
4
$ 7,054.93
101889
Alba
L
Llain
1966-01-03
Editor
82,605.00
23
$ 63,330.50
Programacion de Software
735,177.00
195
$ 342,838.74
Quick search:
5
10
15
20
25
40
Page
of 221
Displaying rows 1 to 20 of 4,420
You can right click over a record for options - This function is not available in Opera Browser