How to Make Login Form in PHP and MySQL
HTML-код
- Опубликовано: 30 сен 2024
- PART 2 : Registration System -- • Complete User Registra...
PART 3 : PHP Profile System Change Password
• PHP Profile System C...
UPDATE: Secure Login system using PHP with MYSQL database
• Secure Login system us...
In this video we are going to build Login, Logout and Profile System Using
PHP,
MYSQL ,
HTML and CSS,
www.youtube.co...
Source Code
github.com/cod...
Login System Tutorial with PHP and MYSQL Database
Login system using PHP with MYSQL database
#Login System Using #PHP and #MYSQL
How To Create A Login System In PHP For Beginners | Procedural MySQLi | PHP Tutorial |
12:12 Creating DataBase (id , user_name, password, name)
13:34 Creating db_conn.php
19:42 Creating home.php → session_start();
thank you! I need it now!!!
*
👨💻 The Source code is under the description
Please 📝 comment on this video and ❤️ Subscribe
I thought php is dead?
@Web Me Checkout part two of this video
@@kyrierevival3658 same thought
@@kyrierevival3658 laravel change it
Not sure if you'll read this, and it is unusual compared to other comments, but I actually like the song. What is it? 2005 Classic Hard Trance vibes to it.
I wish you were verbally discussing parts for more understanding for newbies like me. But thank you for this tutorial anyway. It was a great Help. May God bless you 3000 brother
BE CAREFUL using this software in a production environment (Anywhere public basically). If the database gets breached, all stored passwords will be exposed as they are stored in plaintext! Passwords should NEVER be stored this way in a database, ALWAYS use PHP functions like password_hash() and password_verify()
This is really helpful for my assignment!
Example if I create a new page "home" just write zzz.com/home and you can skip the login page.... ):
No, You can't skip as long as you put session stuff in there like
------------
YOUR Page Content
-----------------
great work keep it up bro you will reach one day 100K subscribers and i am one of your subscribers i am Eng.Mohamed Azhari from Somalia am Cisco Engineer, Cloud Engineer like AWS, Azure and OpenStack, also programmer.
This is tutorial is perfect for us beginners. Thank you very much! it really do helped me a lot! Thanks!
Indian Guy youtube is very helpful and all, but I never realized just how immured I am to having to listen to them till I found your video. Excellent work of being able to show the process without needing narration - it was a pretty chill way to learn. Thank you very much!
EDIT: Dude, send me your playlist - its so jammable that I'm just boppin my head while typing RN.
thanks.
Exactly bro, no need for narration. The video speaks for itself, excellent work
Exactly bro, no need for narration. The video speaks for itself, excellent work
Exactly bro, no need for narration. The video speaks for itself, excellent work
Sir I have an wierd error, whenever I login email &password it's give me error "invalid email & password" any solution Sir I even copy from my Sql db still same error any solution I will be thankful to you
checkout the source code
after i login i stucked at a white page(login.php) not continuing to home.php
how can i resolve this..?
checkout the source code
Thank you brother ❤
I struggled to learn How to validate From Table 😢After These video I realised Today Thank you so much ❤
thanks
16:32 isn't working on me its says mysqli_num_rows() expects parameter 1 to be mysqli_result how do I fix this?
check your PHP version it should be php 7 or
@@CodingwithElias my php version > 7
@@CodingwithElias help please
@@vatbros7162 check out the source code under the description
Uncaught TypeError: mysqli_num_rows(): Argument #1 ($result) must be of type mysqli_result, bool given in D:\xaamp\htdocs\phpproject\login.php:28 Stack trace: #0 D:\xaamp\htdocs\phpproject\login.php(28): mysqli_num_rows(false) #1 {main} thrown in D:\xaamp\htdocs\phpproject\login.php on line 28
Not a perfect way for making login form. You have to create css before complete the coding.very bad 👎for beginners.
I'll fix that in the future video's, thanks for your comment
It's mentioned php and MySQL it's for ppl who already know frontend and trying hook it up with a backend for your so called css queries watch a front end tutorial 👍🏻
are you really? *unmae: root (what's the code?)
¯\_(ツ)_/¯
It's just tutorial. I'm just making things simple, for learning purpose
@@CodingwithElias it will be troubleshooting for newbie bro
thanks teacher
I’m saying this from the bottom of my heart: THANK YOU VERY MUCH!!!
RUclips
ruclips.net/video/wdIN5eHJIQE/видео.html
Man you are badass
Thank you! 🙂
Thank you so muchhhhhhhhhhhhhhhhhhhhhhhh
I followed your tutorial and it works, but how can I create an api for this? can you give me some hints or sample on how can I achieve an api for this.
I'll Make Video on That, Thanks!
Bro why don't auto complate html tags in php
text editor feature.
It helps me a lot 👍👍👍
Is there any Swinburne Student here ?
Hi
thanks...
verry good bro
Parse error: Unclosed '{' on line 10 in C:\Users\User\Documents\BIS YEAR 3\XA\htdocs\Login-Form\index.php on line 23. Please help out I've followed the code accordingly but I keep getting that error
Check out the source code under the description
thank you so much!
Elias 😡you're
Great
let him cook
I dont know why, but I am getting error at $result = mysqli_query($conn, $sql);
Please anyone help me solving this.
Thank you this video is very help for my project
I hate how my VS keep showing wroNGLY but it dOES HeLP HAHAHA
Use sublime text (:
I was the thousandth sub, congrats.
thanks
thankyou so much love, deserve a sub
How to resolve this "#1062 - Duplicate entry '0' for key 'PRIMARY'".
Wow good coder i learn alot i love you
thank you so muchhhh
Thankyou,, work 😭🤲
thank you dude
hello, I follow your sources. But when i try to login. It keep going to the same page ( Index ). After i remove php script in Home.php, It can be login.
How do i find the problem and where do i can fix that problem? Any suggestion?
Watch my new video. called "Secure Login system using PHP with MYSQL database"
Uncaught TypeError: mysqli_num_rows(): Argument #1 ($result) must be of type mysqli_result, bool given in D:\xaamp\htdocs\phpproject\login.php:28 Stack trace: #0 D:\xaamp\htdocs\phpproject\login.php(28): mysqli_num_rows(false) #1 {main} thrown in on line
Checkout the source code under the description
I make it but I have problem that is the passwrd not matched same my password that I insert in the form also insert diffrent password in database .....can you help me in this
everything was going smooth, then I started encountering errors with mysqli_num_rows() and mysqli_fetch_assoc(). I reviewed the code in the description but did not help. after researching it, it seems it is a common problem and its due to those functions no longer being available in the recent php update, what are some alternatives, or replacements we can use. These are the only things holding me back from completing. and it reads the error "Fatal error: Uncaught TypeError: mysqli_num_rows(): Argument #1 ($result) must be of type mysqli_result, bool given in C:\xam..." please help.
it works fine on PHP 7
maybe reinstall your xampp server
14:35
Love you man! I am amazed with your skills!
Thank you so much! Probably the best and most enjoyable tutorial for me. You earnt a sub.
I had so many errors because I used different variables and I am confused 🤯 hahaha, but still, in the end made it, thank you so much for this.I learned many things. This is very big help for our school proj.
I feel that. Typically now, I use the same variables while following the tutorial and then changing them after while I customize the result.
Very nice thank work Elias for learning me this simple . You just safe me from givin up on this .
How about if both Username and Password are empty, how to add an error message saying "Username and Password required" instead of only "Username required"?
if (empty($uname) && empty($pass)) {
header("Location: index.php?error=User Name & Password required");
exit();
}
else if(empty($uname)) {
header("Location: index.php?error=User Name is required");
exit();
}else if(empty($pass)){
header("Location: index.php?error=Password is required");
exit();
}else{
Login in mobile roblox
Bro I have droughts in php how can I contact you
eliasfsdev@gmail.com
Wow I really proud of you.
This video solve my problem.
It is Best video.
dil se dhanyawad
This tutorial is awesome its easy to understand and he also provide a source code. Thank you very much man!!
nice
🤓 Thanks
Thank you
you are the best for beginners really appreciate ❤️
pleace put on description login form
Thank you it really help me, this tutorial perfect for us beginners on PHP and MySQL
thank you bro
Hi I am really new to MySQL and PHP. I understood that everything you showed here. But I am not sure how can I get into the PHPMyAdmin page after logging in. I have a total of 5 users and what I need to make sure is, that each user will only be able to access the data they input. Can you please let me know or direct me to your tutorials if you have any.
Check out the link in the description
sir pls help '"Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result"
Hi! thanks for your comment
check out the source code under the description.
How did you fix this? Mine has done the same so wont run
Thank youuuuuuu, you just saved my ass :-)
I can't stop crying, you helped me so much, thank you very very much. ♥ i love you
Thx ;)
How to do login for multi user?
Checkout may video on this channel called "Multi User Role Based Login System Using Bootstrap 5, PHP & MySQL
"
QUESTION @ 18:00 why do you validate the username and password again with the if statement? Doesn't the SELECT statement do that already?
yeah. you're right but it's not going to be case sanative in the way. thanks I appreciate your comment
@@CodingwithElias Ah, ok! Thanks Elias
thank you
: Uncaught TypeError: mysqli_num_rows(): Argument #1 ($result) must be of type mysqli_result, bool given in C:\xampp\htdocs\grup4\login.php:28 Stack trace: #0 C:\xampp\htdocs\grup4\login.php(28): mysqli_num_rows(false) #1 {main} thrown in on line
Yeah I got this error too while trying an SQL injection. Did you find out why it shows up?
I love your job 3000
I got this output, what does it mean? I follow everystep from ur tutorial ------->Fatal error: Uncaught Error: Call to undefined function mysql_num_rows() in C:\xampp\htdocs\MIS\login.php:33 Stack trace: #0 {main} thrown in C:\xampp\htdocs\MIS\login.php on line 33
Update your xampp
thaaaaaaaaaaaank you for this and for the code source thank you it worked
Thank you very much bro❤❤❤you saved my internal marks🥹🥹
are you from new zealand? I have internal assessments here
this was an easy tutorial to understand, .. thank you
Fatal error: Uncaught mysqli_sql_exception: Access denied for user 'root'@'localhost' (using password: NO) in C:\xampp\htdocs\php programm\db_conn.php:9 Stack trace: #0 C:\xampp\htdocs\php programm\db_conn.php(9): mysqli_connect('localhost', 'root', Object(SensitiveParameterValue), 'test_db') #1 C:\xampp\htdocs\php programm\login.php(3): include('C:\\xampp\\htdocs...') #2 {main} thrown in C:\xampp\htdocs\php programm\db_conn.php on line 9. how to fix this error😪
Check your server settings
sir. when i sent my login files to my friends (followed your code), it says "incorrect username & password" for them. but its only me who can log in successfully. how can i fix this sir? :(
check out the source code under the description
Please help help!!! 🥺1 problem ho Rahi ha code may wahan say run nhi kr raha anybody ????
thank you sir
Absolutely perfect, every single step in this video worked flawlessly for me. Subbed and liked!! would you ever consider a playlist of tutorials on learning php or other coding languages? sorry if you have already done this.
I hope you will see this comment
I just wanna ask if that validation() function can be used in vs code?
Cause i tried it right now and it seems like it doesnt work and i don't know what to do anymore
And i can't call my varibale from the html file to the php file using the isset($_POST['(variable name'])
Please help
check if you add name attribute
Sir Can i ask where can you find the Test_db.sql in folders?
The link is under the description
💯 perfect....pls how can I implement blowfish algorithm and Aes algorithm for storing files using php
I've no idea, sorry.
it is not understandable for beginners because it is not verbal and also all steps from start to Ende is not Clare stapes are not seen so that we can search other material to understand this material please insert detail stapes for other material tank you
Check out my new video on this topic
Thanks alot. Really helped me. Please can you do a sign up page for this same login page?
link under the description
everything is good but i have a question, i want to make the register form now , so should i continue with those files or what?
Yeah, sure
how do you add security level for example admin and user
hey by the way and thank you
I'll make video about it soon. thanks
Thank you elias! this video help me for my laboratory.
Glad to hear that!
I have a problem because everything in XAMP works for me and when I want to transfer it to the hosting server, I cannot log in as a user in the database.
Check database configuration file
thanks now i can finally make login
i guess i am the only one whose code doesn't work
this happen all the time , just check your code it very carefully
In the part on 16:54/24:05 where you wrote if (mysqli_num_rows($result))
And you echo hello
Mine did note show hello it was blank
hello elias i have tried running the login button but it does not redirect me to the home page i have even copied and pasted your code but it still wont direct me to the home page it just refreshes and nothing happens could you help me please.Thank you
Check out part 2 video. The link is under the description
I hope make addition on this video like Two Factor Authentication by sending massage on you
maybe one day
thank you so much Bro
You're welcome!
i am stuck at 10:52 ..where you add an error msg in form .i have tried everything chekced all the code same as yours no error msg but my error box doesnt show up on the form .please help.thnanks
if it's not crear check my new video called "Secure Login system using PHP with MYSQL database"
Does everyone has any problem like mine which the url web is not working. It says error here like not found however how many times itried
Check out the source code under the description
sir its displaying this error while saving the database #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(`id` INT NOT NULL , `username` VARCHAR(255) NOT NULL , `password` VARCHAR(25...' at line 1
What did you do in the minute Is it an acronym?18:24