Are there add-ons to help display records retrieved from a MySQL query.
Permalink 1 user found helpful
I'm just getting started investigating Concrete5 or any kind of CMS. But I haven't been able to get Concrete5 installed on a subdomain of mine on Dreamhost so I haven't been able to play with it. They tell me my server is too slow to finish the install and have offered to move my site.
Are there native features or add-ons in concrete5 that would help me display records retrieved from a MySQL query into nicely formated records? I struggled for years to get mine to work with DIY CSS and PHP, then IE8 came along and it doesn't display my tables nicely again. http://www.ykfp.org/php/lyletrap/tabletotalscss2012.php...
Are there native features or add-ons in concrete5 that would help me display records retrieved from a MySQL query into nicely formated records? I struggled for years to get mine to work with DIY CSS and PHP, then IE8 came along and it doesn't display my tables nicely again. http://www.ykfp.org/php/lyletrap/tabletotalscss2012.php...
It all depends what you are querying. If you are collecting data with the core forms block or a forms addon, there are several addons that can report results as tables or charts. Some of the forms addons have this built in. Others have it as an extra.
Another approach (currently in the PRB) is a forms extension for my Magic Data, so that form results can be pulled into any page. The interface is designed to be extendible to pull in data from any table, not just form results. This is more suited to ad-hoc items of data than bulk tabular reporting.
If you want to do a bit more php, the c5 core provides an extensible data list model that is used for many of the existing dashboard lists and had been extended by various developers to list all sorts of data.
Another approach (currently in the PRB) is a forms extension for my Magic Data, so that form results can be pulled into any page. The interface is designed to be extendible to pull in data from any table, not just form results. This is more suited to ad-hoc items of data than bulk tabular reporting.
If you want to do a bit more php, the c5 core provides an extensible data list model that is used for many of the existing dashboard lists and had been extended by various developers to list all sorts of data.
The problem at Dreamhost was they had me hosted on an older slow host. I kept increasing the php execution time, but couldn't improve it enough. They moved my site to a newer host this week and yesterday the install went without a problem. Now I have a sandbox to try some of this stuff.
The whole process for my tables is that I have technicians at a fish passage facility entering their counts into MS Access tables that are linked by OBDC to MySQL tables at my web host. When a site user accesses my page, php executes a MySQL statement to retrieve the most current set of records for a particular year. The the php script and CSS formats a table with a little slider on the right so the user can scroll if the number of records is bigger than will fit into the container, and also adds up column totals, and adds the totals to the bottom.
My next step might be to allow user input in a form to request certain dates, species and locations, similar tohttp://www.cbr.washington.edu/dart/query/adult_daily... However, I haven't seen CMS sites that do this kind of thing.
The whole process for my tables is that I have technicians at a fish passage facility entering their counts into MS Access tables that are linked by OBDC to MySQL tables at my web host. When a site user accesses my page, php executes a MySQL statement to retrieve the most current set of records for a particular year. The the php script and CSS formats a table with a little slider on the right so the user can scroll if the number of records is bigger than will fit into the container, and also adds up column totals, and adds the totals to the bottom.
My next step might be to allow user input in a form to request certain dates, species and locations, similar tohttp://www.cbr.washington.edu/dart/query/adult_daily... However, I haven't seen CMS sites that do this kind of thing.
Its probably easiest to take the guts of your current code and put it into a concrete5 single page.
So it seems like the answer is no.
If I take my code and stick it in a single page, I still have my same crappy code.
If I take my code and stick it in a single page, I still have my same crappy code.
Someone else might know better than me about what addons would be useful for that sort of table data. I mean a lot of the display could be done with your theme, it's more of a question of how to store and retrieve it.