Database PHP
 

When I try to Google for anything, I get MySQL info, so let's give it a shot here.

I want (a guide to creating) a small searchable and sortable database with a password protected way to add new things. So let's say I log in, add some info (name x, year y, genre z) and at the frontpage I want the ability to sort by name, year and genre and search through the existing records. I also want to make it clickable, so it'll take you to a page with more info (kind of like the memberlist of GFF, which you can sort and search through and then go to a profile).

Can anyone point me in the right direction or is anyone willing to code it for me?

Thanks in advance.

From my limited understanding of web architecture, a MySQL database is actually probably what you want, and you'll just use a PHP page to interface with it via SQL commands. A lot of web hosts support both MySQL and PHP, or if you actually have your own web server you can set them up yourself. A database frontend should be pretty simple to program, and I'm sure you can find a PHP login script with a couple minutes of searching.

My favorite site for web-related development is W3Schools Online Web Tutorials. They have tutorials for both SQL and PHP. MySQL.com also has a section for developing with PHP at MySQL :: MySQL 5.0 Reference Manual :: 26.3 MySQL PHP API.

MySQL qould be a good way to go with that. A lot of MySQL set ups also come with phpMyAdmin, which is a PHP web-based interface to a MySQL database and would provide a searchable, sortable way of accessing data.

[ phpMyAdmin ]

But the thing is, is that I want visitors to search through it.