Login system using PHP with MYSQL database
ฝัง
- เผยแพร่เมื่อ 24 ก.ย. 2024
- 🚀Download Complete blog Source Code for only $2: awamelvine.gum...
✨ Get notified when I release my upcoming premium course: codingpoets.com/
In this login video, I create a users table with fields id, username, and password. Then I inserted a user whose credentials I used to log in.
UPDATE: User registration with email verification on localhost: goo.gl/nRADcM
Check out my other videos:
Learn how to build a complete blog with PHP and MySQL: goo.gl/Ru41Tw
Tips for Junior developers: • Practical tips for Jun...
💥🚀Download Complete blog Source Code for only $2: awamelvine.gumroad.com/l/blog-source-code
can I use this for android studio
Hi Awa. Checkout my tool Filly - it will make your coding & lessons even better: fill.ly
we can use www.pl61.fr to learn 2020
th-cam.com/video/d1PdlScCVOo/w-d-xo.html
I learned more in 20 min with no chat than those 1hrs vid with guys talking a lot.... THANK YOUUU
I really like his voice. It's so calm
I could not hear anything, issue with the video
@Just Sliqq hello I can not hear anything issue with the video, any fix?
@@普拉达 Try refresh it, or connect to the bigger speaker in the basement. Special voice need special treatment
@@difanaufalpratama8765 hello I don't think this video has a sound I can hear on the other videos, thanks for the reply
@@普拉达 oh wait so you are being serious? I thought you joking too. This video really dont have sound sir
'Screams internally' -me as a professional front end dev watching a back-end developer create html/css.
Just kidding, thank you for taking the time to make this video, it's been helpful.
Bro, my code don't work, could you help me...
Here is my code :
Login
Username:
Password:
@@zariaa3794 First its
not
there is no body tag in your code how will hit work??
it should be like
Login
Username:
Password:
@@zariaa3794 You should spend some more time in Html First, I was there, travers video are pretty good you can learn from it.
Im a backend developer and see no problem with this man's html/css. lol.
@@acos21 then you're a shitty back end dev then
Great instructional video!!
It took me some time to tweak the code to suit my existing database. This initially gave me a result of "Failed to query database No database selected" until I worked out that I needed to change "login" in Row 14 of process.php to my own database name.
As a starter in mysql and php, some voice-over would be helpful in explaining such things.
my database name is "login" although its giving me the same"Failed to query database No database selected"
Meenakshi Panyam maby the database isnt a localhost of urs?
didn't work :/, got an error on line 9 of process.php regarding the mysql_real_escape_string. Anyone know what to do?
mine too
This login is easy to bypass. If a empty post-body is sent, then it won't find a row in the database. This let $row['username'] be undefined, like $_POST['username'], too. So you're able to login with an empty post-request. There is also no reason for comparing the post with the databse result, because if the user / password - combination is invalid, then the database will find no row and the function mysql_num_rows() returns 0. Then some thinkings. It's a real good option to use PDO. Because the c-style mysql api is deprecaded and was removed in php 7. With PDO it's possible to use prepared statements for re-using queries and for letting the database escape the user input.
most of the videos skip the process of creating cd: but after I hve watched this I understood one basic function that I had stuck for days great one
Fatal error: Uncaught Error: Call to undefined function mysql_real_escape_string() in C:\xampp\New folder\htdocs\process.php:10 Stack trace: #0 {main} thrown in C:\xampp\New folder\htdocs\process.php on line 10 how to solve this error
I also see this information. How to solve it?
me to
What should i do here ?
Fatal error: Uncaught Error: Call to undefined function mysql_real_escape_string() in C:\xampp\htdocs\App\process.php:8 Stack trace: #0 {main} thrown in C:\xampp\htdocs\App\process.php on line 8
nice, but there is one very important issue. if you do not place any value and hit login button, the message is still 'Login successful!'. There is missing logic in php for this event.
Therefore:
$row = mysql_fetch_array($result);
if ($row["username"] == $username && $row["password"] == $password *_&& ("" !== $username || "" !== $password)_*) {
echo "Login successful! Welcome " . $row["username"];
} else {
echo "Failed to login!";
}
_===_ means *identical*, _!==_ means *not identical*
Thanks!
fixed by isset() and !empty() functions
yup you are correct man they have not done the proper validation.
Just add "required" in html input tags
kindly past below code. I have check its working fine
if($_POST['username']=='' && $_POST['password']==''){
echo "Please fill all the details";
}
else if($rows['username']==$username && $rows['password']==$password){
echo " login successfully ".$rows['username'];
}
else
{
echo "incorrect password";
}
?>
I'm not quite sure as I'm not primarily working with PHP in my free time, but isn't it absolutely unnecessary to state
if ($row['username'] == $username && $row['password'] == $password) {
//Print
}
As this was already defined with your SQL query.
The SQL query will be empty unless both the username and the password match, because only cases where both match on the same row are going to be fetched.
As such, instead of running a redundant check, you can just go ahead and use
if(!empty($row['username'])) {
echo "Login successful";
} else {
echo "Login failed";
}
Or alternatively
if($result->num_rows != 0) {
echo "Login successful";
} else {
echo "Login failed";
}
This is a rather minor thing, but I think it's good to note there's no reason to explicitly state that.
Instead of checking for two variables, you can just check whether there is no data.
As for the people struggling with mysql_real_escape_string, I would suggest trying out
$password = mysqli_real_escape_string($conn, $password); //Conn being the connection variable established before
As I'm not sure if the issue lies with mysql being deprecated.
For simple syntax issues, it might be best to read what the error message says and you'll get far.
The line where it points at will give you a lot of clues as to how to solve these issues, then it's just fixing whatever small issue there was, such as a misplaced bracket or forgetting to close a string.
Fatal error: Uncaught Error: Call to undefined function mysql_escape_string() in C:\xampp\htdocs\login\process.php:8 Stack trace: #0 {main} thrown in C:\xampp\htdocs\login\process.php on line 8
Ya, I have same Issue. My is :
Fatal error: Uncaught Error: Call to undefined function mysql_real_escape_string() in C:\xampp\htdocs\login\process.php:8 Stack trace: #0 {main} thrown in C:\xampp\htdocs\login\process.php on line 8.
@@sumanclick2979 Yep same
@@ehhniko did you found a solution?
Salaam There is not actually. Old syntax used in the video, not compatible with the new versions.
In new version php, now we use mysqli, not mysql again...
$dbname = mysqli_connect("localhost", "root", "", your-database_name");
$username = mysqli_real-escape_string($dbname, $_POST['username']);
Thank you! You exactly showed what I've been looking for after hours of searching! I went to almost every forum there is and no one even tried to explain this exact, "$result"-"$row" technique and the comparison from database to php-variables, to me. Very nice. You deserve a thumbs up ^^
this tutorial just helped me a lot with my homework!
thanks steff!
th-cam.com/video/d1PdlScCVOo/w-d-xo.html
Thanks my friend. Great video. I'm from Brazil. Your video help me. My english is not so good, but I can understand your video.
Dont be shy buddy! Nothing can be worse than a tutorial without voice!
Hahaha I've grown out of my shyness. My recent videos now have voice.
Thanks by the way
@@AwaMelvine Awa you're best my friend .
This is one of the most depressing but productive video i have seen
he should have used the voice
This this video make you the depressed child that you are now?
#Rondytech on iG just got my ps4 account back in less than no time, I appreciate her good works 🙌🙌🙌🙌
plz help me..i got this error massage.what can i do..plz reply..
.Fatal error: Uncaught Error: Call to undefined function mysql_real_escape_string() in C:\xampp\htdocs\login\process.php:9 Stack trace: #0 {main} thrown in C:\xampp\htdocs\login\process.php on line 9
use "mysqli_real_escape_string()" instead of "mysql_real_escape_string()" or reduce the php version
iam facing an issue amd it shows 'uncaught error: Call to undefined functions mysql_real_escape_string($username);'
i checked each and every code but still facing a that issue
same... and idk why
@@mohamedhassani160 mysql stopped being used for php greater than 7 so you need to use mysqli syntax
You have to implement a function named stringCheck. The value of the variable input is a string BIYPR2978H. The string must have ten letters. When stringCheck is called, need to check 4th letter is P, 6 to 9 should be Number and last letter should be an alphabet. If any condition is false, you can print the error message. How would you implement this function?
I was searching for the movie "A Quiet Place 2". And then I found this.
LOL
without saying a word... taught a great lesson...
th-cam.com/video/d1PdlScCVOo/w-d-xo.html
Thanks to the author of this tutorial: I couldn't with other tutorials using mysql_num_rows.....and stuff.
:)
i have some problem it says
Fatal error: Uncaught Error: Call to undefined function mysql_real_escape_string() in D:\XAMPP\htdocs\parkiran\pro_login.php:9 Stack trace: #0 {main} thrown in D:\XAMPP\htdocs\parkiran\pro_login.php on line 9
i've been searchingon forum they said that mysql_real_escape_string() function was deprecated since php 5.5 do you have any solution?
it's old PHP Syntax "mysql " is deprecated.
that is not true. MySQL is still updated as of today, but it got aquired by Oracle.
@@Kasrasfriedchicken soreplac all instances of mysql with stupidoraclething
@@Orincaby idk man what this even was, it's two years old. I was trying to be smart even when I have no SQL knowledge. Forget about this statement
@@Kasrasfriedchicken me neither
I d like to ask why you made two rows of code per html, php sql escape rather than just writing the code once. I am a newbie and am wondering why the extra steps. To me it seems like you connected to the site first, the sql procedures second and 3rd the db connection. $useto = mysqli_real_escape_string($db, $_POST['useto']; Thanks in advanced!
Sorry to say, but its so unfinished and not safe at all.
1. If the POST is empty the user is still able to log in although this can be solved with "if($_POST == null)"
2. The password isnt salted/hashed, which means if someone logs in on the databse it will be pretty insecure
+Direct Gaming To check if post is set:
if(isset($_POST["name of input"])){
Do the stuff here;
}
To encrypt/hash:
hash: $password = md5($password);
encrypt: $password = crypt($password);
and then use the MySQL Query, but the password has to be stored in the database as a hash/encryption.
+Direct Gaming imgur.com/a/JLsIv < I made these two screenshots of my code with as much documentation as possible, if you have any other questions. Ask me on skype: itzthesimon
+Sn11p33r Thanks for your feedback. I'll make a better version soon
I made a better version of this video. Here, check it out: th-cam.com/video/lGYixKGiY7Y/w-d-xo.html and thanks for watching!
Can you help me !!
Why Welcome message is displaying when there are errors in the process.php file? Why ELSE statement not working?
Uncaught Error: Call to undefined function mysql_real_escape_string() in C:\xampp\htdocs\login\process.php:7 Stack trace: #0 {main} thrown in C:\xampp\htdocs\login\process.php on line 7
I have the same error. Did you find a solution?
@@user-vt1pv6ci1i Try mysqli_real_escape_string() instead
Amazing Awa , lots I learned from ur tutorials best teacher style. I 😘 it
Hey
Are the names correct you are using in $POST[' ']; statement."
as you have used user for $username and pass for $password in the form.
Please check and reply soon.
Thanks
Yaa bro it’s not correct I stucked there almost 40 min
Great tutorial, however just to point out. It was actually the name attribute that is used, rather than the id in $Post[' ']; that caused the undefined index notice in your script.Very helpful though giving you a thumbs up.
i got error, pls help thanks.
Fatal error: Call to undefined function mysql_real_escape_string() in C:\xampp\htdocs\login\process.php on line 9
you can change the mysql to mysqli in all the functions. cause newer versions of PHP doesn't actually supports the mysql function.
@@aarushsharma5966 actually by keeping mysqli it is also not working
@@kirankumar-kz4kc hi, did u find a solution?
How to solve it?
same
The value of the variable input is a string 458,2,30,4.9,58.2,6,7.2. Write a function to get the sum of integers in the string?
sir could you please ans the Q
I literally copied everything from the beginning to end, there is always an error.
This tutorial just helped me a lot with my homework! Thanks
you real man
Wait what? Are you storing passwords in plain text?
you can just find an online password encrytor..
invalid cross php comes with a built in function called md5 (which is an hashing algorithm) so when you create the register page before inserting the user infos you do $pass = md5($pass); and then on the login page, before checking if the password is the same as the one in the database you do the same thing to check if the hash of the password is the same
Easy to understand.
It would be great if you would have explained it.
The code worked for me.. Thank you !!
Finally I found the best video on TH-cam
Thanks for this video. Was exactly what I needed.
Please noooooooo! everything is bad drom this video!
Great tutorial mate. Although I just uncovered a fatal shortcoming. when you leave the username and password fields blank, the web page will log you in regardless. Is that a fault on my end?
Thank you very much for this tutorial: Great!
Your tutorial is clearly showing how and where to create the files code and how to display them for testing in a browser, Well Done.
Nevertheless, there is a problem with error handling. I just tried to do a test by entering a wrong username and password to see the result. And then it created a big issue!
you have to forget everything from this video because its horrible, horrible and very horrible
i am getting error at this line
$result = mysql_query("select *from users where username = $username and password = $password") or die("Failed to query", mysql_error());
error is: Parse error: syntax error, unexpected ',', expecting ')' in C:\xampp\htdocs\process.php on line 20
not able to find solution..kindly suggest appropriate answer
die("Failed to query".mysql_error());
There is no comma inbetween....use dot....hope it works :)
why didn't u use MySQLI commands
and for what versions of php this code works
Parse error: syntax error, unexpected ')' in C:\xampp\htdocs\Login\process.php on line 10
what that's wrong
When I press login nothing shows up there is no writing?
lol i realized that it was blank for me coz i entered the html into the process.php folder rather then login.php
same for me
haoh
haoh h
haoh hc
ignoring the fact there's no audio in this tutorial, this is a great tutorial. 1 thousand people who dislike this is a spoiled brat
DO NOT FOLLOW THIS TUTORIAL FOR A REAL-WORLD PROJECT
If you want to see what a developers workflow is like, this video does a great job of demonstrating.
But the actual code is very likely to break and it uses really outdated procedures, even for 2015.
Please find yourself another tutorial made in the last 6 months or so.
Preferably one that teaches you about password hashing, prepared statements, and writing functions to reduce messy duplicate code.
Or better yet, find a framework you can use that takes care of database stuff for you. There's no sense in re-inventing the same thing all the time when there's hundreds of options out there to make your job easier, your code more secure, and your time better spent. For free.
@@kevintran2516 Your age might be starting to show somewhat then
@@itsmarsu oof
@@kevintran2516 you mean ur not even using password hashing.
Fatal error: Uncaught Error: Call to undefined function mysql_real_escape_string() in X:\xampp\htdocs\db_test\process.php:15 Stack trace: #0 {main} thrown in X:\xampp\htdocs\db_test\process.php on line 15 pls help
Same problem, help us please
use mysqli_real_escape_string() NOT mysql_real_escape_string()
@@Dxntoo still it doesn't work
Uncaught Error: Call to undefined function mysql_real_escape_string()
Got the same error ...
How to fix this....
same
Same for me
Same error. Pls help
Failed to query database Unknown column 'password' in 'where clause', please help me bro
is this the renaissance of janky 2008 youtube tutorials?
Only Missing NCS song ;-;
Which version of xamp you used in this video , i'm using the same process the same code but im getting an error "Fatal error: Uncaught Error: Call to undefined function mysql_real_escape_string() in C:\xampp\htdocs\login\process.php:7 Stack trace: #0 {main} thrown in C:\xampp\htdocs\login\process.php on line 7" .....................................plzzzzzzzzzzzz help!!!!!!!!!!!!!!!(important fo my project)
18 mins of silence...... in my life
you forgot ads
fuck off
@@gustavomeatto365 Gustav streesemann???
Jajajajajajaja
@@zhaoqinyin5480loooooooooooooooooooooool
nice video thxs sir but sir postsuch a video in that video if any one register the form ..then that data of the person save in database show the owner of the any website or etccc......
Good video, but pro-tip. Set it to playback 2x the original speed.
can you tell me which editor you are using
and many thank for your description is more than enough
Fatal error: Uncaught Error: Call to undefined function mysql_real_escape_string() in C:\xampp\htdocs\login\process.php:9 Stack trace: #0 {main} thrown in C:\xampp\htdocs\login\process.php on line 9
DDT Gaming use mysqli instead of mysql
@@meghanareddy8362 i have solve it.. Anyway tq for the reply
I have this error too
@@codeflex5180 use mysqli instead of mysql
@@nvae1502 Thanks for a lot! It's work!
Failed to query database 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 'where username = '' and password = ''' at line 1
I don't get this. Can you help me to solve. It kinda freaking me out !
its not working, failed to query database No database selected
change the database with the name from yours
Done same codeing but shoing fatal errors in 2020
This was a very useful and helpful video understanding. Thank you so much for creating this one. keep it up and all the best.
getting this error
Fatal error: Uncaught Error: Call to undefined function mysql_real_escape_string() in C:\xampp\htdocs\login\process.php:7 Stack trace: #0 {main} thrown in C:\xampp\htdocs\login\process.php on line 7
Me too
mine too
@Rainiel Gwapo Could you explain why?
@Rainiel Gwapo so the i behind mysql isn't like made up. It really is needed and can't be another letter? Thanks for the quick reply!
@Rainiel Saclay like how i change it to mysqli but still not working ):
How to print report to dot matrix printer sir? Could you advice me
Parse error: syntax error, unexpected '$username' (T_VARIABLE) in C:\xampp\htdocs\login\process.php on line 20
PLEASE HELP ME
echo "Login success, welcome! ".row['username'];
Maybe you missed a ";"
you have missed a semicolon
hi process.php line 9 Eroor how fix code plz
The page isn’t working
is currently unable to handle this request.
HTTP ERROR 500 getting error
same
same here. did you solve?
because guys he is using the old commands for MySQL if u have newer version of PHP it won't work
it will work for the connection but some codes are written differently it won't work even if you change it because other error will pop up
look I don't need to do it cuz I can write it myself this video showed up in the suggestion bar and I click it just from pure interest to see how many people will have errors and I was right almost 90% of the comments is about the same issue that is occurring
what should i do i i am using ubuntu. I dont have the htdocs folder to create file into,which folder should i do it
got an HTTP Error 500
same
Have u installed PHP?
IDK who you are. But I have to say. You are a GOD.
This video is severely outdated, unhashed passwords and old deprecated mysql extension, and old methods
p.s. i know there's a better version out there
can't you see it was uploaded 2015...what do you expect hater?
Thank you so much...Your Video is so much useful. I am always grateful to you....Best of luck...........
this is helpful. tho i need to use mysqli instead of mysql
dear where we print login successfully then how we can put a query which update records who has entered username and password
congratulations, but I ask for this configuration file or login and index and css etcc all these files to log in where should they be installed?
in phpadmin from menu import? and how do i connect url login file
to my domain on the webpage sl login button? where do i find url of the login file?
Thank you
Does the folder need to be saved in the exact location? I'm working on a macbook so don't have that file? And the login file is .php, should it work if it was .html?
I get this error:
Failed to query databaseYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'table where username = 'username' and password = 'password'' at line 1
What should I do?
sir ham jo movies downld krte h woh lcd p not play
why is your php code giving me a deadloop of: echo "Connected successfully"
It would be better if you can if videos are zoomed in showing only the coding instead of the whole screen. It's difficult to read it watching from an average handset. Or perhaps increase the font size
mysql_real_escape_string: This extension was deprecated in PHP 5.5.0, and it was removed in PHP 7.0.0.
Hey Ian I am not familiar with the new Javascript syntax, what resource would you recommend to a person that is taking the web dev boot-camp course and wants to know how to write new javascript syntax and see how it is written now compared to before? also, another question, if a potential employer sees our version of yelp camp written with old javascript syntax from the course, would this be viewed negatively? thanks in advance brother.
pls help me what is this failed to query databaseTable 'login.users' doesn't exist
Thank you for taking the time do complete this video.. much appreciated.
is this live call recording? in india?
With CSS hero if you change anything on the pages, does it change the CSS code across the site or just that page you are on? I would be afraid it could modify the whole site. Let me know.
I have a problem. When I click login the whole php code comes up in the new web page.
bom dia tenho um projeto aqui em casa com arduino uno para abrir o portão de casa pelo celular, agora quero colocar a minha camera do dvr intelbras na mesma tela. para quando eu ver a camera poder apertar o botão do portão. mais não estou conseguindo, pois não consigo dar player no rtsp . o que eu faço ???
please i dint know why but i got this error "Uncaught Error: Call to undefined function mysql_real_escape_string() in C:\xampp\htdocs\" .please how to i solve it
Can you have with this approach? Or it's not necessary to track session on the main login page?
i have error from this film when i make a login page like your login page !!!! why?!
it was like watching a good Charles Chaplin movie. Applause!
please i do the same code but i have this problem:
Fatal error: Uncaught Error: Call to undefined function mysql_real_escape_string() in C:\xampp\htdocs\login\process.php:9 Stack trace: #0 {main} thrown in C:\xampp\htdocs\login\process.php on line 9
How fix it??
sir aap jab AND base pe query use kar rhe ho than no need to compare the username with the form data bcz if you enterd the correct data than only the query return something otherwise there is no data in row....so make code lesser
Thank u a lot! By the way, we are writing the year 2021, is this method still secured? I heard about that you can use MySQL Commands in the login input
Parse error: syntax error, unexpected 'OR' (T_LOGICAL_OR) in C:\xampp\htdocs\practice\process.php on line 18
yes same,
do you know the cause?
please help
mysqli_real_ecsape_string its has error that : "unfiend" or " expected 2 arguments" like this error.. does anyone know this problem?
My login page isn't showing up.
After giving localhost/mywebsite/loginn.php it's showing blank page any idea why?