Add Initials Confirmation with airSlate SignNow

Initial registration confirmation

hey what's going on guys in this video we will learn how to create an email confirmation system for our website there are many websites on the internet which have registration forms and whenever you register an account on those websites they ask you to confirm your email and they send you an email which has a link and whenever you click on that link they redirect you to their website where you confirm your your email so this is what we will build in this video just to get started I want to let you know that I'm gonna work with a subdomain so my subdomain is the mail route Victor calm and you will need the database to you I created a database here as you see already so let's go ahead and create a purse table we will have just one table for this tutorial and this table is gonna be users table and we will have here five columns there's gonna be the ID we will have ID email password token and then confirmation now our ID it's gonna be let's make it a 10 leg and then this is gonna be the primary key so you wanna check this out Auto increment checkbox the email is gonna be 100 and here we wanna choose the qualification for it which is gonna be the UTF general CI and this one's gonna have the same thing talked in the same same way and then for our confirmation this is gonna ok this is gonna be our char varchar archer 100 we can make this 120 and then this one is gonna be just 1 because this is gonna be worth 0 or 1 so the length we may leave it one here but by default this is gonna be as defined so this is going to be 0 you know whenever we will register a user this you know Coulomb is going to be zero time which means that they they have to confirm their email whenever they will confirm their email this column is going to be updated and this is gonna become one so let's go ahead and save it and here we have our table as we already see the structure ID is the primary key email password token and the confirmation now on my server I have three files you may want to create three files to you wherever you work I have index dot PHP contact uh PHP in the verification dot PHP now the index dot PHP is gonna have the HTML form the config dot PHP is gonna have the it's going to handle the connection to the database and then the verification is the farm where we will redirect the user whenever they will click they will click on on their verification link the one we will send an email to them we will be using here the PHP mailer library so we can just go ahead and download it so if we go on google and search for PHP mailer HP mailer they have a repository on github and then here by the way I'm just gonna use composer I already have it installed here but I'm just I will delete it ok I'm gonna install it with you now so if you don't have composer you may wanna search on Google for composer and if the website instance should be get composer that work just click here download it and install it and then after that just open your terminal I'm using the visual studio and I have a terminal here I'm just gonna start a new terminal and I will navigate you I will install this library on my computer and then after that I will upload it to my server so I'm gonna go to see partition I'll have exam htdocs it doesn't matter where you stole it I'll just install it here because this is my main development folder so here we have composer require PHP mailer slash PHP mailer and this is gonna take a while and a while this is down here we will create our I will explain this conflict at HP file a little bit because I love this code here because this is not first time when I'm trying to record this video so here we have an app each being simply saying that writing log file generated alcohol so I'm just gonna close this for now so here we have a content that HP phone and this is the file that handles the connection to the database I'm gonna make changes in these files already open them and these changes are gonna be alive so here we have the try method and we have a variable which is the connection Co and N and we assign a new object the PDO object this is the PHP if I can say a native HP object already and then when this object has three parameters the first parameter is the type of the database we are using so I'm using MySQL and I put here minus Q now the database host is localhost the database name is party Club underscore mail and then the second parameter is the database user which is the same as the database name in my kids and then I have database password now here I left you see a comment set the PDO or multi exception so we said here and then if it catches any errors then we just output connection failed and here which we output why I mean what's the problem just to make sure that this works I'm gonna require it in index dot PHP but yeah so we have require once and here we have config.php I'm gonna save this file I'll confirm it here and then I'm gonna open my browser and I will refresh this page and we don't see any error because everything works fine but if I will remove for example the first character from my database user and then refresh the page now it tells me the connection connection failed and it tells me also the exes denial for user which means that there is no such user you know assigned to this database so this is just an example on how this would look like if you would get one of these now if i refresh it again everything works fine now as my PHP mailer libraries installed I want to upload it to my server so this is the vendor folder and I'll just upload the Pender folder and this is gonna take a while and while this is uploading there we will create the let's stop HP file so here below our PHP code we want to create another HTML page and this is gonna be an html5 page and here we will have let's say page title register register user and I wanna include I wanna use bootstrap so that's what I will do I'm gonna search for bootstrap the website is get boot syrup calm and just get started click on that button and then copy the copy this library from here and paste it in your head section this is before your head and before you close your head deck now in the body section they also have components here and they want to use the form component bootstrapped forms and they have here there you go I'm gonna use this for it's a simple format I will use it as a simple example for you to just to you to you know to make like an example to see how this functionality is more important than how many fields we have and I'm gonna remove this checkbox from the form also I'm just gonna clean it up a little bit here we want to add there's an input email we want to add a name here because there's they have no name here so name is gonna be email and then we should add another name for our password okay now also here we should have okay we should add action to our form there so action equal T is gonna be the same page and then method it's gonna be post and we want to add another container here because this form is gonna be full with right now it's gonna be all over the page so I want to make it so it will be aligned in the center of the page and give it a 500 pixels width so here we will have a style tag you're gonna insert a little bit of CSS and our HTML page and here we will have a class which is going to be the main container and we'll have here display table margin is gonna be a hundred pixels on top and then on the side is gonna be off and then on the bottom zero we will also have a padding of ten pixels a border solid and let's say display margin padding border yeah with it's gonna be 600 pixels and then marks actually the marks width is going to be 600 pixel and the width is gonna be a hundred pixels 100% so I'm gonna copy this one from here and let's create the class and then I'm gonna close it here so our form now is in our main container big class let's save this file and then we refresh this page we have our form here this is the main container we see we have the border submit button and if you want we can change it to register user so this is our form it's done now let's check because right now if we submit you know click register button doesn't happen anything because we don't handle we don't we don't handle the data from our post method from here so in our on top of our page where we have our HDHP tags here we want to create a new variable it's gonna be the output and this is gonna be an interval for now and then below we will have an if statement and we will check if there is any any data in our post method and if there is any data in our post method we will have a need and we will check our variables from we will check the data from our fields for email and then for possible so we have an if is sad and we have here post email and by the way this needs to be like this okay so if there is any anybody in our email then we have another HP variable email and we assign the data from our postman and then we have another if here we double-check now if the email is empty which means sometimes this this function is at may detect may detect some some data in our AHS method and then design it is data to be email and this data may be an empty string this may be an interesting and that's why that's why we check with double check here if it's empty if it has an empty string then we want you unset the actually this should be email here we want you and set the email variable okay this is for sure that it's a good it's a good way of checking the variables from the post method and then below we want you to do the same thing for our password so which I here the password password okay and then here we will have another if statement and this if statement is gonna check both of them at the same time which means if there is a user and the password entered in the form then we want to insert the user in the database so we will have if it's different it's different than empty let's say person is gonna be the email and goes and if it's different than empty password so different than empty means if this if there's any data in our email or in our password because if we unset it means it's really small this variable doesn't have anything in case if in case it has an empty staying here so if we have an email and the password in certain then here we can go ahead and generate a password so we have password now we reassign a new value to our possible so here there's there's a PHP native function which generates a password hash password hash and we use the password here and that's the first parameter this one gets two parameters first the first parameter is the past one the second parameter is the past password be fooled like this so we've got our password from the post method and we reassigned it we generated a password hash and we reassigned this new baby our hashed password to our password which is a link quality possible-- you'll see in the database there is gonna be a long char long string and then below here and we actually we will have a token to you if you remember in the database we have this token so we should generate this token because whenever the user is gonna register an account here they will get an a random talk and this token will be inserted here we will need this token to check we will send this token to user by email so that's how we will check if the user you know wants to confirm his email or not because this is gonna be like an identification token or something like that so here we will have a small function we will call it say get pokken and we will have a variable it's gonna be delay and we can make it 32 by default we will actually know how to use it but just just to link it just in case and then we will have a return substr we use this sub STR function that we use md5 function this functions our PHP native functions and then here we have an open SSL a random set of bytes we will use also this function so open SSL random so the bites and here we will insert 20 first parameter of the substr and then we have minus left so this way we can get hash we can get talking for our user and then below here we will have a new variable which is going to be token and we've assigned this function and then as a parameter we will we can choose here for example let's leave it tab and we this function is going to generate a random string of 10 characters if we don't put anything here we don't you know choose a parameter for this function then by default this is going to return a 30 you know a string by which is the method that you characters like so I love it 10 for no tendency now now we we go ahead and insert our user so we have a third variable using our connection to the database we want to prepare the statement so we have insert and misspell it here prepare we have insert into users set and now here we have email we want to insert an email and this is how PDO works I hope you already know that this you know this is like we pretty fine this function so we will have this function will assign value values these functions in our execute method so exit using execute function so here we have email and then we have password and then we have token and that's it we get three values here now using our insert variable we can execute this query we have an array execute array okay now here we want to assign to these four different variables and vainly so I have email it's gonna be the email and then here we will have password and we assign the password and then here we have the token okay I'm just gonna clean it up a little bit all right looks good so let's just output echo success let's save it I'm gonna confirm in here and my PHP mailer is being uploaded on my server which is very good now here if i refresh okay no okay if i refresh it now looks everything is good let me check the database so we don't have any user in the database now let's try to insert an user so I'm just gonna add a random email here and there in the password click register user it didn't output anything just strange it means it didn't work okay post ORN action was action there before so it looks like okay so the problem is here because if he male its sequel needs to be equal we just assign it here that's why I didn't know work alright let's save it now I'm gonna refresh it and I get this error Colton fine function is called md5 and sorry about that guys but similar is md5 refresh it one more time and it tells me here the output success now if we check our database we have our user here so this is the password this is the hash password hash function with this one this is the hash we cut from our password so this is encoded here we've got the token and then confirmation is zero okay so now we should use our library our HP Miller we should send an email with this token from here to our user so the user wonderful and we'll click on that link and they will confirm their email now to do that we should go and here where PHP mailer repository we will use these two lines so let's copy them and then we'll paste them right below below require ones line and then here below we insert our user we will have let's see let's require the vendor will have vendor slash local load that each people we have same thing in our example here so we have vendor slash out a lot of HP okay we won't be using at any SMTP here so we will have say PHP PHP mail and we assign we will assign to the speech I will actually can use just mail because email is being used here so we have mail and we assented mail a new object which is PHP mailer okay and then below here we will have we will use a dry method so we will try to send an email now and here we have our mail object and we set set from from where this email is gonna be sent where from what from which user so from what email I mean I'm sorry so we have set phone and here we have an email so I'm gonna just put here my email and then here we have the name the second parameter and I will put here user no say user registration and then below here we will have we will have to choose an email to where we want to send this confirmation link so we will have add address and here it's gonna be the email I actually have an email here so I'm gonna copy it I will paste it here and then below we will have the content and we will send a link which means we want we will want to use HTML tags and we should turn on the HTML type of messages so we just use the ease HTML function then parameters can be true now below we have the subject and then the subject is gonna be new user or let's say confirm email and then we have the body no and the body is gonna be there's gonna be a link so we'll say activate your email and here we will have we will have a link like this so here is gonna be HTTP mail are you Victor calm slash verification dot PHP and now we will send two variables in our get method and that's gonna be the email and here we will send the user email and we will have another one which is gonna be token [Music] all right look good and now we will use send method to send this email so it's gonna be sent and then below here we will just output echo message sent or if it catches any error then we want to output that error so we will have echo let's say message who couldn't be sent and here we will have the error it's gonna be male error input okay it looks good for now let's see if it works so I'm just gonna save it save it I'll confirm it here and then now if I'm going back to my form or just search you know refresh one more time I'm sure everything fresh data here click register user and then of course we get an error which says the bender felt Oman Street I probably misspelled something out there MC here let's copy this anyways let's see that's that this is the problem you just gonna save it and I'm gonna refresh it one more time and there is a problem cache your class PHP mail or not on ok index.html 40 43 hopefully didn't misspell anything in yeah I put P and P of course okay now it should work so if i refresh it one more time alright it tells me that message sent now if we check the database we have of course this is the need this is the last user because we've been trying because it ensures the user but then the mail wasn't working that's why we have so many users not here so now we should have an email and see if we've got an email here and we haven't spam and there's the user registration here is our email and for some reason we don't see the link because probably I forgot to use cert ok I didn't put anything here activate email or no confirm confirm email I'm gonna save it I'm actually I'm going to delete all this users from here so we'll have everything clean and now we'll refresh one more time this page alright it says the message sent come to this so we've got a new one right now and this one has a confirm email and if I inspect it fact that I can see that there's the verification of each you know it's my sub domain verification dot PHP we have email this is the email from from the forum and then there's the token which ends with twenty funny to have so we have we check here it's 22 F this is the token okay it tells me be careful with this message just because we are not using SMTP so now if I click on it proceed you know where it director to verification dot PHP file now we don't see anything here because we didn't create this file yet so let's go ahead and we should whistle should pick some stuff here we have our output function so the output variable which we should use this variable now yeah so instead of echo we should put the output variable and we should assign this message sent war see or if it gets any earth and we will assign the earth to our output and then after that we will just use output this notification here alright let's save it this is just a notification stuff it doesn't but let's see let's try it one more time I will delete this user from here so go back and our refresh this one more time and of course on a57 forgot you I'm just gonna put error this is the next shot error because I made it as like two parameters but it doesn't work that way you can't assign something like that verbal so if i refresh it now it tells an application we can application above our form which says message sent and it is the new message is already in our spam folder here has already said it goes and spam because we are not using a 70p server if you want if you don't know how to use a seven SMTP server I will put a link below this video where you can you know can watch it and learn how to use a sub T with this PHP mailer if you want to use SMTP so here we click on this link now where we redirected to verification that PHP file and now let's go ahead and create this verification dot each people so we want to require the configuration connection to the database so we have required once and there is the config dot PHP and then here below we want to check the one use the same way as we did here but now we will check the get method and if these folks so there is Eve we get if if there is any date in our get method then we want to use this logic from here for our email and for our token okay and then below we will have if it's different than empty email and it's different than empty what we have got a token and this is actually I'm variable alright so if there is any data there's anything assigned to our email where it is anything a central token that means we have some data now the get network we've got some data so here we want to update the user which has this we will update the token of the user which has this Ilya so here we will have a variable and she's gonna be select and let's see we want to select and talk him we will see if there's any user okay and so let's select the user so we have the prepared statement here and then we have select we will select the D from users where the email it's equal to the email to the email from our get method so we basically here check if there's any user in our database which has this email from our get data and token equal to the token from our get left and again these variables that there were just pretty fine than here but we will assign value to each of them in our mix execute method so we have select and now we execute our query and of course we have an array here all right so select ID from users where email email and token open email and poke and token okay and then here below we check we have an if statement if select eh column greater than zero that means there is a user we select if there is any entry in our selectmen and in our select variable after we ran this select query that means we found and users so if we have a user we want you updated user now we get we get an update variable and using the connection to the database we want to prepare this query so we have here update users set what was their set see confirmation confirmation is zero now we should update it to be one confirmation equal one we will also have token so the token is gonna be empty we will empty it and then we're female equal to email and now using this update variable we will execute this query so we'll have an array and we have here it's just the email then let's check one more time select each column greater than zero we update connection repair update user set confirmation this is the confirmation here and then we just remove the token from the from the database where emails equals email and then email us here all right and then just after that we will output echo email email has been confirmed I'm not sure if this okay let's see so select ID we check if there is anything okay so we'll get the user which has this email out in the database okay so everything looks final we just output here success okay I'm gonna save it and if i refresh it now of course there's an error on the 28 line 28 okay this is yeah it's kind of placed at least kind of late guys we don't get any anything on the screen which means there is a problem in our selection here okay let's see if it goes here now it doesn't which means email and token I misspelled something here this one should be get that one I forgot to change it okay so we remove this stuff from here we've got a success here okay fresh one more time we get success now if we check our database this token should be gone now and then confirmation should you want you and that's what we've got here which means the user confirmed is email so this is a very simple example guys but this is the logic behind the logic behind this confirm email confirmation system from those websites I will leave a link to this source code so you can get it from my github repos github repository if you have any questions feel free to leave them in the comments if you liked the video subscribe to this channel and I will see in the next tutorial