This project is an enhanced CRUD (Create, Read, Update, Delete) web application, evolved from a basic version inspired by FaztCode's tutorial. It demonstrates CRUD operations with a user-friendly interface, using Node.js and MySQL. Significant improvements include real-time filtering through the database and an update from CommonJS to ES6 module syntax, reflecting modern JavaScript practices.
- Node.js
- MySQL
- Clone the repository:
git clone [repository link] - Navigate to the project directory:
cd [project name] - Install the dependencies:
npm install - Set up your MySQL database and update the connection settings in
[database/db.sql] - Start the server:
npm start - Open your browser and go to
http://localhost:3000/
- Create new customer records with name, email, and phone fields.
- Read and view existing customer records in a dynamic table.
- Update customer details through an intuitive interface.
- Delete customer records securely.
- Filter customer records in real-time without page reloads.
- EJS for templating
- Express as the web framework
- Express-myconnection for database interaction
- Morgan for HTTP request logging
- MySQL for database management
- Nodemon for automatic server restarts during development
Contributions are welcome! Please follow these steps to contribute:
- Fork the repository
- Create a new branch (
git checkout -b feature/YourFeature) - Make your changes
- Commit your changes (
git commit -am 'Add some feature') - Push to the branch (
git push origin feature/YourFeature) - Open a pull request
This project is open-sourced under the MIT license.
- Andrés Jaramillo - Significant enhancements and current maintenance
- Special thanks to FaztCode for the original tutorial, which served as the starting point for this project.
For queries or collaborations, feel free to connect with me on LinkedIn or my email [email protected].