Ajaxed PHP Datagrid: Eyesis Data Grid Control

6 Dec

Eyesis Data Grid Control is a PHP class for creating a datagrid from a MySQL database almost instantly.

With 6 lines of code, you can connect to the database, mention the table & define the query, rest is automated.

It has nice features like:

Filtering and searching
Changing column headers
Can displaying images
Ajax supported
Automatic row paging
Row selection
Look & feel can be customized via CSS
Ability to add controls
Checkbox support
Specify column format types (such as percent, dollars, etc)

This Ajaxed PHP grid works in all major browsers & requires PHP5 to run.

Requirements: PHP5
Compatibility: All Major Browsers
Website: http://www.eyesis.ca/projects/datagrid.html
Demo: http://www.eyesis.ca/demos/eyedatagrid/ex5.php

Tags: Ajax Php
Filed under: Browsing, Goodies, Other License
4 Comments

4 Responses for "Ajaxed PHP Datagrid: Eyesis Data Grid Control"

Stawl July 16th, 2010 at 9:40 am
It’s an amazing tool, sadly doesn’t seem to read á à ê ô etc… If anyone has a clue on how to read them please tell me.

Damon September 14th, 2011 at 12:43 am
This snippet will expand filtering options:

file: class.eyedatagrid.inc.php

if ($this->allow_filters and $this->filter)
{
if (strstr($this->filter['Value'], ‘%’)) {
$filter_value = ” . $this->filter['Value'] . ”;
$filter_query .= “(`” . $this->filter['Column'] . “` LIKE ‘” . $filter_value . “‘)”;

} elseif (strstr($this->filter['Value'], ‘filter['Value'] . ”;
$filter_query .= “(`” . $this->filter['Column'] . “` ” . $filter_value . “)”;

} elseif (strstr($this->filter['Value'], ‘> ‘)) {
$filter_value = ” . $this->filter['Value'] . ”;
$filter_query .= “(`” . $this->filter['Column'] . “` ” . $filter_value . “)”;

} elseif (strstr($this->filter['Value'], ‘=>’)) {
$filter_value = ” . str_replace(‘=>’,'>=’, $this->filter['Value']) . ”;
$filter_query .= “(`” . $this->filter['Column'] . “` ” . $filter_value . “)”;

} elseif (strstr($this->filter['Value'], ‘=<')) {
$filter_value = '' . str_replace('=<','filter['Value']) . ”;
$filter_query .= “(`” . $this->filter['Column'] . “` ” . $filter_value . “)”;

} elseif (strstr($this->filter['Value'], ‘filter['Value'] . ”;
$filter_query .= “(`” . $this->filter['Column'] . “` ” . $filter_value . “)”;

} elseif (strstr($this->filter['Value'], ‘>=’)) {
$filter_value = ” . $this->filter['Value'] . ”;
$filter_query .= “(`” . $this->filter['Column'] . “` ” . $filter_value . “)”;

} else {
$filter_value = ” . $this->filter['Value'] . ”;
$filter_query .= “(`” . $this->filter['Column'] . “` = ‘” . $filter_value . “‘)”;
}

if ($this->select_where)
$filter_query = $filter_query . ” AND “;

}

Damon September 14th, 2011 at 1:24 am
I cant get this to work… ideas?

http://localhost/index.php?tbl=table1

$tbl = $_GET["tbl"];
$x->setQuery(“*”, “$tbl”);

tried with and without the quotes etc.