Existing PHP/MySQL admin update for managing VERY basic projects each with multiple galleries – Upwork

We are building a new version of a site with an existing custom admin. We need to have new admin pages added to manage "projects", and each project has multiple galleries that can be added and deleted.

We have been working with an existing set of admin files (utilizing bootstrap styling) for multiple projects like this one, so we have multiple examples of these admins, each with a variety of customized pages for different purposes. We have MANY gallery and project admins, but this will be the first, we believe, where each project has the option to have multiple galleries associated with them.  TO CLARIFY: we have existing php files that nearly match what this admin needs to do, so those existing files can be updated, rather than the developer needing to build these from scratch.

New in this request is to track the width/height ratio of the images that are uploaded (AS they are uploaded) so we can use those numbers on the front end with a customized "carousel" that utilizes image sizes in its display WITHOUT having to grab those sizes on every download of the images.

BONUS would be a tool that checks all the images in the table and re-fills the w/h numbers for all of them.

Below is the basic table structure in place for this task. We would like an estimate of total hours and the hourly rate.

PROJECT ADMIN
• LOCATION : VARCHAR
• TYPE : VARCHAR
• ARCHITECT: VARCHAR
• DESCRIPTION : TEXT
• MAIN IMAGE : VARCHAR
• GALLERIES (PLURAL) (galleries are set up as carousels on the front end of the site)
o   GALLERY NAME : VARCHAR
o   IMAGES
     IMAGE : VARCHAR
     ALT (defaults to combo of location, type, & architect) : VARCHAR
NEW: WE WANT TO CAPTURE THE RATIO OF WIDTH TO HEIGHT ON THE IMAGES AS THEY ARE UPLOADED*
     DRAG & DROP ORDER : INT
     W/H RATIO

Hourly Range: $15.00-$35.00

Posted On: February 22, 2022 17:04 UTC
Category: Back-End Development
Skills:PHP, MySQL, JavaScript, Web Development, MySQL Programming, Custom PHP

Country: United States

click to apply

Generated by Feedzy