phpMyDataGrid Sample

Select Field Sample

Este ejemplo enseña utilizar el tipo de campo 'select' para obtener datos desde otra tabla

This sample teach how to use the 'select' typefield to get data from other table

Search by:

{"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" : "select:select job_id, job_desc from jobs","default" : "","select" : {1 : "New Hire - Job not specified",2 : "Chief Executive Officer",5 : "Publisher Eto es una prueba ggg g trhjye",6 : "Managing Editor",7 : "Marketing Manager",8 : "Public Relations Manager",9 : "Acquisitions Manager",10 : "Productions Manager",11 : "Operations Manager",12 : "Editor",13 : "Sales Representative",14 : "Designer",15 : "????",16 : "????",0 : "Programacion de Software"},"cutChar" : "0","datatype" : "select","inputtype" : "0","ordering" : "1"}};

New

	ID

	Status

	Name

	Middle Name

	Last Name

	Birth Date

	Job Name

111124956

Active

New Hire - Job not specified

111124951

Active

New Hire - Job not specified

111124952

Inactive

New Hire - Job not specified

111124953

Active

New Hire - Job not specified

111124954

Inactive

New Hire - Job not specified

2 3 4...1105 1106 1107 1108

Displaying rows 1 to 5 of 5,540