Sep 28 07

Populate a ComboBox from a DataStore (JSON)

by Shea Frederick
I would suggest downloading the code used for this example here so you have something to work with. Working examples can be found here. Getting Started The ComboBox is always a very usefull form field type, and populating it dynamically makes it even more usefull. We will just be creating a basic ComboBox thats populated from a JSON data source which pulls data from our database. Read More...
Jul 18 07

Domhelper/DomQuery fun with Forms

by Shea Frederick
I would suggest downloading the code used for this example here so you have something to work with. Working examples can be found here. Getting Started DomHelper is a very powerful tool, so were going to start with some simple things, and you can take it from there. We are going to be using the insertAfter and insertBefore methods of DomHelper in the following examples. Spacing form Elements F Read More...
Jul 5 07

PHP/MySQL Efficient Paged Data

by Shea Frederick
There was some talk recently about the inefficiency of running two queries verses a single query to retrieve paged data, so I decided to do some testing of my own, and here are my results. The first way to retrieve paged data is to run two queries, the first query would be just like the second, just without the LIMIT statement. You would use mysql_num_rows to retreive the total Read More...
May 22 07

Loading Data Into & Submitting a Form

by Shea Frederick
This tutorial uses the employee edit form used in the getting started tutorial, if you are not yet familiar with creating a form then you should start with the getting started tutorial. I would suggest downloading the code used for this example so you have something to work with. You can also find a working example. We will go through the full circle of using form Read More...
Apr 1 07

The Grid – Basics of Paging

by Shea Frederick
I would suggest downloading the code used for this example here so you have something to work with. A working example can be found here. Grid Data A paging grid must have a server side element to perform the breaking up of data into pages. For this example we are using php as the server side language, and a MySQL database with some randomly generated data. The PHP script below is used to Read More...
Mar 10 07

Creating JSON Data in PHP

by Shea Frederick
So you need to encode JSON data for use with ExtJS or some other library? If you are lucky enough to be running PHP 5.2.0 or greater, then you have the optimal environment for encoding JSON data. But all is not lost if you dont have this setup, there are plenty of librarys you can use to take care of this task. For our examples we are using a MySQL database as the data source. PHP 5.2.0 or high Read More...
Mar 2 07

The Template – Getting Started

by Shea Frederick
I would suggest downloading the code used for this example here so you have something to work with. A working example can be found here. Step 1, HTML for Your Template The first step is pretty straight forward, its the HTML that will be used to format your data. Some keywords in curly brackets will be the placeholders for your data {id}, {url} and {text}. You could simplify this by using {0} Read More...
Mar 1 07

The Grid – Getting Started

by Shea Frederick
I would suggest downloading the code used for this example here so you have something to work with. A working example can be found here. Step 1, Data Definition First we need to tell the grid what XML element defines each row of data, in this case its named 'Item' as you can see from the sample XML below. Single Row of XML Sample Data 0446613657 http://www.amazon[*SNIP*]JVQEG2 Read More...