How can I create a nice web page with this functionality?
I need to create a nice webpage where a list of First name, Last Name, State and ZIP codes are displayed.
By default, the list is sorted by Last Name. But clicking on the corresponding column, it should be possible to sort by Last Name, State name or ZIP code.
I understand there is a database at the background, or a table.
I need this to have a nice layout in the webpage.
Any suggestions? Which technology would you use, how would you do it?
Thanks!
| Print article | This entry was posted by mosotech on July 10, 2010 at 8:11 am, and is filed under Web Technology. Follow any responses to this post through RSS 2.0. You can leave a response or trackback from your own site. |


about 1 year ago
To allow sorting at the front end then you have to use JavaScript. Use a framework like JQuery or Prototype.
To pull data from a database to show at the front end then you’ll need some kind of web programming language. You can use Java, C#, php, python, ruby, etc.
To have a nice page layout you’re going to need mad design skills with CSS or Cascading Style Sheets with xHTML.
Try reading this blog for a Java solution:
http://killertilapia.blogspot.com/2009/10/being-weavermy-tapestry-course-for.html
about 1 year ago
that sounds like you should use php(interfaces with your database. there are other scripting languages you can use but php is the most widely used) and html. to make the dynamic update of the data by clicking a column you would need ajax as a perfect solution because you wouldn’t need to refresh the page but you could do it with php with page refreshes and using post and get to pass variables to update the query to the database. That’s a lot of stuff to learn so you might be better off hiring a developer if you have the money or else get some good books on the above subjects.
and css is the language of layouts and design which is essential to a good website.
more info @ http://csszengarden.com/
about 1 year ago
Here’s what would I do:
MySQL for my Database
PHP for scripting ( getting the data from database)
CSS for designing the tables
JQuery for additional functionality (sorting of tables)
One thing I like using the “technology” above is that there are hundreds of tutorials or available scripts on the Internet that you can easily use with your web project.