PEAR is archived and read-only

This mirror preserves historical PEAR package releases and metadata so existing references remain available.

Home » Structures » Structures_DataGrid

Render a data table with automatic pagination and sorting

This package is unmaintained.

Download latest release 0.9.3 (archived versions might be outdated)

License: New BSD

Description

This package provides a toolkit to generate data tables in HTML, CSV,
Excel, XML, Smarty, and other formats.
It retrieves data from a variety of data sources, including SQL, CSV,
XML, PDO, DB_DataObject, DB_Table, and others.
It can transparently page and sort the data, through optimized database
queries, by parsing/generating GET, POST requests and REST-like urls.
It is designed with modularity and extensibility in mind, using drivers
for all rendering and datasource formats.

Documentation

Manual

Maintainers

Dependencies

Required

Optional

Releases

Bugs

IDStatusTypeVersionDateSummary
#1023BogusBug2004-03-16Call-time pass-by-reference
#1024ClosedBug2004-03-16it's rendering empty lines
#1025ClosedBug2004-03-16SUGGESTION: use pager and data looper
#1063ClosedBug2004-03-24toHTML not supported
#1064SuspendedBug2004-03-24DataObject not fully supported
#1065ClosedBug2004-03-24DataGrid - Package Directory Structure
#1181ClosedBug2004-04-11Query string is not keep in data ordering
#1371ClosedBug2004-05-09Pager Factory
#1501ClosedBug2004-05-26Feature Requests and Code
#1544DuplicateBug2004-06-02undefined variable $result
#1545ClosedBug2004-06-02Undefined offset
#1584ClosedBug2004-06-08Column formatter does not work due to a typo
#1593No FeedbackBug2004-06-09Error in Core.php with multiple instances
#1739ClosedBug2004-06-29Not working Structures_DataGrid_Record_DataObject
#2003No FeedbackBug2004-07-28Undefined variable:
#2027ClosedBug2004-07-30Pager shouldn't be require'd by default
#2102ClosedReq2004-08-10render -> toHtml() or add getTable() method
#2123ClosedBug2004-08-14Record_DataObject does not recognize DataObject's grand-children
#2124ClosedBug2004-08-14Record_DataObject does not handle $fb_fieldsToRender
#2125ClosedBug2004-08-15GET parameters are intrusive and forbid using several DataGrids
#2128ClosedBug2004-08-15Record_DataObject does not return an error when passed junk
#2438ClosedBug2004-10-03toHTML does not work as expected
#2499ClosedBug2004-10-11Ampersands don't validate
#2500ClosedBug2004-10-11Filter function example code contains typo
#2501ClosedReq2004-10-11Ordering indicator
#2505ClosedBug2004-10-11Parameter in filter feature doesn't work
#2509ClosedBug2004-10-11Unnecessary bold tag added
#2871ClosedBug2004-12-01$this->_options['fields'] doesn't get generated when using bind() and DB result
#3028ClosedBug2004-12-26XUL Renderer does not convert XML entities
#3071BogusBug2004-12-30DataGrid doesnt work in PHP5
#3086ClosedBug2005-01-03Typo in Core.php
#3088ClosedBug2005-01-03Call to $this in static method.
#3089BogusReq2005-01-03Structures_DataGrid_Column::formatter() does not support static method callback
#3097ClosedBug2005-01-04typo in HTMLTable renderer
#3139ClosedReq2005-01-08columnformatter does not allow extra whitespace
#3140ClosedReq2005-01-08Add various FormBuilder inspired options to DataObject DataSource
#3151ClosedBug2005-01-10is_subclass_of
#3156ClosedBug2005-01-10HTMLTable renderer does nor print last page if # of record is < max size
#3157ClosedReq2005-01-10Use get* method(s) if available
#3170No FeedbackReq2005-01-11Add option for limiting field length
#3188ClosedReq2005-01-13Can the callbacks pass the DataGrid_Column?
#3191ClosedBug2005-01-13Structures_DataGrid_Renderer_Smarty::setTemplate()
#3229BogusReq2005-01-18Add ability to add Smarty template variables
#3244ClosedBug2005-01-19Paging not working anymore
#3274ClosedBug2005-01-23Extra fields no longer available
#3304ClosedBug2005-01-26requestPrefix still broken
#3305ClosedBug2005-01-26Syntax error in 0.6.1 after install
#3306ClosedBug2005-01-26Can't addColumn() after bind()'ing
#3314No FeedbackReq2005-01-27setRequestPrefix
#3316ClosedReq2005-01-27New datasource option : sort_default
#3523ClosedReq2005-02-18Allow custom headers ahead of header row
#3588ClosedReq2005-02-24Handle commas and doubel quotes in CSVs
#3601ClosedBug2005-02-25htmlentities needed for data
#3607ClosedBug2005-02-26Binding to null datasets causes fatal error
#3617ClosedBug2005-02-27array_multisort() - Argument #3 is expected to be an array
#3715ClosedBug2005-03-05Emtpy parameter list for formatter gives warning
#3769ClosedBug2005-03-10get* method not called
#3781ClosedBug2005-03-11wrong filename required in CSV.php
#3787No FeedbackBug2005-03-12Pager uses incorrect number of pages
#3847ClosedBug2005-03-16DB DataSource emits a notice if no records returned
#3859ClosedBug2005-03-17Setting useHeader as false still renders the header
#3887DuplicateBug2005-03-19notice php error into DataGrid :: Column.php file
#4022ClosedBug2005-03-31Record isn't passed into the formatter if () is not in the formatter spec
#4046BogusReq2005-04-04Use an object to define a "more intuitive" column formatter?
#4108No FeedbackReq2005-04-09sort national character
#4171BogusBug2005-04-17get{$field} feature in datagrid bug
#4254ClosedReq2005-05-01New DataSource driver (DB_Table)
#4350ClosedBug2005-05-15Structures_DataGrid_Renderer_XML constructor needs variable by reference
#4375ClosedBug2005-05-18Can't change colum links
#4379ClosedReq2005-05-18New DataSource driver (DBQuery)
#4394DuplicateBug2005-05-20Wrong include path in CSV.php
#4403ClosedBug2005-05-21Structures_DataGrid_sortRecordSet
#4415ClosedBug2005-05-24Docs directory goes into wrong directory
#4416ClosedReq2005-05-24Add "informative" functions to Core.php
#4421ClosedBug2005-05-24DataObject driver raises an error when link fields not set
#4434No FeedbackReq2005-05-25In some instances the fields in the record will be limited to displayed columns
#4454DuplicateBug2005-05-27No way to augment auto-generated columns with user defined columns
#4497ClosedReq2005-05-31New feature , flexy datagrid renderer
#4503ClosedBug2005-06-01CVS version of Array.php (1.13) does not count entries correctly
#4521ClosedBug2005-06-03Pager get's wrong value if there is no row limit
#4527ClosedBug2005-06-04allowEmptyRows adds one row too much
#4557ClosedBug2005-06-08Missing header in XLS renderer
#4558ClosedReq2005-06-08XLS renderer: add possibility to write spreadsheet to file
#4565ClosedReq2005-06-09Multiple field sort and record grouping
#4653ClosedReq2005-06-21Add Sub-Record displaying capabilities
#4675ClosedReq2005-06-24add option to specify attributes for header row
#4709ClosedReq2005-06-29add <thead>, <tfoot>, <tbody> to HTMLTable renderer
#4862BogusBug2005-07-19Structures_DataGrid crashes PHP on object creation
#4863ClosedBug2005-07-19Missing variable initialization
#4872ClosedBug2005-07-20Notice caused on formatter
#4874ClosedBug2005-07-21DB_DataObject getter function naming problem
#4891ClosedReq2005-07-22colums callback changing parameter
#5076ClosedReq2005-08-12Add PDO Driver for DataGrid
#5246ClosedReq2005-08-30Allow to append and/or prepend columns
#5255ClosedBug2005-08-31Instantiating the class kills the page
#5292ClosedBug2005-09-04Header links are created incorrectly
#5298ClosedReq2005-09-05new class for custom table headers and footers
#5300ClosedBug2005-09-05Some PHP notices shows when an callback function is used for col formatting
#5327ClosedReq2005-09-07Get rid of the extra space after the delimter when using CSV renderer
#5328BogusBug2005-09-07DataGrid Autofill Does Not Take Precedence Over Formatter
#5499BogusBug2005-09-22DB_Dataobject getMethods called improperly
#5534BogusBug2005-09-27Bad Path to include file
#5535ClosedBug2005-09-27XLS bad Column check
#5565Wont fixReq2005-09-29A new way to add Columns
#5585ClosedReq2005-10-03Add customize option when generate_columns = true
#5606BogusBug2005-10-05Structures_DataGrid fails sorting on joined tables
#5723ClosedBug2005-10-19Smarty Renderer Error
#5758ClosedReq2005-10-23Extra parameters for Structures_DataGrid_Column::formatter() callback
#5806ClosedReq2005-10-28XLS formatage des header automatique
#5808ClosedReq2005-10-28XLS rendering
#5829ClosedBug2005-10-31SDG 0.6.3 htmlentities make multibyte char unreadable
#5838ClosedReq2005-10-31Reversion of: Bug #3601
#5858ClosedBug2005-11-03do not use @ before include_once
#5859ClosedReq2005-11-03New renderer driver interface
#5886ClosedReq2005-11-07Passing default-encoding to htmlentities
#6031ClosedBug2005-11-21charset GB2312 display not correctly
#6032BogusBug2005-11-21DataSource/DataObject.php line 141 lost a "="
#6151ClosedReq2005-12-05Need to encode URL correctly in HTMLTable renderer
#6222ClosedReq2005-12-11Add more paging support to Smarty renderer
#6450ClosedBug2006-01-09sortRecordSet does not work if called after bind
#6522Wont fixReq2006-01-18Fix to determine proper row count instead of guessing
#6582ClosedBug-2006-01-25malfunction sort
#6607ClosedReq2006-01-27Support for table caption in table renderer
#6621ClosedReq0.6.32006-01-29get reference to column by name
#6624ClosedBug0.6.32006-01-29formatter doesn't handle parameters and object methods at the same time
#6670ClosedBug0.6.32006-02-02renderer_smarty can't display template (fix!)
#6720ClosedReq0.6.32006-02-07formatter with array parameters
#6779ClosedBug0.6.32006-02-14sort bug
#7039DuplicateBugCVS2006-03-06sortRecordSet with an array does not work
#7115ClosedBug2006-03-13Link to Trackback tutorial does not work
#7150ClosedBug0.6.32006-03-18Sorting tabular structure doesn't work
#7151BogusBug0.6.32006-03-18Missing HTML Directory
#7199ClosedReq0.6.32006-03-24Source Type Detection Fails on XML
#7333ClosedBugCVS2006-04-07Wrong params for work with MDB2 datasource
#7366ClosedBug0.6.32006-04-11Check if $column->fieldName is NULL
#7521ClosedBug2006-04-28Unknown Class passed Error for DataSource.php
#7534ClosedBug0.6.32006-05-01XLS Character encoding support
#7606ClosedBug0.6.32006-05-11DataGrid Renderer CSV
#7627ClosedBug0.6.32006-05-15Bad docblock for Structures_DataGrid_Column constructor
#7710ClosedBugCVS2006-05-23bind() interferes with rendering
#7746ClosedBug0.6.32006-05-29Doc Complex example uses CVS features
#7848ClosedReqCVS2006-06-09Rendering code review and corrections
#7925ClosedBugCVS2006-06-16formatter args ignored in Column->formatter()
#7927ClosedReqCVS2006-06-16pass row and col through to formatter function
#8004BogusReq0.7.12006-06-26Recordset array gets changed from assoc to numbered
#8005ClosedBug0.7.12006-06-26options from fill arent being passed through
#8040Wont fixReq0.7.12006-06-26Header Column Formatter
#8041ClosedReq0.7.12006-06-26Row Formatter / Color Switching
#8061ClosedReq0.7.12006-06-28Get data as an array
#8065Wont fixReq0.7.12006-06-29_detectSourceType(): CSV
#8089ClosedReqCVS2006-06-30Comment review
#8090ClosedReqCVS2006-06-30Questions after Code Review
#8091BogusReqCVS2006-06-30User defined formatters with automatically generated columns
#8210ClosedBug0.7.12006-07-13documented function getDataSource doesn't exist
#8317Wont fixReq0.7.12006-07-28natural sort
#8320ClosedReq0.7.12006-07-29new methode removeColumn() for existing addColumn()
#8353Wont fixReq0.7.12006-08-03A group by column would be very useful
#8392ClosedBug0.7.12006-08-08Handle sorting for multiple tables/page
#8490Wont fixReqCVS2006-08-17DataSource to produce a summary of the content of a DataObject
#8491ClosedBugCVS2006-08-17Minor comment change
#8651BogusBug0.7.12006-09-07Renderer HTMLTable_noHtmlEnt not installed
#8792BogusReq0.7.12006-09-26Use with Pager_Wrapper?
#9121ClosedBugCVS2006-10-21Use htmlspecialchars when you use PHP_SELF
#9160ClosedDoc2006-10-25wrong documentation
#9376ClosedBug0.7.22006-11-18Error at line 673
#9444Wont fixReq0.7.22006-11-24Sorting by fields not added as column
#9566ClosedReq0.7.22006-12-07Get defined columns
#9578DuplicateBug0.7.22006-12-07setRequestPrefix Broken
#9579ClosedBug0.7.22006-12-07New Warnings Showing up
#9820ClosedBug0.8.02007-01-13Unsupported operand types
#9873ClosedBug2007-01-18Structures_DataGrid FAQ example misleading
#9992ClosedBug0.8.12007-01-31orderBy=0 is lost in _parseHttpRequest()
#9994ClosedReq0.8.12007-01-31Clean URLs and parsing HTTP requests with Seagull
#9997ClosedDoc0.8.12007-02-01API change not mentioned in release notes
#10213ClosedBug0.8.12007-02-28Non-static call in static dataSourceFactory method
#10299BogusBug0.8.12007-03-07Multiple datagrids
#10590ClosedBug0.8.22007-04-02removeColumn may fail in php4
#11398BogusReq0.8.32007-06-21Renaming an existing column fieldName
#12254BogusBug2007-10-16Sorting tables when using Oracle Database does not work
#12885OpenDoc0.9.02008-01-11ordre des parametres inversé
#13025ClosedBug0.9.02008-01-31Quote Identifier incorrect when dealing with table.field
#13575ClosedDoc0.9.02008-04-03setDefaultSort should appear prior to bind in complex example
#14078ClosedBug0.9.02008-06-05PEAR::isError not returned when SQL fails
#14269OpenReqCVS2008-06-30Optimize subquery detection
#14427ClosedBug0.9.02008-07-31Empty SQL-Result + Array_Merge
#14452OpenReq0.9.02008-08-04RowFormtter Callback
#15334BogusBug0.9.02008-12-17count() and "EXTRACT" in query
#15369Wont fixDocCVS2008-12-21Parse errors in examples
#15435OpenReq0.9.02008-12-29Add method SetRequestSuffix()
#15436DuplicateBug0.9.02008-12-29Broken SQL
#15769ClosedBug0.9.02009-01-25setURLFormat method does not return clean query string intermittently
#16002ClosedBug0.9.02009-03-09ORDER clause not stripped in count()
#16325Wont fixReq0.9.02009-06-15convert to be zend framework complient - please!
#16464ClosedBugCVS2009-07-24Unit tests don't run from SVN
#16660BogusBug0.9.02009-09-30I keep getting this error
#16665DuplicateBug0.9.02009-10-01Now I get this error
#16744DuplicateBug0.9.02009-10-27little typo
#16786FeedbackBug0.9.02009-11-13warning message
#17102OpenBugCVS2010-02-14Unit tests broken in SVN
#17731ClosedBugSVN2010-08-17Patch: Avoid deprecations (favoring PCRE)
#18149FeedbackBug0.9.1dev12010-12-27Incorrect type check triggers other bugs
#18259OpenBug0.9.1dev12011-02-10sorting not working
#18952ClosedBug0.9.1dev12011-11-02PHP 5.3 Support
#19026ClosedBugSVN2011-11-14remove error_reporting (for PEAR QA team)
#19251ClosedBug0.9.22012-01-27Missing 'Structures/DataGrid/Exception.php'
#19841OpenBug2013-03-04Deprecated uses of pass-by-reference everywhere