Photo Gallery -- 2
Budget: $250 – $750 USD
Programming language = PHP with supporting scripts MYSQL, HTML, CSS, JAVA, AJAX. Compatible with PHP 8.1 and MYSQL 8.
Project description: Create a photo gallery for up to 12 images with LOAD, ADD, EDIT, DELETE, SORT and SAVE functions.
LOAD: The script will connect to a MYSQL database and load an existing image set into the photo gallery by query of the table (images) using a key field value (ID) passed in the URL. Example: localhost/photogallery.php?ID=126593
ADD: A function that allows the user to browse a computer file system and upload images of type .jpg, .jpeg, or .png
EDIT: A function that allows the user to change the description of the image.
DELETE: A function that allows the user to delete unwanted images from the photo gallery, computer file system and its reference in the mysql database.
SORT: A function that allows the user to change the display order of the images in the photo gallery and save the image references in the database accordingly.
SAVE: A function that allows the user to save the photo gallery to the database with a unique ID number generated by the database.
Each image will require resizing to 640X480
Each image will require the creation of a 150X150 thumbnail.
Each image and its thumbnail will require the data and time stamp to be appended to the name. Example: bestpicture-20230211-110033.jpg
The image references to be stored in a mysql database with the following field names.
ID, picture_1, desc_1, picture_2, desc_2, picture_3, desc_3, picture_4, desc_4, picture_5, desc_5, picture_6, desc_6, picture_7, desc_7, picture_8, desc_9, picture_9, desc_9, picture_10, desc_10, picture_11, desc_11, picture_12, desc_12
The images are to be stored in a file directories based on the date stamp and the thumbnail stored in a subdirectory (thumbnail).
EXAMPLE (image): localhost/files-2023/bestpicture-20230211-110033.jpg
EXAMPLE (thumbnail): localhost/files-2023/thumbnail/bestpicture-20230211-110033.jpg
NOTE: If the file folder is not be found on the disk then the program will create it.
Project description: Create a photo gallery for up to 12 images with LOAD, ADD, EDIT, DELETE, SORT and SAVE functions.
LOAD: The script will connect to a MYSQL database and load an existing image set into the photo gallery by query of the table (images) using a key field value (ID) passed in the URL. Example: localhost/photogallery.php?ID=126593
ADD: A function that allows the user to browse a computer file system and upload images of type .jpg, .jpeg, or .png
EDIT: A function that allows the user to change the description of the image.
DELETE: A function that allows the user to delete unwanted images from the photo gallery, computer file system and its reference in the mysql database.
SORT: A function that allows the user to change the display order of the images in the photo gallery and save the image references in the database accordingly.
SAVE: A function that allows the user to save the photo gallery to the database with a unique ID number generated by the database.
Each image will require resizing to 640X480
Each image will require the creation of a 150X150 thumbnail.
Each image and its thumbnail will require the data and time stamp to be appended to the name. Example: bestpicture-20230211-110033.jpg
The image references to be stored in a mysql database with the following field names.
ID, picture_1, desc_1, picture_2, desc_2, picture_3, desc_3, picture_4, desc_4, picture_5, desc_5, picture_6, desc_6, picture_7, desc_7, picture_8, desc_9, picture_9, desc_9, picture_10, desc_10, picture_11, desc_11, picture_12, desc_12
The images are to be stored in a file directories based on the date stamp and the thumbnail stored in a subdirectory (thumbnail).
EXAMPLE (image): localhost/files-2023/bestpicture-20230211-110033.jpg
EXAMPLE (thumbnail): localhost/files-2023/thumbnail/bestpicture-20230211-110033.jpg
NOTE: If the file folder is not be found on the disk then the program will create it.