Analysis and Development of a Flower Ordering System Website

This project details the development of a flower ordering system website. The solution covers the installation of Xampp, which includes PHP and MySQL for database management. The code utilizes HTML, CSS, and JavaScript for the front-end design and user interface, with CSS used for styling and JavaScript for animations. The database is created in MySQL, with tables to support business operations, and PHP scripts are used for database connections, data insertion, and retrieval. The website incorporates user sessions, login functionality, and logout features. The project also includes pages for displaying flower items, handling online payments (MasterCard), order details, and contact information. Finally, the solution provides recommendations for improving the website, such as encrypting passwords, validating data, merging tables to reduce redundancy, and streamlining code for better efficiency. The project also addresses specific questions about changing the login page, allowing different user views, implementing limited access, and supporting various payment methods.

Code functionality and description
Name
Institution
Professor
Course
Date

Website creation involved preparation of the development environment and a series of
steps to consolidate the entire project. Xampp was installed to our personal computers and a code
editor notepad++. Xampp has both PHP interpreter and MYSQL database to support database
development. CSS was used to style and position the both JavaScript and HTML elements. The
code explanation would be done in blocks and about the functionality of each piece of code.
The database was created in MYSQL which involved creating a database named "flower_order”,
followed by tables required to support business operations. The database was created through
MYSQL in PhpMyAdmin from Xampp. The database is connected to a local host database
server to support local testing of the website. The codes in the database script file are used for
creating tables and inserting data into the tables. A select query is created in PHP scripting to
facilitate data insert and retrieval into and from the database tables respectively.
The explanation of the code starts with the connection.php which connects the database and the
website. The connection makes it possible to send and retrieve data to and from the database.
The index page starts with user session creation code which is used to assign any user a session
to the website. The next piece of code is CSS used for styling HTML elements and images such
as links and buttons. Links are used for navigation within the website. Notably, it has JavaScript
code which is used to scroll and animate images horizontally across the page.

Both session_u.php and session_m.php are used to create session and login users to the
website. The login_u.php and login_m.php are used to provide users with active session into the
website. The code checks if the user exists in the database, selects the user and validates the
credentials provided to the website. The next page logout_u.php and logout_m.php were used to
destroy sessions when a user leaves the website.

The flowerlist.php page opens up with a session creation code, followed by animation
CSS code, and bootstrap links which styles and defines the animation process. The page also has
an animation JavaScript code which moves images across the page.
The onlinepay.php page is used for payment through MasterCard and has JavaScript code
to animate the images too. The COD.php code is used to display the payment success message.
delete_flower.php and edit_flower.php pages have code to delete and edit flower items from the
code respectively. Contactus.php code is used to create an interface of presenting issues and
clarifications. Finally, view_order_details code is used to select all orders placed by the
customers.

The first change that can be done in the database is to encrypt the password column to
make sure user passwords are not plaintext. Other columns in the customer can be validated from
the database level not to accept null values. Username and emails should be enforced to make
sure they are unique to each customer. In the manager and customers table, the two can be
merged into one table to avoid redundancy. In the order table, order id and flower id should be
unique. Finally, the code is very redundancy and need to be cleaned. Similar block of codes is
duplicated in different pages, which can be achieved by creating a block of code and call it when
required. All the website pages can be compressed into about five webpages if good coding
practices are followed.
How can a user change system login page without interfering with functionality of the page?
Is it possible for users’ different website users to have different view while on the same page?
Do we have some users with limited access capability when accessing the website?
Do you have different payment methods to cater for all website users?