JamesConnor

On my website I have a video page like youtube, I want to store data when a user visits the video page. The data I want to store is videoID, IP, referrer and date. My concern is that I am not sure of the best way to store this data. One option I have thought about is MySQL and the other is in a CSV file. If I have lots of data which option would be the quickest to read the data from? I can think about pros and cons for both options but what is your opinion? (Keeping in mind growth of the website). Also, are there any other viable options I have not thought about?

Whilst developing my website I use mysql_error() to display errors so I know how to fix them. My question is... when the website goes live, how should I handle the errors, because I do not want the user to see the errors but instead see a user friendly message like "Oops, something went wrong".

So I want my url to look like this... www.website.com/home&foo=bar&hello=world I only want the first get parameter to change the actual "behind the scenes" url is this... www.website.com/index.php?page=home&foo=bar&hello=world All tutorials I find change all of the parameters. Any help much appreciated!