I want to prepare a simple script for media management (video files and pictures).
Script should display the form:
1. File selection field (accepted formats: jpg, jpeg, .png, bmp, gif, mp4, avi, ogg, flv, webm) [required field]
2. Start date (YYYY-MM-DD HH:MM:SS) [optional]
3. End date (YYYY-MM-DD HH:MM:SS) [optional]
Sending a file should create record for it in the database and file should be uploaded to the "./media" directory.
Suggested columns in the database:
1. File name + extension
2. Start date [default: null]
3. End date [default: null]
4. Status (on / off) [default: 1]
5. Position [default: max + 1]
Under the form there should be a table with currently existing files - sorted by the column "position" in the database.
HTML table columns:
• File name + extension
• Start date
• End date
• Status (on / off)
Actions column should include the following functionalities:
• Status switch (on / off) for current file
• Deletion of current file (from database and from ./media directory)
It should be also possible to change the order of the records in HTML table (+ saving new position in database) using "drag'n drop" feature.
Destination server specification:
• MySQL 5.7.21-20
• PHP 5.6
• Please use english in your code (variables, functions, comments etc).
17 freelancers are bidding on average $43 for this job
Hi, I have reviewed your job post carefully, your job is very matched to me. I have many good skills and experiences about jquey, mysql, php and etc. so, I can do your job perfectly. Best regards