CreativeTable it’s a php class that builds a table based on the data retrieved by an SQL query or an 2D Array. It has lots of options and it’s very, very configurable.
It’s perfect to incorporate with your backoffices, because it’s very flexible and very easy to build. You can also easily integrate with your sites.
Features
very easy to configurate support almost all sql queries, if not all extremely flexible super fast search and advanced search with multiple search items per page sort and multi sort actions list easy to add static rows ot to add columns integration with any pager system multiple pagers in the same table multiple tables in the same page easy way to add html in your cells easy way to configure the attributes of your cells various examples (Real, Complex, Ajax, Search, ItemsPerPage, Sort, ExtraCols, Data, 2DArray, Separate, Custom, Display, 2Pagers, 2Tables, LargeDB, 2ItemsPerPage, FormatCols, CellAttributes, Json) styles examples Updates
v1.3 (13 September 2011)
MySQL syntax compapibily upgraded. Now almost all SQL queries work, if not all. possibility of using * in the SELECT * FROM … clauses search types added – $params[‘search_type’] = (like, =, begining_like or end_like) table_with parameter added – $params[‘search_type’] = (% or px or ’’) debug parameter added – mysql errors shown in table – $params[‘debug’] = (true or false) added an example with 2 items per page added an example with a new easy way to add html to your cells added an example with a new feature of adding attributes to the cells added an example to include JSON for unsupported browsers and PHP versions v1.2 (11 November 2010)
parameter table_key added for boosting the performance of the table in large DBs performance of the table improoved by 50 times, event without assigning the table_key (earlier versions took 1s to change page, now it takes 20ms) – SUPER FAST added an example of how to call the components separatly added an example of custom component feature of showing only some especific columns added an example of a table with 2 pagers added an example of 2 tables in the same page added an example of measuring the table_key boost in a large DB v1.1 (26 August 2010)
added an example of data manipulation (adding a link to the cells) added an example of filling the table with a 2D array ajax_url parameter added (url to be called by ajax, by default the url is the same file) ajax files rearranged (they don’t need the ct_ajax_server.php any more) Hope you like this.
LIVE PREVIEW http://www.creativedreams.eu/creative_table/