Title Slide: (Speaker: Tasfia) "Good [morning/afternoon], everyone.
We are
delighted to present our team project titled NoteNest – a simple, secure, and
effective Notes App built using PHP and MySQL. Our team consists of Syeda
Tasfia Tabassum, Anisa Nowrin, Mohammad Hosainool Alam Ridoy, and
Mizanur Rahman. This project has been developed and submitted under the
guidance of our respected teacher, Ms. Tisha Saha, Lecturer, Department of CSE,
BGC Trust University Bangladesh."
Slide 2 – Introduction: (Speaker: Tasfia) "Let me introduce you to the purpose of
our project. In this digital age, jotting down important notes online has become a
necessity. Our application aims to provide a lightweight and user-friendly web-
based solution where users can register, log in, and manage their personal notes
with ease. It eliminates the hassle of managing notes manually and brings
everything into a digital platform, available anytime and anywhere."
Slide 3 – Key Features: (Speaker: Anisa) "Our Notes App includes several key
features:
• First, user authentication is implemented using PHP sessions to ensure
secure logins.
• Users can perform complete CRUD operations: they can create new notes,
read their saved ones, edit them as needed, and delete them.
• The system is personalized. Each user can only see their own notes,
ensuring privacy.
• Lastly, the app is styled with responsive CSS to offer a clean, organized,
and accessible user interface across devices."
Slide 4 – Technologies Used: (Speaker: Anisa) "We’ve built this application
using some common yet powerful technologies:
• For the frontend, we used HTML and CSS to construct the layout and
visual styling.
• PHP acts as our backend language, handling server-side logic, user
sessions, and form processing.
• MySQL is used to store all user credentials and note data securely.
• The entire application was developed and tested locally using XAMPP and
phpMyAdmin for database operations."
Slide 5 – Database Design: (Speaker: Anisa) "Now, let's take a quick look at our
database structure. The app uses a simple relational database:
• We have a 'users' table, which stores user IDs, usernames, hashed
passwords, and the time of registration.
• The 'notes' table contains note IDs, the ID of the user who owns each note,
the note title, content, and a timestamp.
• The relationship between these two tables is one-to-many: one user can
have many notes. This design ensures efficient storage and easy retrieval of
data."
Slide 6 – Application Workflow: (Speaker: Hridoy) "Our application's workflow
is straightforward and user-centric:
• A user starts by registering with a unique username and password.
• Once logged in, they are taken to a dashboard that displays their personal
notes.
• From the dashboard, they can add a new note using a simple form, edit
existing notes, or delete any note they no longer need.
• The system ensures that no user can access another user's data, maintaining
personal data security."
Slide 7 – Code Highlights: (Speaker: Hridoy) "Here are a few code-level
highlights:
• The db.php file acts as a centralized database connection handler. This
helps in maintaining code modularity.
• We use session_start() on top of our PHP pages to manage user sessions
securely.
• Passwords are stored securely using PHP’s password_hash() function and
verified with password_verify().
• Although currently using basic SQL queries, we understand the importance
of SQL injection prevention and plan to implement prepared statements
soon."
Slides 8–11 – Screenshots & Demo: (Speaker: Mizan) "Now let’s walk you
through a visual demonstration of our app:
• The registration page provides a simple form to create an account.
• The login page authenticates users using sessions.
• The dashboard is the heart of the app – it displays all the user's notes and
provides edit/delete functionality.
• The Add Note page offers a clean interface to write and save new notes
quickly and efficiently."
Slide 12 – Challenges Faced: (Speaker: Mizan) "No project comes without
challenges. Here are a few we faced:
• Session handling was tricky at first. We had to ensure that only logged-in
users could access note-related pages.
• Designing a clean, consistent UI was another challenge, especially while
making it responsive.
• Ensuring password security was a top priority. We made sure not to store
any passwords in plain text and used PHP’s built-in hashing functions."
Slide 13 – Future Improvements: (Speaker: Mizan) "Though our app is
functional, we have a few enhancements planned for the future:
• Adding a password reset feature for user convenience.
• Replacing direct SQL queries with prepared statements for improved
security.
• Implementing search and tags to categorize notes more efficiently.
• And upgrading our UI using modern frameworks for a more polished,
mobile-friendly experience."
Slide 14 – Final Slide: (Speaker: Tasfia) "Thank you so much for your attention.
We’re proud to have built NoteNest as a team effort. Once again, we are Syeda
Tasfia Tabassum, Anisa Nowrin, Mohammad Hosainool Alam Ridoy, and
Mizanur Rahman. We hope you enjoyed our presentation and we’re happy to
answer any questions you may have."
End of Script.
