A 4 page Youtube & Flickr API app using PHP 4 & MySQL
$100-300 USD
Paid on delivery
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 /////////////
USERID
templateid
name
username
password
bio
TEMPLATES TABLE /////////////
ID
name
filepath - URL to template
FILES TABLE /////////////
ID
userid
filepath - URL to pic or video
filetype - image or video
comment
Project ID: #93493