Selecting smarty sortable MySQL table

Asked By Donal Bambie 0 points N/A Posted on - 09/17/2012

I need automatically importing form data into MYSQL and MYSQL without SQL to access to MySQL servers. Have you experience in using of smartly sortable MySQL table and which tool is the best one?

• Status: Open
• Question Views: 1143
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Server Software

Answered By JOY Schilling 5 points N/A #147790

Selecting smarty sortable MySQL table

 

Hi

 

If you're trying to sort data it's coming from a database, not hard coded information Would be best to do the sorting in your DB & just pass that to Smarty, rendering it with foreach, section, etc. 

If you don't want to go with PEAR, there's a very good PHP MySQL class called "ezSQL" http://justinvincent.com/ezsql which makes it very easy to use databases with PHP (it actually supports many RDBM's such as Postgre, Oracle, MS-SQL, etc.).

 

https://ccm.net/download/download-21607-pinnacle-studio-plus shows how to use ezSQL with Smarty. The ezSQL author also has a php class for pagination, which has been slightly extended by the author on the learnwake site. 

 

However, if your data is hard-coded, again it would be better to present the sorted data to Smarty. In this case you'd want to check out PHP's many sorting features.

About JOY Schilling

Questions
1

Answers
100

Best Answers
28

• Vote Up 0 Vote Down

• Posted on - 10/30/2012
• Question Category: Server Software