Latest web development tutorials
×

jQuery EasyUI Tutorial

jQuery EasyUI Tutorial jQuery EasyUI Introduction

jEasyUI application

jEasyUI Create a CRUD application jEasyUI Create a CRUD data grid jEasyUI Form CRUD application jEasyUI Create an RSS reader

jEasyUI Drag and drop

jEasyUI Basic drag and drop jEasyUI Create a drag-and-drop shopping cart jEasyUI Create a school curriculum

jEasyUI Menus and buttons

jEasyUI Create a simple menu jEasyUI Create a link button jEasyUI Create a menu button jEasyUI Create a split button

jEasyUI layout

jEasyUI Create a border layout jEasyUI Create a complex layout jEasyUI Creates a fold panel jEasyUI Create a tab page jEasyUI Dynamically add a tab jEasyUI Add the AutoPlay tab jEasyUI Create the XP style left panel

jEasyUI Data grid

jEasyUI Convert HTML tables to data grids jEasyUI Get the selected row data jEasyUI Add the query function jEasyUI Add a toolbar jEasyUI Create complex toolbars jEasyUI Sets the frozen column jEasyUI Dynamically change columns jEasyUI Format the column jEasyUI Set sort jEasyUI Custom sorting jEasyUI Create a column combination jEasyUI Add a check box jEasyUI Custom tab jEasyUI Enable in-line editing jEasyUI Extension editor jEasyUI Column operation jEasyUI Merge Cells jEasyUI Create a custom view jEasyUI Create a footer summary jEasyUI Condition Sets the line background color jEasyUI Create an attribute grid jEasyUI The extended line shows the details jEasyUI Create a subgrid jEasyUI Display massive data jEasyUI Add a paging component

jEasyUI window

jEasyUI Create a simple window jEasyUI Customize the Window Toolbar jEasyUI Window and layout jEasyUI Create a dialog box jEasyUI Customize the dialog box

jEasyUI Tree menu

jEasyUI Use the markup to create a tree menu jEasyUI Create an asynchronous tree menu jEasyUI Tree menu to add nodes jEasyUI Create a tree menu with check boxes jEasyUI Tree menu drag and drop control jEasyUI The Tree menu loads the parent / child nodes jEasyUI Create the base tree grid jEasyUI Create a complex tree grid jEasyUI Dynamic loading of tree jEasyUI The tree grid adds pagination jEasyUI Tree-lazy lazy-loading node

jEasyUI Form

jEasyUI Create an asynchronous submission form jEasyUI Form validation jEasyUI Create a tree drop-down box jEasyUI Format the drop-down box jEasyUI Filter down the data grid

jEasyUI Reference Manual

jQuery EasyUI Plugin jQuery EasyUI Extended

jQuery EasyUI form - Filter drop-down data grid (ComboGrid)

Drop-down data grid (Combogrid) common components, and drop-down boxes (Combobox) component is, in addition to have a drop-down panel, which are based on data grid (Datagrid) of. Drop-down data grid (Combogrid) components can be filtered, paging, and has some other data grid (Datagrid) function. This tutorial shows you how to filter the data recorded in a drop-down data grid (Combogrid) component.

Create a drop-down data grid (Combogrid) 

<Input id = "cg" style = "width: 150px">

$ ( '# Cg'). Combogrid ({
	panelWidth: 500,
	url: 'form5_getdata.php',
	idField: 'itemid',
	textField: 'productid',
	mode: 'remote',
	fitColumns: true,
	columns: [[
		{Field: 'itemid', title: 'Item ID', width: 60},
		{Field: 'productid', title: 'Product ID', align: 'right', width: 80},
		{Field: 'listprice', title: 'List Price', align: 'right', width: 60},
		{Field: 'unitcost', title: 'Unit Cost', align: 'right', width: 60},
		{Field: 'attr1', title: 'Attribute', width: 150},
		{Field: 'status', title: 'Stauts', align: 'center', width: 60}
	]]
});

Drop-down data grid (Combogrid) components should define 'idField' and 'textField' property. 'IdField' property store component values, 'textField' property to display the text message in the text input box. Drop-down data grid (Combogrid) component may be 'local' or 'remote' mode filter records. In remote (remote) mode, when the user enters a character into the text input box, the drop-down data grid (Combogrid) to send the 'q' parameter to the remote server.

Server-side code

form5_getdata.php 
? $ Q = isset ($ _ POST [ 'q']) strval ($ _ POST [ 'q']): '';

include 'conn.php';

$ Rs = mysql_query ( "select * from item where itemid like '% $ q%' or productid like '% $ q%'");
$ Rows = array ();
while ($ row = mysql_fetch_assoc ($ rs)) {
	$ Rows [] = $ row;
}
echo json_encode ($ rows);

Download jQuery EasyUI examples

jeasyui-form-form5.zip