🧪 Node.js, Express, MySQL, EJS + Bootstrap + EchoAPI Test Project

A beginner-friendly CRUD web application using Node.js, Express, MySQL, EJS, and Bootstrap — includes EchoAPI integration for testing.

---

📦 Features

✨ Fully functional CRUD (Create, Read, Update, Delete) operations
🎨 Responsive UI built with Bootstrap
🗃️ Predefined SQL schema and sample data for quick setup
🧪 EchoAPI test link for verifying backend API endpoints

---

📂 Project Structure

sql-express-ejs-nodejs/
├── controllers/        # Route logic for users, posts, categories
├── models/             # Database interaction logic
├── routes/             # API and web routes
├── views/              # EJS templates
├── public/             # Static files (CSS, JS, images)
├── sql_express.sql     # Database schema and sample data
└── echo-api-test-file-link.txt  # API test URL

---

🚀 Getting Started

1️⃣ Clone the Repository

💡 Note: Make sure XAMPP is running with Apache and MySQL started in the background.

git clone https://github.com/TinzarTun/sql-express-ejs-nodejs.git
cd sql-express-ejs-nodejs

2️⃣ Install Dependencies

npm install

3️⃣ Start the Server (Dev Mode)

npm run dev

---

🗄️ Database Setup

1. Open phpMyAdmin via XAMPP
2. Create a database named: sql_express
3. Import the sql_express.sql file from the root folder
4. Done ✅

---

🔗 API Testing with EchoAPI

• Open the file: echo-api-test-file-link.txt
• Copy the test link and open it in your browser
• Modify and send test requests to simulate CRUD operations