Counsellor-Services

Book available slots for the given mental health counsellors

Download Xampp and run Xampp Controller.
Start Apache and MYSQL and open http://localhost/phpmyadmin/
Create database with a name counselling and create a table named users, with 4 columns ID,name,email and password while ID being the primary key.
In the db directory open the Event.txt file and create an event in your database by clicking on event option and paste the contents of this file there to create an SQL event.
This SQL event sets all the values of is_booked column to Available after every 24 hours. So if a user books a slot for tommorow to make the slot unavailable for that day then next day that slot again becomes available for anyone else to book.
Import two given .sql file from db directory.
In the .env file check your username and password for the db and update there accordingly.
Type node app.js in your terminal, open http://localhost:8000/ in your browser.

Name		Name	Last commit message	Last commit date
Latest commit History 19 Commits
controllers		controllers
db		db
public		public
routes		routes
views		views
.env		.env
README.md		README.md
app.js		app.js
package-lock.json		package-lock.json
package.json		package.json