A FEW NOTES ////////////////////////////////
- No web design is needed - simple html on white background will do.
- No admin login is needed; I’ll use PHPMyAdmin to administer.
- Must include security measures to prevent DB injections and other vulnerabilities.
- There will be 4 pages to this site.
PAGE ONE ////////////////////////////////
Home Page - has username & email fields only
- Email field must validate
- Username, Email & auto-generated password saved to the DB.
- A verification email will be sent with auto-generated password.
PAGE TWO ////////////////////////////////
Login Page – page user is redirected to once they fill out the registration on the home page.
PAGE THREE ////////////////////////////////
Edit page – Once the user has logged in, they will be able to edit four things: Templates, Profile, Images, Video
- Edit template - able to select one of any number of templates
- Edit Profile - able to edit name, password, email, bio
- Edit images - For each image user is able to search Flickr for "username and tags" using API - user then selects image they want - saves URL to DB. A comment can also be saved for each picture.
- Edit video - For each video, user can search YouTube with API - user selects video they want - saves video URL to db. A comment can also be saved for each video.
PAGE FOUR ////////////////////////////////
Sample template - simple blank template - 4 images w/ comments & 1 video w/ comments
PROPOSED DB STRUCTURE ////////////////////////////////
USER TABLE /////////////
TEMPLATES TABLE /////////////
filepath - URL to template
FILES TABLE /////////////
filepath - URL to pic or video
filetype - image or video
6 freelancers are bidding on average $201 for this job
I am a senior professional having done a lot of projects in PHP, MySQL Plus I m an expert on SQL injections proof scripts. Pls see my profile at [url removed, login to view] and contact me thru pmb