Kirstyn HowellHouseplant Catalogue
Project Scope
PHP/MySQL Catalogue: Add, edit, delete and filter functionality of a plant catalogue with Bootstrap styling. Utilizing PHP, MySQL, queries, database creation/setup, filtering, login sessions, add, edit and delete validation to create a interactable catalogue for houseplants.
This is a functionlity first project, primarily focused on the use of PHP and MySQL to create a catalogue of various housplants. In which the admin can add their own images and information for a plant, add it into the database and have all the plants displayed together in a card format. There is also a session based login function where a user that is not logged in can not add, edit or delete from the database, with security against searching the url to gain access to these features.
To view the crud application features enter username: admin and password: Password1
Functionality
- 1. Random plant generator on home page
- 2. Search input on home page
- 3. Filter by categories
- 4. Detailed view/page for each plants information
- 5. Login area
- 6. Add, edit, delete functionality for admins
Homepage: Random Plant and Search
The homepage has a few paragraphs detailing houseplant care and the purpose of the filter categories. There is also a random plant card generator that changes every refresh of the page as well as a search input to look for plants in the database.
Filter Buttons
The filter buttons are a functional way for users to sort through the houseplant catalogue if they are looking for certain plants with specific characteristics. For example a tropical plant or a plant that is non-toxic to humans or animals.
Plant Details
This website also has a function that lists all the information for one plant on a single page, which uses PHP to collect and display the information for a specific plant by name using individual.php?plant_name=Calathea+Lancifolia when the "See Plant Details" button is clicked.
Login/ Logout
This is the basic login page that validates for the designated username and password.
Add, Edit and Delete Functions
Below are the three admin functionalities for the site. They are the add, edit and delete pages with validation to ensure that no entry has missing data and user friendly confirmations to prevent mistakes in editing or deleting from the catalogue. Each page is secured with login sessions so that no one can force entry to the admin area with the right url.
