Secukuprasa.com, our pioneering Recipe Book project set to launch on a website, directly tackles prevalent challenges faced by culinary enthusiasts or just our domestic engineer, our mom and wife, as they are seeking a cohesive and collaborative cooking experience. Recognising the challenges people face with scattered information on existing platforms, our strong database system makes it easy for users to sign up and log in smoothly. This helps solve the common problems associated with navigating the disconnected world of culinary resources. Secukuprasa.com strives to mitigate the frustration associated with scattered or incomplete culinary resources. Think of the Categories table as a helpful guide on our website. It makes it easy for users to explore different culinary styles and find what users are looking for, creating a smooth and enjoyable browsing experience. Furthermore, the Ratings and Comments tables serve as a testament to our commitment to fostering user engagement and encouraging subjective evaluations, adding a competitive edge by providing a comprehensive feedback system. Through our innovative website, Secukuprasa.com aims to transform the traditional cookbook experience, making cooking a shared and enjoyable journey. We're redefining how people explore culinary delights, bringing them together for a collaborative and even competitive cooking adventure. The project demonstrates proficiency in database design, structured query language (SQL), and web-database integration using a local development environment. 

Technical Scope & Architecture 

The project utilises a multi-tiered architecture, managed through a local host stack, ensuring data integrity and accessibility.

Development Environment: The entire project was integrated and hosted locally using XAMPP. This package provided the necessary components:

• • • Apache (Web Server)

    • MySQL (Database Management System)

    • PHPMyAdmin (Server-side scripting)

Database Management System (DBMS): MySQL was selected for its robust performance, scalability, and seamless integration within the XAMPP stack.

Database Design: Implemented a normalised database structure, utilising Entity-Relationship (ER) Diagrams and defining clear relationships between tables.

Backend Integration: The database communicates with the web application primarily via PHPMyAdmin. This layer handles user requests, data validation, and secure execution of SQL queries, all running within the local XAMPP environment.

Frontend Interface: The user-facing interface was built using standard web technologies (HTML, CSS, JavaScript), allowing users to interact with the database through CRUD (Create, Read, Update, Delete) operations.

check my code and read.me on github!

https://github.com/thefaizholic/sql_recipebooks