Skip to content

Latest commit

 

History

History
109 lines (102 loc) · 3.63 KB

README.md

File metadata and controls

109 lines (102 loc) · 3.63 KB

Description

This is a chat room application that makes use of the power of socket.io. It contains a registration system for new users and also a login system for authorized users to join the many chat rooms offered.

Technology Used

    core
    • Socket.io
    Front End
    • HTML 5
    • CSS 3
    • JavaScript
    • jQuery
    • Ajax
    • Bootstrap 5
    Back End
    • Node.js
    • Express.js
    Relational Database
    • MySQL

Installation

To be able to run the application on your machine, you'll first have to install the dependencies through the command-line tool:

  • npm install

Configuring MySQL Database Locally

Inside the main directory, you will find a folder named DB.

  • Enter the DB folder
  • Start the MySQL command line tool and log in: mysql -u root -p.
  • With the mysql command line tool running, enter the command source live_chat.sql. this will run the schema file and all of the queries in it thus creating the database for you.
  • Close out the MySQL command line tool: exit.

Usage

To start the application, type the following in the command-line tool:

  • npm start

then navigate to http://localhost:3000 in any browser to view the application.

In the login screen, you can either sign up to create your login information or use the existing testing login information:

  • Username: guest
  • Password: guest

This is the signup screen, fill in all the information and your account will be created! Users will be able to chat with different people who are also logged into the same chat room and their chats will be confidential to only the users in a specific chat room.

SQL DUMP

An SQL dump is a file that contains a record of the table structure and the data from a database. It can be used to create a backup of the database or to transfer the data to a different database.

The following snippets show:

  • It als show phpMyAdmin and the database with the respective tables
  • The sql command to create a messages table
  • The sql command to create a user_details table
  • Also show the setting of the primary key in each of the the created tables

PREVIEW

image

image

image