Mini-project

📌 Step-by-Step Setup & Documentation

This guide includes installation steps, setup, and file explanations to make it easy for anyone to understand and explain.

📂 Project Setup: Step-by-Step Guide

1️⃣ Install Node.js & SQLite

1. Check if Node.js is installed:

   • Open Terminal / Command Prompt and type:
      

     node -v
   • If it shows a version (like v18.x.x), you’re good!
   • If not, download & install Node.js from nodejs.org.

2. Install SQLite3:

   • Install SQLite globally by running:
      

     npm install -g sqlite3

      
   • Check if it’s installed:
     sqlite3 --version

2️⃣ Setup the Project

📌 Create a new folder and navigate into it:

📌 Initialize the project (creates package.json)

📌 Install dependencies

Create Required Files

Inside sqlite-node-form/, create the following files:

📂 sqlite-node-form/
├── server.js (Backend API)
├── database.js (Database connection & queries)
├── database.db (SQLite database)
├── public/ (Frontend files)
│ ├── index.html (Main UI)
│ ├── style.css (Styling)
│ ├── script.js (Handles form submissions)

📜 File Explanations

📌 server.js –

Backend Server

• Uses Express.js for handling routes
• Connects to SQLite database
• Manages form submissions & fetching users
• Stores user details
• Fetches city dropdowns based on selected state

📌 index.html – Frontend Form

• Contains two forms:
  ✅ User Registration Form
  ✅ Search User by Email Form
• Calls backend APIs (/submit, /getUser, /cities/:state)

📌 style.css – Styling

• Beautifies the form, buttons, input fields
• Proper spacing and layout for good UX
• Ensures both forms are visually separate & readable

📌 script.js – Frontend Logic

• Handles form submission (sends data to server)
• Fetches cities based on selected state
• Displays user data in a neat format

📌 database.js – Manages the database