Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Development Tools

Database creation and searching with filters?

Essentially I'm making a website that will store user filled data from forms into a database. Then users can search the database to find forms similar to theirs.

1) How do I create a data base using PHP or MySQL? (or is there some way to do this with html)

2) How do you set up the databases to be searched by filters or query?

I'm still relatively a beginner with this, so if you could provide a thorough answer that would be appreciated greatly.

Thank you.

3 Answers

James Barnett
James Barnett
39,199 Points

Ram Ada - You should definitely check out the Treehouse database course that Oliver Hough mentioned.

After you've learned about some of the basics of databases, come back here and post any questions you still have.

No offence but, looking at your questions, I would seriously consider reading up on MYSQL basics.

Treehouse has a MYSQL section in development - http://teamtreehouse.com/roadmap that should get you started.

Also there are the official MYSQL docs http://dev.mysql.com/doc/#manual where you can find the manual for all the latest versions of MYSQL.

You mentioned PHP in your post and yes PHP goes together with MYSQL very well and Treehouse offers a great course in PHP.

Hope this gets you on the right track!

Thank you for the input. I wasn't sure where to start (there are so many paths!).