Me, mysql and php

var xmlStore = new Ext.data.JsonStore({
	url: '/some/index/xml-list/', // here we have an action in some module, index controller
	fields: xml_st, // created via zend_db_table
	totalProperty: 'count', // calculated from zend_db_table
	root: 'xml' // allways the table name, xml here is not the output format!!!
});

// this is created from zend_db_table.
var xml_st = [
	{name: 'xml_id', type: 'int'},
	{name: 'created_on', type: 'date', dateFormat: 'Y-m-d H:i:s'},
	{name: 'updated_on', type: 'date', dateFormat: 'Y-m-d H:i:s'},
	{name: 'xml_name', type: 'string'},
	{name: 'xml_description', type: 'string'},
	{name: 'status', type: 'int'}
];

// this is created from zend_db_table
var xml_cm = [
	{header: 'xml_id', dataIndex: 'xml_id', id: 'xml_id', resizeable: true, sortable: true, align: 'right'},
	{header: 'created_on', dataIndex: 'created_on', id: 'created_on', resizeable: true, sortable: true, renderer: Ext.util.Format.dateRenderer('d.m.Y')},
	{header: 'updated_on', dataIndex: 'updated_on', id: 'updated_on', resizeable: true, sortable: true, renderer: Ext.util.Format.dateRenderer('d.m.Y')},
	{header: 'xml_name', dataIndex: 'xml_name', id: 'xml_name', resizeable: true, sortable: true},
	{header: 'xml_description', dataIndex: 'xml_description', id: 'xml_description', resizeable: true, sortable: true},
	{header: 'status', dataIndex: 'status', id: 'status', resizeable: true, sortable: true, hidden: true}
];

// this is all we have to write to make a basic grid
var xmlGrid = new Ext.grid.GridPanel({
	renderTo: 'xml_div',
	title: 'XML',
	store: xmlStore,
	columns: xml_cm, // the created column model
	stripeRows: true,
	border: true,
	frame: true
});

getAdapter()->fetchOne("select count(*) as count from {$this->_name} where $where");
		} else {
			$count = $this->getAdapter()->fetchOne("select count(*) as count from {$this->_name}");
		}

		return $count;

	}

	public function extWriteGridSettings() // write some settings
	{

		$cm = "var {$this->_name}_cm = [\n";
		$st = "var {$this->_name}_st = [\n";

		foreach($this->_metadata as $index => $arr) { // the metadata

			switch($arr['DATA_TYPE']) {
				case 'int':
					$type = 'int';
					$cmExtra = ", align: 'right'";
					break;
				case 'mediumint':
					$type = 'int';
					$cmExtra = ", align: 'right'";
					break;
				case 'timestamp':
					$type = 'date';
					$stExtra = ", dateFormat: 'Y-m-d H:i:s'";
					$cmExtra = ", renderer: Ext.util.Format.dateRenderer('d.m.Y')";
					break;
				case 'decimal':
					$type = 'auto';
					$cmExtra = ", align: 'right', renderer: Ext.util.Format.Currency";
					break;
				case 'varchar':
					$type = 'string';
					break;
				case 'tinyint':
					$type = 'int';
					break;
				case 'text':
					$type = 'string';
					break;
				default:
					$type = 'auto';
					break;
			}

			if(strlen($this->sortables[$index]) > 0) {
				$cmArr[] = "\n\t{header: '{$this->sortables[$index]}', dataIndex: '$index', id: '$index', resizeable: true, sortable: true{$cmExtra}}";
			} else {
				$cmArr[] = "\n\t{header: '$index', dataIndex: '$index', id: '$index', resizeable: true, sortable: true{$cmExtra}}";
			}

			$stArr[] = "\n\t{name: '$index', type: '$type'$stExtra}";

			$type = '';
			$stExtra = '';
			$cmExtra = '';

		}

		$cm .= implode(', ', $cmArr)."\n\n];\n\n";
		$st .= implode(', ', $stArr)."\n\n];";

		$cf = Zend_Registry::get('config');

		$fp = fopen($cf->path->file.'pub/js/ext-cache/'.$this->_name.'_gs.js', 'a'); // write where ever you wish

		fwrite($fp, $cm.$st);

		fclose($fp);

		chmod($cf->path->file.'pub/js/ext-cache/'.$this->_name.'_gs.js', 0777);

	}

}

_table->getCount($where);

		$count = 0;
		foreach($this->_data as $key => $value) {
			$arr[$this->_table->info('name')][$count] = $value;
			$count++;
		}

		if($count == 0) {
			$arr[$this->_table->info('name')];
		}

		return Zend_Json::encode($arr);

	}

}

public function xmlListAction()
{
	$this->_autoRender = false; // my internal funciton to stop smarty from rendering
	$xmlModel = new xmls(); // the model
	$rs = $xmlModel->fetchAll();
	echo $rs->toExtJson(); // the record set
}