Skip to main content

Forgot Password API - with Postman Testing node js , express js , MySQL,

 // Hello coders , follow previous post for product architecture -   Today we are going to see how to reset password & update it in mysql database-    

==============  follow previous post for helper files & folders ==== 

//================= app.js  ============== 

//to Generate OTP - 

var otp;

function setValue()

      {

    otp =   Math.random();

      otp = otp * 1000000;

        otp = parseInt(otp);

          console.log(otp);

        }

function getValue() {

    console.log(otp); // yup, it's "test"

}

//======= Forgot Button on Login Page- will redirect to /forgotPassord

app.post("/resetpasswordOTP",(req,res)=>{

    //res.redirect("/forgotpassword");            
    res.status(200).json({success:"Enter verified email"}); 
})
//============== Forgot Password Button End ========================

//=============== Page to send OTP method- post, action-"/resetpassword" ============

app.post("/forgotpassword",(req,res)=>{

    const {email}=req.body;

    setValue(); 
        //SendMail() // here we can send otp to email or mobile number with the help of nodemailer but //not using right now instead of we will see otp on terminal or cmd  where our project is running 


        connection.query('SELECT * FROM register WHERE email = ?', [email], (err, rows) => {
                
                if (err)   
                    res.send("Invalid Accout");                     
                else 
                res.json("OTP Sent"); 
        });    
})


//============== Reset Password with the OTP sent from previous post Method

app.put('/resetpassword',function(req,res){
  
        const {email}=req.body;
 if(req.body.otp==otp)
   {     
    req.body.cnpass = hashPassword(req.body.cnpass);
        connection.query(`UPDATE register SET password =?  WHERE email= '${email}'`,[req.body.cnpass],(err,result)=>{
                if(err) 
                res.json("Failed to reset password");
                else 
                res.json("Password Reset successfull");
        }); 

   }
   else
   {
       res.json("Wrong OTP");
   }

}); 
=================== end 

Now Test this api on postman Rest client - 

open postman  & test all three api one bye one - 

1.  Method - Post -  url - localhost:3000/resetpasswordOTP



2. Method Post -  url -localhost:3000/forgotpassword //===== to send OTP



================SEE Otp on console



here OTP is - 886369

3. Method PUT (because we are updating something but post will do also ) - url - localhost:3000/resetpassword

on postmant enter right otp -


Password has been changed you can see your MYSQL Database



Comments

Post a Comment

Popular posts from this blog

Part 15- What is Repeater (Networking Devices)- Computer Networking- CCNA

Repeater  hello friends i am Vasu Birla and today i am starting new segment of CCNA computer networking  its a Networking Devices. we will discuss every important Devices used in networks. Repeater is a first networking devices. What is Repeater  Repeater is a device that receives signals and re-transmits by amplifying or regenerating signals. Repeater has two port one is for receive signals from previous network and second port is for retransmit signals to the next extended network. Two Port Repeater Repeater is a device which is used to Regenerate or replicate signal (Pichhe se aa rahe signal ko regenerate karke ya amplify karke aage strong signals bhej sakte he) Analog and digital both type of signals can be retransmitted by repeater. Here there is difference between regeneration and amplifying.  Amplification means , received signals will be amplified as it is , whether there are impurities in signals  and Regeneration means repeate...
Post a Comment
Read more

How to Kill the Process: ( Port Process )

--- FIX: Port Already in Use (EADDRINUSE)address already in use ::3000 SOLUTION --> Kill the process on that port: //==== OPTION A ======  gloablly install ( not in project package.json  npm install -g kill-port and then -->>  kill-port 3000      // use your port  //===== OPTION B ======= --- Windows --- netstat -ano | findstr :3000 taskkill /PID 17780 /F     --- Linux / macOS --- lsof -i :3000 kill -9 17780                     //Note Use your PID instead of 17780  ==============END ==========  
Post a Comment
Read more

Part 19- Router (Networking Devices)- Computer Networking- CCNA

Hello friends...i am Vasu Birla and today will discuss about the most important Networking Device ..Router.  so let's start... ROUTER Router is a device which connect two or more networks together, which is why router is also known is Inter-networking device also. Inter-networking means two or more networks are connected together with the help of router. one more thing router is just like a computer  but it is designed for routing only, our computer can be router also but that are software router while hardware router which are specialize for routing is more efficient and fast than software router.  There is a Operating System installed on router which get moves data from one network to another network with the help of routing table.  Router does work on Network layer or Layer 3 of the OSI model.  Cisco Router There many companies which manufacture Router but main companies are - Cisco , Juniper , HP, 3com and Nortel  ...
1 comment
Read more