phpMyDataGrid Professional - Sample of use

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

{"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
			111124143					New Hire - Job not specified			$ 0.00
			111124067					Operations Manager	10.00	3	$ 1.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
			102341	Alais	P	Parra	1982-07-01	Publisher Eto es una prueba ggg g trhjye	83,835.00	13	$ 36,328.50
			103120	Alais	S	Albarracin	1959-07-21	Public Relations Manager	53,937.00	7	$ 12,585.30
			102361	Alais	F	DelgadoOo	1990-12-12	Marketing Manager	83,425.00	5	$ 13,904.17
			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
			101835	Alba	F	Rojas	1970-10-24	Managing Editor	82,400.00	2	$ 5,493.33
			103820	Alba	M	Sanguino	1984-03-24	Designer	52,707.00	15	$ 26,353.50
			101889	Alba	L	Llain	1966-01-03	Editor	82,605.00	23	$ 63,330.50
			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
			101250	Alba	T	Carolina	1980-05-03	Marketing Manager	52,912.00	4	$ 7,054.93
			102392	Alba	A	Cisternas	1976-08-12	Sales Representative	53,117.00	22	$ 38,952.47
			103843	Alba2	D	Monsalvez	1953-09-02	Acquisitions Manager	83,220.00	17	$ 47,158.00
								Programacion de Software	871,104.00	227	$ 416,350.24

Quick search:  

51015202540

Page of 221

Displaying rows 1 to 20 of 4,418

You can right click over a record for options - This function is not available in Opera Browser