Hi guys I have two questions on folder organisation and one text storage.
FIRST QUESTION
In converting my site to an automated site I want to have a folder where people upload movies and another two where they upload pictures and mp3s. Is it best to have these folders outside the public viewing realm i.e. not in the public html folder.
The idea is that the URL is stored in the database and this is used to make the links dynamically on the viewing page but you can't go directly to the folder and see the pictures and movies from there. I.e. Just like having all your password connections to your database in an out of public folder. Or Is this better or is it better to have a password restricted folder that only the database can access but it is in the public html folder? Also what is the best way I can restrict downloads from these folders except once permission given by the artist
SECOND QUESTION
Currently each artist has a folder in which all their work is stored so when moving over to a database is it possible to use $post and/or $get so that if a person gets an email from an author about that authours work they can have a URl that makes more senses i.e. if someone types qnctv.com/authour_name they get a page with all the authors work. if they type qnctv.com/Show_name they get that show. currently I have got two different types of pages one for movies one for pictures would I have to have a page that looks at what type of show it is or have redirects or should i use alias like I have seen on some forums so the page isn't .com/?=1234&theiklsll etc.
THIRD QUESTION
I have pages with text on them is the text best stored in the database?
see pages like http://www.qnctv.com/cmark/ or a more complicated multipage texts such as http://www.qnctv.com/gary/. should I have a seperate table just for text entries. I was thinking of having seperate tables for pictures, movies and mp3 URLs with author_ID and show_ID foreign keys. The show_ID links to a poster of a show and will allow me to recreate the show index page e.g. http://www.qnctv.com/showsindex.htm
