Note: Please use your own Database for this by creating a MYsql database. Created a small REST API and a web page.
Problem Statement:
- Create a Web form which will take inputs from user. Below are the form fields. a. User Name b. Password c. Email Id d. Phone Number • Note*: Use input field validation.
- Create a REST API which will take request from the HTML form and insert the data into MySQL database along with the current Date and Time.
- Your API should insert the record if it doesn‘t exist, else update the previous record.
- Create a search bar which will take email id as input and show the respective record if exist, else show error.
- MySQL Table struct and connection details; a. Table Struct: userName varchar(25) NOT Null, emailId varchar(50) primary key, phoneNo varchar(10) Not Null, password varchar(50) Not Null, dateTime Timestamp
• Note*: You should use Node js for API creation.