I'm developing a small, web-based music sharing application. I used to create static HTML contents. But now, I need a dynamic site that retrieve information from databases (also write data to database). As a beginner in PHP and MySQL, I hope someone from here can help me out..
Here is the scenario:
Four kind of users; Guest, Contributor, Registered User, Administrator
GUEST - browse, search file and download certain song/movies (limited functionality)
CONTRIBUTOR - upload files (song, video clips, image) and having full access to contents
REGISTERED USER - full access to contents and features
ADMINISTRATOR - Super User (maintain the website and database)
The last three users' details are stored in database...
each video(music clips), audio(song) and photos details are stored in a separate table. Instead of saving media files as BLOB type, I used file path to point to the exact file location in the server directories (for performance reason according to my reading & net research). What is the best way to upload a file to a predefined server directory??? I know PHP can handle this.. but is there any 3rd party software that can perform the same action (i mean something more GUI)??
This user have their own page within the domain (for displaying their profile- also stored in a table). We want to provide them choices of template so that can choose and customize their page. I guess this is the big challenge. Any idea??
I also want to have 'rate-this-song' feature. I have created a table to store the rating value submitted by user and total count (plus the associated field such as filename/ID). These two values will be dynamically updated when anyone rate the song (to avoid abuse, Im making use of session variable so that a particular user can only rate a file once). What is the best way to store all these rating statistics?? should I create one table 'rating' or 3 since I have Audio, video and image?? What's the best way to implement this function??
Another table to store all the submitted forums. This can only be accessed by registered user and admin. So far Im planning to use PHP to retrieve and write data to the database... any suggestion??
As the admin need to monitor the site based on feedback form submitted by visitors, so I have table to store the information. Is this common???
For easier administration...Im planning to create interface for administrator to maintain the database (add/update/delete contents).. This of course can be achieved thru PHP/HTML.. is there any other "GUI" way to do it?? perhaps cPanel??
Thanks for helping me out... truely appreciate it!