We need a script that do
- take every day the YOUTUBE categories (most viewed/most popular/most discussed/recent upload/ and some other similar) 50 videos of each category or more
- donwload all new (not dowloaded before) that videos as .mp4 360p and the info of the video (name-catgory-some other) + thumbnail
- put all downloaded file on a folder (or folder tree) and using apache put them avilable for downloading from a browser
- make a simple mysql database with the mp4 file + source youtube link + youtube metadata + thumbnail + date/time of download.
- some kind of configuration file to change frecuency of download, quantity of videos per category per dowload, which categories to download.
- after testing if everything works as we describe, upload the script to a server.
-We will provide a fresh Debian/CentOS LAMP installation, other required dependencies should be installed by yourself.
Please contact if you have some questions, as we all know some times youtube policies will change a we will need some adjustments to get the mp4 links so we need a well documented code.
Let me try to understand your requirement more please correct me if i am wrong, so you are trying to have the youtube featured videos in a MySQL server and upload them in your server and get the coding standard documented.
As my expertise is on MySQL, I should be handle this req, using quires and can provide the entire documentation for this project.
I have 4 years experience working on PHP&MySQL and understand the challenge required to download the youtube to the format you reguested.
Will be ready to start work anytime.