Never knew you could just update the string with a new value 🤔 out of all the years I've been using PHP too! Time to do some coding updates 😂 Thanks so much for the video!!!
Those 6 dislikes are literally BS. They probably don't have a smtp server running, therefore their mail() function didn't work, so they decided to dislike it. Anyway, this video was amazing and very helpful. Thank you very much, it helped me understand some stuff I was iffy about. Good luck, I'm definitely going to subscribe.
Hey, i was trying to learn how to make a secure registration system for a new web app, all i can say is you are really helpful and clear. Amazing job continue with such tutorials. Subscribed!
I did my research before deciding on a signup / login method and found the email verification keeps a lot of the riffraff out. Your method here is a gem. Thank you very much. PS I hope to add SMS / phone verification in as well soon.
What Mr.Sean did in 21mts, other Channels do half that in 180mts, while all the time incorporating several confusing code Routines, thus making them too complex for anyone to follow, and yet garner all the traffic and more so leading a lot astray. YT, should have a mechanism put in place to identify Genuine and service minded individuals like Mr. Sean and promote them.
So, a couple things here. 1) Use password_hash when storing passwords (check out my video). 2) Using prepared statements is the best approach to prevent SQL injection (check out my video). 3) You'll notice I did not strip htmlspecialchars from the GET method, exposing the database. Do that.
Just came across your channel and I'm thoroughly enjoying it. I see your last video was posted 4 months ago, and I'm hoping that you're just on an extended break. You're videos are so easy to follow, I'm hoping to learn a lot more php and MySQL from future videos!
Bless you. This has been extremely helpful. I'm going to do the code and try it out but from your explanation, I'm sure things will work out. You are audible, clear, detailed and just the perfect person for this topic. Thanks so very much.
Love this channel, loved the explanation, loved the syntaxis, loved everything. Great work, you helped me understand few things. Anyways I have to improve. But the only way to learn is practice everyday
12:36 This code you're typing is extremely susceptible to SQL injection. You should never immediately put user provided data directly into a SQL string for any reason. You need to use prepared statements as well as validate all inputs
@@johnndees1397 As I mentioned you should be using prepared statements as well as validating input. I prefer to use PDO not the mysqli_* functions but if you're stuck with them then you can use the mysqli prepare functions. Here's an example from the PHP documentation: www.php.net/manual/en/mysqli.prepare.php
As always with your videos clear precise and easy to understand, thanks I have learnt a lot from all your videos. It would be great to see an update on how to convert this code to work with PDO and the new security as shown in your other video Password Security. I have tried a few times, but my knowledge is not good enough yet. I can get the updated way to hash but not yet worked out how to get verify to work. But this way works a treat thanks again!
I am not the best at PHP but how do I know if I'm "Logged in". Is there a session value or anything that I can use to see if the user is logged in? I want to do certain changes to my website when I am actually logged in. For example, it says login at the top right corner when I'm logged out and when I'm logged in it will say logout. Very good video! I was searching for a video like this for about 1 hour. Glad I found this video tutorial.
Hi Max. Check out my Login System video. If this doesn't answer your question, hit me up on Skype: Cooleditz - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE--7JdLn5gOfg.html
He podido seguir el procedimiento minuto a minuto. Su código ya esta especificado para PHP 7 por lo que no me dio errores en ningún momento. Llevo una semana tratando de implementar el sistema y siguiendo su vídeo lo pude implementar y adaptar a mis requerimientos en 2 días. Gracias. I have been able to follow the procedure minute by minute. Its code is already specified for PHP 7 so it did not give me errors at any time. I have been trying to implement the system for a week and following its video I was able to implement and adapt it to my requirements in 2 days. Thank you. (Google Translation).
Hi! Thank you for this great video. You showed us within 21 min what most other channels would have take 2 hours to explain and not with your level of clarity. Trust me! Your code works amazingly well. But one thing... I would like to restrict the emails duplication. I tried a thousand codes. Nothing works. Your help would be greatly appreciated. Thank you in advance!
The problem with copying and pasting source code is that those who do it almost never know how it actually works. Thanks for this excellent video and the clear explanation.
Fair comment, but it is also nice to know the tutorial you're following actually works before you invest the time trying to understand and learn from it.
this code is not updating becose am working from my domain what do i replace ($resultset->num_rows == 1) with so that it can update if($resultset->num_rows == 1){ //validate the mail by updating the database $update=mysqli_query($link,"UPDATE users SET verified = 1 WHERE vkey = '$vkey' LIMIT 1"); if($update){ echo"Your account has been verified sucessifuly. You may now log in"; }else{ echo $mysqli->error; }
The thankyou.php page is just an arbitrary page to re-direct the user to. It contains no PHP; just a page that says thank you. If you need further assistance, feel free to reach me on Skype: CoolEditz
i followed a 2hr tutorial and got it working. but with your 15min login and this 20min registration/email verify tutorials i cant get either working!!!
Help on the verify.php I entered word from word of your code however it skips the code and just says something went wrong. If I can email you my code could you tell me what I’ve done wrong. I retraced my steps and went very slowly .
That was just a semicolon ( ; ) error on line 29 provide the text with double quote to end the string and ; to end the statement. Here it is: what's in the video-----> echo "x y z what to edit-------> echo "x y z "; That's it it works well
Not working for me:`( does 'send email from localhost' videos all settings required for this process, or i should reset those files as default settings,,,
Yaw thanks for this amazing tutorial. I just have one problem and I will past the error message below. " Trying to get property 'num_rows' of non-object in C:\xampp\htdocs\web2 egisteration form\verify.php on line 11"
I followed and copied the code on this carefully but I find that the database activated status is being updated to being verified on sending of the email to the newly registered user, without the email link having to be clicked on. Does anyone else have this issue?
Hey Mike - It wouldn't be possible to update the verified flag when sending the email unless specifically coded to. If you'd like, I can look over your code.
@@phpBasics Thanks for your reply, very much appreciate that. Where can I post my code to. It's on a dev site and don't really want to throw url out there at the moment.
"Warning: Attempt to read property "num_rows" on bool in C:\xampp\htdocs egistration\verify.php on line 9 This is invalid" why is it showing this in my verify.php file?
I´m using pdo and got the error message "PDOStatement: Field 'verified' doesn't have a default value" (and got another one saying field vkey needs a default value too). I set null for vkey and 0 vor veriefied. when saving first user, vkey gets updated with the key. everything´s fine then. thanks!
Thank you for the video. Can you please make a video or explain how to auto verify an account without email verification or manual verification from the backend. I mean the system should automatically verify the new user account.
@@RacoonCH - You can run a query against the database to see if that username already exists. If you need help, feel free to message me on Skype: CoolEditz
Isn't there any other way of form validation?? Suppose we have 50+ fields in a form.. so we have to put validation on each field to check whether it is empty or not or the character length is correct or not. This will make the code lengthy
@@phpBasics sir if I want to add any payment gateway which can be rederect to the acknoledgement page with transuction id , name then what will be the procedure?
I have a video that shows how to set up sendmail for Gmail and Yahoo. You cannot send directly from localhost without a registered domain, so those you need an SMTP relay like Gmail.