phpMyDataGrid Sample

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" : "0","imageWidth" : "95","imageHeight" : "127","permissions" : "RUMRUM","ordering" : ""}};

	View dates

	ID

	Name

	Middle Name

	Last Name

	Birth Date

	Job Name

	Salary

	Days

	Value Days

	Photo

105

New Hire - Job not specified

$ 0.00

Alfredo

Mullera

Publisher

15,000.00

$ 5,000.00

Alicia

Hernandez

1978-01-12

Publisher

10,000.00

$ 3,333.33

Andres

Devons

2008-05-12

Business Operations Manager

14,000.00

$ 7,000.00

102

asdasd

asdasdasd

2009-01-02

New Hire - Job not specified

$ 0.00

39,000.00

$ 15,333.33

Page of 11

Displaying rows 1 to 5 of 53

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

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