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

Inactive

New Hire - Job not specified

111124950

Inactive

New Hire - Job not specified

111124951

Inactive

New Hire - Job not specified

111124952

Inactive

New Hire - Job not specified

111124953

Inactive

New Hire - Job not specified

2 3 4...1100 1101 1102 1103

Displaying rows 1 to 5 of 5,512