User Management System

Overview

The User Management System with SQL is a robust web application designed for efficiently managing user data. It offers user registration, login, advanced search functionality, and CRUD operations, ensuring a comprehensive platform for user information management.

Features

User registration with detailed information fields.
Secure user sign-in with timestamps for tracking.
Advanced search options, including:

Search by username, first/last name, salary, or age.
Search users by salary or age ranges.
Search users registered after or on the same day as another user.
Retrieve users who registered today or have never signed in.

Dynamic table for real-time user management.
Full support for adding, editing, and deleting users.

Technologies

Frontend: HTML5, CSS3, JavaScript.
Backend: Node.js with Express.js.
Database: MySQL for data management.
Other Tools: XAMPP and dotenv.

SQL Create Table

Use the following SQL statement to create the users table:

                        CREATE TABLE Users(
                            username VARCHAR(50) PRIMARY KEY,
                            password VARCHAR(50),
                            firstname VARCHAR(50),
                            lastname VARCHAR(50),
                            salary FLOAT,
                            age INTEGER,
                            registerday DATE,
                            signintime DATETIME
                        );
                    

View Demo

Watch the demonstration of the application here:

YouTube Demo

Setup Instructions

Clone the repository to your local machine.
Set up the backend by navigating to the project folder and running npm start.
Access the frontend via http://localhost/database_javascript/project1/Frontend/auth.html.