PHP OTP Login Verification Script

In this video I will explain you about how to implement PHP OTP login verification script in localhost. OTP is an effective way of validating users.
In this script I am using sendgrid SMTP for sending otp emails.
For any queries and clarification feel free to comment.
For Best Hosting Plan Check:- 91weblessons.com/domain_hosting
Learn PHP Online with Me:- bit.ly/LearnPHPOnline
To help and support me(Donate Me):- bit.ly/ProgrammingWithVishalD...
Download source code from here bit.ly/2NCvz2W
#PHPScript #PHPOTP #PHPLogin
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
✅Subscribe: / @programmingwithvishal
I am a Digital Marketer by passion and a Developer by profession. With experience and expertise spanning around 10 years, in the Digital space.
Good amount of experience in development of web applications using PHP, .Net, JavaScript Library’s, Frameworks, CMS, API’s, Reporting tools and Payment Gateways. Skilled in digital viral marketing, technology innovation's, brand building and all phases of the Web development lifecycle with an expert in translating business requirements into technical solutions and fanatical about quality, usability, security, and scalability. Dealing with and resolving problems and issues which arise.

[@ProgrammingwithVishal]

Guys if you are facing issue with Sendgrid SMTP try this GMAIL SMTP. Watch this kzbin.info/www/bejne/oWivhJ5vnbShgM0

[@ramaaryan9849]

thankyou so much for such an amazing video,,,,nd sir where r u from

[@cashbackloan6618]

@@ramaaryan9849 his name is vishal Gupta and he from Sarita vihar, Delhi.

[@ProgrammingwithVishal]

@@cashbackloan6618 Now in Noida

[@preetsandhu422]

Hlo bhai data base me id kaise exit kregi i want my google sheet list gmail ids ki ek database ki tra kaam kre

[@onlinecoder01]

Bro aapko shortcut Mila kya

[@saurabhtitus8267]

Vishal sir you are grate for those students those wants to learn programming thanku so much sir

[@sundar6492]

Thanks a lot , It really helped me , Pls Post more videos on Basics of PHP , Better if subtitle Available , Thanks Once Again

[@myho5694]

hi Vishal! i using your code. but i want to comparing the value in database with the value in input when have someone input the otp. if they give input the value is equal with the value in database that's mean they can go next step. how can i set it up? thanks

[@SICTINDIA]

Thank you sir, your video is very useful for higher, medium and lower students

[@niteshgupta3525]

This is 100% working , but i modify as per my way , i used phpmailer instead of send-grid

[@Neha-Neha]

Really it helped me a lot.after completing my task I was like ohh lovely . Thanks a lot

[@ProgrammingwithVishal]

Once again thanks a lot Neha

[@ratishal0308]

OTP received in the database but not on the email id and the page is not redirected to the OTP verification page

[@saurabhmahawar]

Amazing way of teaching programming. Great👍👍

[@ProgrammingwithVishal]

Thanks a lot

[@rohitkumar-ts5hs]

when i click on submit , response:Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, bool given in C:\xampp\htdocs\ff\send_otp.php on line 6 not_exist, any help, thanks

[@buddytime2249]

Vishal sir please help me I am trying to create a function but my function wasn't work the way I want...example of what I am trying to do example:- I have two basket, In first basket there are 5 mangoes and in second basket there are 10 mangoes. if require mangoes is less than 5 then pick from first basket else if require mangoes are more than 5 then pick 5 from first basket and pick remain mangoes from second basket.i am stuck and dont know how to do please help me or make one video

[@xlr8tanmay]

Can we use username instead of email? And then connect it to the database mail through a php script

[@kowsalya2740]

Hello sir, i am from tamilnadu.. Can u please a upcoming tutorial in english.. Or subtitle.. It will really helped lot. Thanks from india♥️

[@priyansh5233]

He is from Delhi, India, and he is speaking Hindi.

[@freewebsitetemplates2039]

Bro i am also tamil

[@priyansh5233]

@@hiheven4656 Bro? I was replying to somebody else who deleted their comment.

[@hiheven4656]

@@priyansh5233 ooh okay! really sry bro!!

[@praveenshiva8658]

I am also tamilnadu 💛🥰

[@KshitizAgain]

Thanks! It helped for my online old goods selling website project🙂subscribed your channel and liked the video

[@ProgrammingwithVishal]

Glad it helped!

[@desuvyshnavi9327]

Can you pls once explain me how it worked because I am doing the same project I stucked at this point... it's urgent ...

[@globalnewshindisen]

flutter code me sirf mobile number insert kare or 000webhost (phpmyadmin) pe save ho or OTP wpas mobile number pe aaye.... flutter se mobile number 000webhost pe save ho bhi rhe hai but opt nhi aa rhe hai...

[@heyizsheanny]

Sir , I have tried to run the source code but it's showing in SMTP file I don't know how to fix please guide me .

[@peacebuilder3164]

This is great. I received otp to my mail but I strucked with an issue. The page is not redirecting to dashboard.php. What to do sir? I am using xampp. Help me sir

[@livetrial9684]

Please give me solution below mention function is not working. OTP is sent successfully to mysql and mail but hidden box in not viewed. success:function(result){ if(result == 'yes'){ jQuery('.second_box').show(); jQuery('.first_box').hide(); }

[@smebajar6024]

Sir. Agar mujhe isi code me User ka session create karne k baad main chahte hu ki agar user ki kuch aur bhi detail hamare database me hai wo yaha display ho jae. Wo kaise hoga. Please help

[@varadkahakarkar1953]

hello sir great video but i have one query in my case otp is generated but it only storing in database i am not getting that otp on mail can u please help

[@moviewala9170]

No doubt. You are the best!!

[@AnirudhSoni]

tum bahut badhiya kaam karta hai vishal bhai

[@motivmood_859]

after doing all things i'm not getting otp in my email n this showing invalid address : $emailyes ......why? my mail apssword are ri8 then why not working?

[@samratmani880]

SMTP -> ERROR : failed to connect to server: network is unreachable (101) Called Mail() without being connect. Kindly help me with this error 🙏 😔

[@usama5911]

Sir me 4 years bad dekh raha thanks for this mini project. Sir singup kye sath ey wala system kyse bnay gee please bata do please🙏🙏🙏 Account create and login with email opt

[@user-di2yr2bo7c]

Sir aap jese teacher ko m kab s search kr rha tha jo mujhe meri language m samjha sake Sir mene aapka channel subscribe kr liya h m aapke video ko follow or like krta rahunga thanx for share simple way

[@ProgrammingwithVishal]

Thanks a lot.

[@businessidea3380]

Aapka videos me advanced script use hone laga hai...

[@rajabhishek4973]

Nice sir please make a video on payment gateway and QR code php script

[@priyankaa5418]

when i click on send otp btn ....i received otp .. but otp text box not showing

[@kishoresamal7191]

Echo yes not working ... In console it comes with yes as well as all smtp messages

[@alaabidalhussain2710]

Bro can we send the otp to mobile number as well with this script. Kindly assist

[@entertainingcritics7495]

Sir kya same chij laravel me register login k sath otp generate ksath bata sakte h

[@muveenhasan6942]

Sir email ki jaga nunber se bhi kiya hum otp verify kr sakte h

[@romiapaul3996]

thank you so much sir for this video

[@kishorindhe4891]

Such a good explanation sir

[@ProgrammingwithVishal]

Thanks a lot Kishor.

[@susilkumarbehera1681]

Sir why u store email in database, you have to create a video to submit email with OTP

[@wasss3745]

Im confuse where is the login_otp this file not found .

[@sunildogra3975]

Sir, thank you for the php code for otp verification, Kindly help as i am receiving error as Please enter valid email though i have entered a valid email id and saved the same in the database

[@ashwinivishwakarma243]

Sir, link given to download is having smtp files only

[@solomanvarghese6481]

What we do if the email goes to spam folder ?

[@vineetbawa86]

its sooo easy when yo explain .. !!

[@ProgrammingwithVishal]

Welcome Vineet

[@kingpatricktorreliza3854]

when i click send otp nothing happen how to solve that problem

[@sardorjs3647]

Thanks for great video tutorial, there's one thing that I want to know, how to do so when we verify OTP, in database the column otp is still being his verified OTP, now it's disappearing when we verify the OTP, and do we got the method how to add one extra column named like "is_verified" with values "Yes/No". Please could you help me with it!

[@ProgrammingwithVishal]

For this create a separate field "is_verified" in table. Once you generated OTP insert "No" in is_verified and after OTP verify update that is_verified to "Yes"

[@sardorjs3647]

@@ProgrammingwithVishal and what about default disappearing otp when someone is verify it. I followed what happening when we are sending otp to user and understand that it appears in database when otp is generated but when we verify this otp is disappearing. How to change it?

[@ProgrammingwithVishal]

That is because in check_otp.php line number 9, after OTP verification I am updating otp to blank.

[@sardorjs3647]

@@ProgrammingwithVishal thanks it works!! Can you tell how to do is verified more details, if you will have a free time please, more code information))) please)

[@priyansh5233]

@@sardorjs3647 Steps - 1. Create a row "is_verified" in your table. 2. Now after checking if the email exists in the database just insert "No" in that table along with the generated OTP before sending email. 3. Now when the user enters correct OTP, update the value of "is_verified" to "Yes".

[@sonaliverma1562]

Thankyou so much sir

[@laltumandal997]

Ek video Otp with time expiry with resend feature par banaiye Similar bank Ka Otp page jaisa Please

[@nasirkhan5836]

Sir appne action= "confirmation. File ka code show nahi kiya

[@akshayakumarpallai7130]

Thank you for this

[@sonakshic3431]

Phone number based otp verifocation kese kre sir Is pr b pls bnaiye ik video

[@shivprakashsharma3690]

You are great sir

[@ITHUBWITHMULTICOURSE898]

sir ye code work nhi ker rha ind fill kerne per otp frame nhi a rha

[@sayaklahiri8583]

thank u sir for this course sir i have a question agar hum kisi registered aadmi ko otp vejna chahenge tow uske liye hume tow us admi ki mail ka password nehi pata hoga , and agar multiple people ko vejna chahenge then function me username and password pe kya change hoga

[@ProgrammingwithVishal]

Please check kzbin.info/www/bejne/i2naqn6Vdptpr7s

[@sayaklahiri8583]

@@ProgrammingwithVishal okk sir , thank u

[@bibinjoy6248]

Nice and simple presentation

[@ProgrammingwithVishal]

Thank you

[@nilasishdas7208]

Sir, I have a query related to logout.php.... can I use season_destroy(); then use the header to the index location?

[@ProgrammingwithVishal]

session_destroy() jitna bhi session hoga sab khatam Kar dega. Now assume ki apke user and admin dono ka login Kiya hai, now session_destroy() admin and user dono ka session khatam Kar dega.

[@nilasishdas7208]

@@ProgrammingwithVishal thanks for a brief explanation sir, now I understand the limitation of season_destroy()in this problem.

[@moriomchowdhury9170]

In smpt.sendgrit.net what should i write

[@PlatinumSagar]

Thank you sir.

[@abhigyanaishwaryamishra5670]

I have uploaded files in local server otp is saved in databse when i press send otp button but its not redirected to check otp button and also mail is also not received

[@ProgrammingwithVishal]

Check your console, I guess there are some error

[@amitkasabe]

Sir can you please upload a video where user can put his all information and then that information gets stored in database and form the same database email id should be verifies

[@ProgrammingwithVishal]

It's pretty simple. Use below link for insert data into table. kzbin.info/www/bejne/lYnYo2qaoKmAg8U

[@akshataghag9087]

Can you please do this same email otp in laravel

[@yashashreewarang6294]

When I click on send otp, second box don't open and get error in my console saying - uncheck runtime.lastError: The message port closed before a response was received.

[@ProgrammingwithVishal]

Please sent me screenshot. My email id [e-mail]

[@akhilanair1488]

@@ProgrammingwithVishal yes sir facing the same error but i have no errors.but the second box doesnt get redirected

[@rks1509]

Sir, this method is great but can you provide any alternative in which we don't have to store the OTP in database and we can just check it in the script??

[@ProgrammingwithVishal]

Yes, store OTP in session then

[@rks1509]

@@ProgrammingwithVishal that's quite better than storing in database. Thanks a lot 😊👍!

[@priyansh5233]

@@rks1509 anyone can just get the otp without having to go to their email inbox, they can just see the cookies stored on the browser/local machine.

[@rks1509]

@@priyansh5233 yeah, you're right, I don't know what I was thinking about when this thought came into my mind, but yeah, not every user knows that we are using session variable to store it.. but yeah, u are right

[@naso4383]

Thank you for the good information. I've done the same thing, but there's no response when I press the "send otp" button. What's the reason?

[@ProgrammingwithVishal]

Is there any error or response you are getting?

[@naso4383]

@@ProgrammingwithVishal If I press F12 button on web page to check the network part, "SMTP -> ERROR: Password not accepted from server: 535 Authentication failed: Bad username / password SMTP -> ERROR: RSET failed: SMTP -> NOTICE: EOF feeling checking if following the following from address failed: [e-mail] : Called Mail() without being connected yes" The error will be confirmed.

[@ProgrammingwithVishal]

Recheck your configuration setting. Also change [e-mail] to your sendgrid email id

[@naso4383]

@@ProgrammingwithVishal I modified the smtp_mailer() in the send_otp file to the id and password of my Google email. Is this the right way to do it? There is still no response when the "send otp" button is pressed. (When I enter an email that is not in the database, "Please enter valid email" is shown.) An error occurs with the same content as before. In the PHPOTPLoginVerificationScript\smtp\mailer file, Do I have to modify the $mail->Username, $mail->Password, $mail->SetFrom part just like the smtp_mailer() in Sent_otp?

[@ProgrammingwithVishal]

Use sendgrid account details instead of Gmail account details as per the tutorial

[@dear_life_23]

Smtp error 535 authentication failed Plz help

[@gohardarakshan8193]

Hello sir.. It's really very helpful video but I have a question may I ask it individual??

[@ProgrammingwithVishal]

Thanks and Email me at [e-mail]

[@surendrasingh-ee4uw]

Sir whatsapp server pr Maine change no to change no kai bar kiya fir time 24 hours hogaya to kiya server wale dekhe sakte h esa agar maine bar bar kiya

[@ProgrammingwithVishal]

Samjha nahi main aap kya boal rahe wo. Apne comment email otp ke post pe kiya hai or aap whatsapp ki baat kar rahe ho

[@lvgroup3861]

excellent explanation

[@ProgrammingwithVishal]

Thanks a lot

[@amanprasad2349]

Sir aap pls apna code editor change kr lijiye sar dukhta hai dekh ke

[@arshsiddique3653]

@programming with Vishal sir make a video on how to send OTP on phone number ... please🙏🙏🙏

[@ProgrammingwithVishal]

Noted.

[@secretcaptain7694]

Sir I think you don't need to store OTP. You just set on session and verify. It will be more secure.

[@ProgrammingwithVishal]

Session can be hacked via cookii

[@zero_n_one3782]

Thank you its work with gmail now but not with sendgrid . However when i send the otp to email id it send to my account and also updated in my database but it wont show the submit otp box after clicking the send otp button why these happening although i used your code but only part its not working is send otp box is not appear where i can put my otp code. Please can you kindly let me know for not working properly. Thank you once again.

[@ProgrammingwithVishal]

May be you are getting space in response. Just use result=result.trim(); after success:function(result){

[@zero_n_one3782]

yes i did the way you said but doesn't have any changed still same problem no display.

[@oynxmedia]

kzbin.info/www/bejne/Z2PVqnaCZpeJqJo

[@vipin8272]

Great Sir but please mobile pe otp send karo then verify ek video ispe bi bna do

[@ProgrammingwithVishal]

Sure will do in next video

[@steplittle3516]

@@ProgrammingwithVishal sir abhi tak aap nai ye video uplod nahi ki

[@YogeshJangid986]

Hi, Thanks for uploading such great code. Can I have a database file so that I can import?

[@ProgrammingwithVishal]

Thanks a lot Yogesh. Below is the link to download the source code and db file. bit.ly/PHPOTPLoginVerificationScript

[@AvinashKumar-oj8xc]

hi Vishal, make a video about otp verification using mobile number in the web page verification.

[@ProgrammingwithVishal]

Sure Avinash. But you can do that by yourself also. Just replace mail send coding to sms send coding. For SMS please follow my below video kzbin.info/www/bejne/oXWoqqSIe7hjkJo

[@techpatel18]

Sir how send otp in mobile number

[@teluguexpress4314]

Sir after giving email address otp was generated in database but after it not going to second box for submitting otp At 17:39 in your video u also got same problem. What I have to do sir

[@aadarshsm]

any solution to this???

[@R.KFilmsProduction]

Thanks

[@shakshamagarwal7070]

aapne database ka name user daala or connection youtube se bnaya ??

[@ProgrammingwithVishal]

Database ka naam KZbin hai and table ka naam user hai

[@uniquethinkers8552]

Sir mene iska code kiya or run bhi kiya lekin me jab email likhle send button pe click karta hoo to user ke table me otp to add ho jata he lekin user ko send nahi ho raha he pleas sir iska solutions bataye

[@ProgrammingwithVishal]

Yaha pe humne sendgrid ka use kiya hai OTP ke liye, Sendgrid ne kuch changes kiye hai, Sendgrid ki jagha aap GMAIL SMTP use karo. Please follow kzbin.info/www/bejne/oWivhJ5vnbShgM0

[@ravisingh-rv3bx]

Great sir

[@hritikparmar2935]

What is database name

[@shubhradasgupta691]

I am on (Xampp) Localhost. How can I send emails from there?

[@mdmoqimalam9183]

php mailer

[@faizanjamshaid673]

great sir

[@nidhipathak3394]

I follow the steps but getting error Password not accepted from.server 535 authentication failed bad username and password Error reet failed

[@nidhipathak3394]

Please reply

[@ProgrammingwithVishal]

Nidhi, it's clearly showing your are using wrong username and password here. Also instead of SendGrid try gmail SMTP kzbin.info/www/bejne/oWivhJ5vnbShgM0

[@niru1931]

This is not working sir, in send_otp it is showing undefined email variable , plz reply sir i am stuck in it for 2 days🙏🏻🙏🏻

[@ProgrammingwithVishal]

You are doing something wrong. Give me your PC access via anydesk or teamViewer

[@niru1931]

@@ProgrammingwithVishal okay sir

[@guptarahul97480]

gmail me agar double verificatio rahega toh mail nahi jayyega kya ? Bad Username

[@ProgrammingwithVishal]

Yes, 2 step verification enable hoga toh SMTP work nahi karega

[@guptarahul97480]

@@ProgrammingwithVishal Thanks

[@getsetcodesg3189]

Sir I am facing problem when I click on SEND OTP button switch nahi ho raha hai can you please help me

[@getsetcodesg3189]

Sir please reply me

[@krishnawaghmode2120]

greate tutorial sir sample project make sir How to track user over LAN connectionin php

[@ProgrammingwithVishal]

Here is solution. kzbin.info/www/bejne/fH-TpWR_jr6rrLs

[@akshaychougule7170]

thank you sir

[@ProgrammingwithVishal]

Welcome Akshay

[@SureshKumar-qy1bf]

hello sir kya otp ko ham koi teligram ya whatsapp pe send karsakte he kya agar karsakte he to please code kyse hoga ek video banake denge kya please

[@ProgrammingwithVishal]

Yes you can. Please check my below video. kzbin.info/www/bejne/gmbaaHqrjbl8a5I

[@SureshKumar-qy1bf]

@@ProgrammingwithVishal तो sir ये teligram पे भी करसकतेहै।।

[@ProgrammingwithVishal]

Try core.telegram.org/

[@mayankkashyap1893]

Bhaiya submit otp button or click krne se wo next page ko nhi jaa raha h . please help

[@ProgrammingwithVishal]

submit se success result aane ke baad, javascript se redirect kar lo

[@mayankkashyap1893]

Bhaiya I need help

[@bharathchippa3773]

when I press the send otp button its not working..please help

[@ProgrammingwithVishal]

Check your Console. Have you changed the api details?

[@mayankkashyap1893]

query for latest timestamp and a given condition? Please help

[@ProgrammingwithVishal]

Sorry not getting you.

[@samanjoshi9171]

sir send otp pe cklick karne ke bad submit otp ki field nahi ati otp enter karne ke liye please give me a solution

[@ProgrammingwithVishal]

Check console

[@rishikeshjangam3474]

which username and password we have used in this video in send email function

[@ProgrammingwithVishal]

kzbin.info/aero/PLWCLxMult9xfY_dsYicKGcCLhlZ6YXFMh

[@rishikeshjangam3474]

@@ProgrammingwithVishal Thank You Sir.😊

[@anilkumarjena9300]

Why this code is not working in live server??

[@ProgrammingwithVishal]

Go to console and check error. May be openssl is not enable on your server

[@rajusinghrajput4442]

Sir mobaile number OTP me time limit or resend OTP kese add karte he

[@ProgrammingwithVishal]

Maine ek details video jaldi banane wala hoo, ye topic pe.

[@rajusinghrajput4442]

@@ProgrammingwithVishal Ok sir

[@maheshbagra9403]

Sir polite request please tell him how to connect with SMTP server

[@ProgrammingwithVishal]

Check kzbin.info/aero/PLWCLxMult9xfY_dsYicKGcCLhlZ6YXFMh

[@ipbps6]

wow best video

[@ProgrammingwithVishal]

Thanks Pritam

[@unrealexperton]

Sir can please send me data base file please I this that giving me error on 000webhost 🙏🙏🙏🙏

[@ProgrammingwithVishal]

Download from below link bit.ly/2NCvz2W

[@hardik_parmar007]

sir there is no error in console but it doesn't work send otp button ... please reply sir

[@ProgrammingwithVishal]

Please show me your smtp_mailer function from send_otp.php file

[@hardik_parmar007]

@@ProgrammingwithVishal otp is generated but didn't received any email and send OTP doesn't work means second_box doesn't show when I click on send OTP and there is no error in console

[@hardik_parmar007]

@@ProgrammingwithVishal and in send_otp.php file I changed $mail->Username to my email ID and $mail->Password to my appropriate password and I changed in $mail-> SetFrom to my email ID

[@ProgrammingwithVishal]

@@hardik_parmar007 check in console what your are getting in first click

[@hardik_parmar007]

@@ProgrammingwithVishal SIR I got nothing on first click in console and there is no error occurred...

[@swarajdey9035]

Fatal error: Uncaught phpmailerException: Invalid address:

[@swarajdey9035]

This error came when I hosted in go daddy

[@ProgrammingwithVishal]

Yaha pe humne sendgrid ka use kiya hai OTP ke liye, Sendgrid ne kuch changes kiye hai, Sendgrid ki jagha aap GMAIL SMTP use karo. Please follow kzbin.info/www/bejne/oWivhJ5vnbShgM0