phpMyDataGrid Sample

Related Field Sample

Este ejemplo enseña utilizar el tipo de campo 'related'

This sample teach how to use the 'related' typefield

{"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","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"}};

	ID

	Status

	Name

	Middle Name

	Last Name

	Birth Date

	Job Name

111124133

Active

cxjklkl#

Marketing Manager

111124147

Active

jan

aaaa

2023-11-19

New Hire - Job not specified

111124139

Active

hola

Operations Manager

111124132

Active

cxjklkl

New Hire - Job not specified

100661

Active

Martin

Saavedra

1965-10-05

New Hire - Job not specified

100662

Active

Rafael

Villegas

1985-04-24

Marketing Manager

100663

Active

Cesar nm

1988-09-22

Public Relations Manager

100664

Active

Alejandro

Silva

1987-04-07

Productions Manager

Page of 553

Displaying rows 1 to 8 of 4,418

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