Textpattern CMS

#1 2009-06-13 17:33:57

mrherman

New Member

Registered: 2009-04-14

Posts: 3

Textpattern and data tables

As a novice, I ask the following —

My intended website will mainly consist of displayed “dynamic” tables. A user will log in and ask for certain data. The data request will then be processed and the resulting table (maybe 5-10 columns, 1 – 100 rows) will be displayed.

Would Textpattern be a good choice for me?

Thanks very much!

#2 2009-06-13 21:41:16

mrdale

Member

From: Walla Walla

Registered: 2004-11-19

Posts: 2,215

Website

Re: Textpattern and data tables

How would these tables be brought in and stored? What kind of data?

#3 2009-06-14 01:02:20

mrherman

New Member

Registered: 2009-04-14

Posts: 3

Re: Textpattern and data tables

Hi, and thanks for the reply.

This would be student performance data from various types of interventions. The db would contain “all data.” A user would, for example, select a school (or schools), the type of assessment, and a few parameters (e.g., sex, ethnicity). A PHP-MySQL statement would be run, and the results displayed using an (I guess) html table. The table would vary in the number of rows and columns, depending on what was selected by the user.

Thanks!

#4 2009-06-14 01:49:56

mrdale

Member

From: Walla Walla

Registered: 2004-11-19

Posts: 2,215

Website

Re: Textpattern and data tables

hrm. out of the box I would say Textpattern is not ideally suited to this kind because of it’s lack for true custom content types.You could implement a TXP version by treating each record as an article to which you would add a busload of custom fields. To simplify and sanitize input out provide meaningful and dynamic search results glz_custom_fields would be an absolute necessity.

Drupal + CCK would probably work better. Anyone else wanna chime in?

#5 2009-06-14 03:18:26

hcgtv

Plugin Author

From: Key Largo, Florida

Registered: 2005-11-29

Posts: 2,722

Website

Re: Textpattern and data tables

SQLView is a good starting point.

---

We Love TXP . TXP Themes . TXP Tags . TXP Planet . TXP Make

#6 2009-06-14 11:35:52

mrherman

New Member

Registered: 2009-04-14

Posts: 3

Re: Textpattern and data tables

Thanks mrdale and hegtv —

I checked out and downloaded SQLView and I believe that it fits my description of what I want to do at this point. I’m sure that, with some more sophistication on my part, I’ll be back to TXP and bug you folks again.

Much appreciation for your help!