/    Sign up×
Community /Pin to ProfileBookmark

Databases

Copy linkTweet thisAlerts:
Aug 25.2011

I have to create a database that is online, so people online can view it and the headers of the database have to be able to sort the data in that column into ascending or descending order (so I guess that’s javascript?)
also there needs to be drop down menus which would then filter the data in the database.

For example, if there was a database of farm animals and the first column header was “name”, 2nd was “age” and 3rd was “type of animal”
if you chose to view all the data (therefore meaning you haven’t chosen to filter anything) it would come up with a list of names of the farm animals, the ages of them and what kind of animal they are.

then if someone clicked on “age” it would sort the list by the youngest animals first ascending to the oldest.

If someone were to go to the drop down menu and choose to filter it by “duck” then it would get rid of all the other animals being shown and only show the animals with “type of animal” listing: duck

not entirely sure on what languages to use or whether Clientside or server side, thats where I need help!

if you could help me with this I would really appreciate it!

Thank you very much,

Aaron

to post a comment
HTML

3 Comments(s) ↴

Copy linkTweet thisAlerts:
@cbVisionAug 25.2011 — You need to use client and server side languages.

I recommend HTML, JavaScript (Ajax), PHP, and MySQL combo.

You use PHP to communicate with the MySQL database and then output the results into HTML.
Copy linkTweet thisAlerts:
@DanInMAAug 25.2011 — yup. to get you started, this is a jquery plugin I use often for sorting the results once you've gotten them from client side. it's pretty easy to use, just make sure your tables have a <tbody> and <thead> section.

http://tablesorter.com/docs/
Copy linkTweet thisAlerts:
@christhAug 25.2011 — I use http://www.datatables.net/examples/ - easy to set up and a host of plugins and well documented
×

Success!

Help @GallifreyanDude spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 — BETA 5.16,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @AriseFacilitySolutions09,
tipped: article
amount: 1000 SATS,

tipper: @Yussuf4331,
tipped: article
amount: 1000 SATS,

tipper: @darkwebsites540,
tipped: article
amount: 10 SATS,
)...