You have been provided with drive link with some code skeleton here It has the following
which is the landing page having links to register and sign in
is the landing page after successful login
this contains your database configurations for server(hostname), username, password and database(db). it also creates a connection to the database and returns it in case it was succesful, if not, it throws an error as a pop up to the screen your first task is to setup up your database credentials
- which is the login page whose form actions is php/login.php
- which is register page whose form action is php/register.php
- which is the reset password page whose form action is php/reset.php
- is a file that handle user interaction with the various forms, it calls the necessary functions based on the form the user is currently interacting with.
this file handles the main logic of the application, it container the loginUser(), registerUser(), reset(), getAll() and deleteaccount() functions
With the provided code skeleton inside userAuthMySQL folder, your task is to complete the following files
-
Open your phpmyadmin and create a database called zuriphp. create a database called zuriphp. Create a table called Students with the following
Id
Full_names
Country
Email
,Gender
dob
-
import the sql file called users.sql to have some initial users in your database for testing.
-
setup your database credentials by specifying your servername(host), username(user), password and database name(db)
-
this function should take the full names, email, password, country and store the data in a database table called Students . If it was successfully stored, the users should receive the message (“User Successfully registered”)
-
This file is meant to handle user login from the login form, the user inputs email and password from the form, you should check if the email and password provided match that which is in the database table and if they match, create a session and put the username inside and redirect the user to the dashboard, if it does not match, redirect the user back to the login page
-
this Function is meant to update the user password, the data is received from resetpassword.html, it takes in the email and the new password and searches the database, if there is a match for the email, it should update the password field with the new data from the form, else, it should print out “User does not exist” logout.php this file is meant to destroy the user existing session and redirect to the login page
-
this function get all the users from the database on display them on a table within ht function
-
this function to delete the user with the given id from the button on the front-end (the button name is ‘id’ you can access it within the post array when the button is pressed