phpMyDataGrid Sample

Multi search/filter

Este ejemplo muestra una forma fácil de implementar búsquedas o filtros por varios campos

This sample show an easy way to implement search or filter by several fields

Search by:

{"emp_id" : {"strfieldName" : "emp_id","strHeader" : "ID","fieldWidth" : "40","maxlength" : "50","columnwidth" : "33px","align" : "left","mask" : "text","default" : "","select" : "","cutChar" : "0","datatype" : "text","inputtype" : "1","ordering" : "1"},"active" : {"strfieldName" : "active","strHeader" : "Activo","fieldWidth" : "5","maxlength" : "12","columnwidth" : "60px","align" : "left","mask" : "check:Active:Inactive","default" : "","select" : {0 : "Active",1 : "Inactive"},"cutChar" : "0","datatype" : "check","inputtype" : "0","ordering" : "1"},"fname" : {"strfieldName" : "fname","strHeader" : "First name","fieldWidth" : "13","maxlength" : "255","columnwidth" : "180px","align" : "left","mask" : "text","default" : "","select" : "","cutChar" : "0","datatype" : "text","inputtype" : "0","ordering" : "1"},"lname" : {"strfieldName" : "lname","strHeader" : "Last Name","fieldWidth" : "13","maxlength" : "255","columnwidth" : "180px","align" : "left","mask" : "text","default" : "","select" : "","cutChar" : "0","datatype" : "text","inputtype" : "0","ordering" : "1"},"birth_date" : {"strfieldName" : "birth_date","strHeader" : "Birth Date","fieldWidth" : "10","maxlength" : "255","columnwidth" : "130px","align" : "left","mask" : "text","default" : "","select" : "","cutChar" : "0","datatype" : "text","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"}};

New

Export

	ID

	Activo

	First name

	Last Name

	Birth Date

	Job Name

111124135

Inactive

debil

kutas

2023-11-19

New Hire - Job not specified

111124134

Inactive

cxjklkl

0000-00-00

New Hire - Job not specified

111124133

Inactive

cxjklkl#

0000-00-00

New Hire - Job not specified

111124147

Inactive

jan

aaaa

2023-11-19

New Hire - Job not specified

111124139

Active

hola

0000-00-00

New Hire - Job not specified

111124141

Active

asdf

0000-00-00

New Hire - Job not specified

111124132

Active

cxjklkl

0000-00-00

New Hire - Job not specified

111124127

Active

0000-00-00

New Hire - Job not specified

111124129

Active

cxjklkl

0000-00-00

New Hire - Job not specified

111124130

Active

cxjklkl

0000-00-00

New Hire - Job not specified

111124131

Inactive

cxjklkl

0000-00-00

New Hire - Job not specified

100660

Active

Salamanca

1961-01-20

Programacion de Software

100661

Inactive

Martin

Saavedra

1965-10-05

New Hire - Job not specified

100662

Inactive

Rafael

Villegas

1985-04-24

Marketing Manager

100663

Active

Cesar nm

1988-09-22

Public Relations Manager

100664

Inactive

Alejandro

Silva

1987-04-07

Productions Manager

100665

Active

Magaly

Ascanio

1990-04-18

New Hire - Job not specified

100666

Active

Dios

Leon

1967-12-01

Chief Executive Officer

100667

Active

Ana

Eduardo

1969-08-25

New Hire - Job not specified

100668

Active

Fasley

Rosa

1966-05-06

New Hire - Job not specified

2 3 4...219 220 221 222

Displaying rows 1 to 20 of 4,426

Tip: Click over the data to edit it directly in the grid
Sugerencia: Haga clic sobre los datos para editar directamente en el grid