Skip to content

karanlohia98/NodejsApi

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

7 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Note: Please use your own Database for this by creating a MYsql database. Created a small REST API and a web page.

Problem Statement:

  1. 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.
  2. 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.
  3. Your API should insert the record if it doesn‘t exist, else update the previous record.
  4. Create a search bar which will take email id as input and show the respective record if exist, else show error.
  5. 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.

About

HTML form to SQL Database Using NODE.js

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published