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

111124127

Inactive

Managing Editor

111124128

Inactive

New Hire - Job not specified

100660

Inactive

Salamanca

1961-01-20

Public Relations Manager

100661

Active

Martin

Saavedra

1965-10-05

New Hire - Job not specified

100662

Inactive

Rafael

Villegas

1985-04-24

Marketing Manager

2 3 4...881 882 883 884

Displaying rows 1 to 5 of 4,417