sql_editpage

A simple Node.js + Express + MySQL CRUD application built to understand backend workflows, database operations, and server-side rendering using EJS templates.

This project focuses on implementing core CRUD functionality with clean routing and database integration.

---

🚀 Features

• Create, Read, Update, and Delete user records
• MySQL database integration
• Server-side rendering with EJS
• Auto-generate test users using Faker.js
• Basic routing and form handling
• Organized project structure

---

🛠️ Tech Stack

• Backend: Node.js, Express.js
• Database: MySQL
• Templating Engine: EJS
• Other Tools: Faker.js

---

📂 Project Purpose

This project was built as a learning exercise to:

• Understand how backend servers interact with databases
• Practice SQL queries and CRUD operations
• Learn Express routing and middleware
• Work with templating engines for dynamic HTML

---

⚙️ Getting Started

Prerequisites

• Node.js installed
• MySQL installed and running

Installation

git clone https://github.com/sumayyatabasum/sql_editpage.git
cd sql_editpage
npm install

Database Setup

• Create a MySQL database
• Update database credentials in the project
• Create required tables (users table)

npm start

Then open : http://localhost:3000