'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.
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.
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.
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*
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_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
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.
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 ^^
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
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
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?
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.
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']);
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?
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!
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!
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.
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
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
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
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
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
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.
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
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?
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 please help me
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
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
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.
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 !
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
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)
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 ???
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?
Same issue yesterday, tech support for 30 minutes... went this morning traded in cable box, it worked for 20 minutes, Please Wait, called tech support, suggested reboot, You mean where I unplug the box, wait 1 minute, plug back in, L-9, L-8, L-3... Please Wait, scheduled a noon-1pm for Tuesday tech to come out, must tell boss my tv is more important than the job. If he had his priorities straight he would understand.
Is there an updated version that one can use for php 7, the syntax mysql_fetch_array was removed in php 7 , tried just changing it to mysqli_fetch_array but it didn't work. Please help ASAP. error: Parse error: syntax error, unexpected '$row' (T_VARIABLE) in C:\xampp\htdocs\login\process.php on line 19
💥🚀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
ruclips.net/video/d1PdlScCVOo/видео.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?
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
I was searching for the movie "A Quiet Place 2". And then I found this.
LOL
without saying a word... taught a great lesson...
ruclips.net/video/d1PdlScCVOo/видео.html
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 .
Finally I found the best video on RUclips
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.
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.
this tutorial just helped me a lot with my homework!
thanks steff!
ruclips.net/video/d1PdlScCVOo/видео.html
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
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_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
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.
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 ^^
Thanks to the author of this tutorial: I couldn't with other tutorials using mysql_num_rows.....and stuff.
:)
Amazing Awa , lots I learned from ur tutorials best teacher style. I 😘 it
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
it was like watching a good Charles Chaplin movie. Applause!
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: ruclips.net/video/lGYixKGiY7Y/видео.html and thanks for watching!
Can you help me !!
IDK who you are. But I have to say. You are a GOD.
is this the renaissance of janky 2008 youtube tutorials?
Only Missing NCS song ;-;
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?
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']);
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?
The code worked for me.. Thank you !!
Thank you so much...Your Video is so much useful. I am always grateful to you....Best of luck...........
Good video, but pro-tip. Set it to playback 2x the original speed.
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!
Thanks for this video. Was exactly what I needed.
Please noooooooo! everything is bad drom this video!
Easy to understand.
It would be great if you would have explained it.
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
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.
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
This was a very useful and helpful video understanding. Thank you so much for creating this one. keep it up and all the best.
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
Thank you for taking the time do complete this video.. much appreciated.
18 mins of silence...... in my life
you forgot ads
fuck off
@@gustavomeatto365 Gustav streesemann???
Jajajajajajaja
@@zhaoqinyin5480loooooooooooooooooooooool
THANKS A LOT! Helped me with our final project hahaha
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
wow so fast we created a login page !!!!
why didn't u use MySQLI commands
and for what versions of php this code works
An amazing work man even without a voice you make it easy to understand and read, many thanks man'
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
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
Bro! it's Amazing You slove my problem! Thanks!!!
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
Thank u, it is very informative for me, it is more better when audio voice is included to this video tutorial
Thanks for watching. I will try to use audio next time.
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
I will download it right now, thanks for your always so good and quality work.
ruclips.net/video/d1PdlScCVOo/видео.html
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
super knowledgeable this video is ..thank you
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!
thank you very much. very helful tutorial for beginner
its not working, failed to query database No database selected
change the database with the name from yours
what a brief tutor bra
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
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
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.
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
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?
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 I got it to work because of you and a few changes
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 please help me
same problem
It was very helpful
Thanks Mate!
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 ):
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
got an HTTP Error 500
same
Have u installed PHP?
Thanks for example. It was very sample and very useful
Exlent tutorial....THQ Sir........
thanks very much for this tutorial....
this is helpful. tho i need to use mysqli instead of mysql
it is really helpful to our project
Why Welcome message is displaying when there are errors in the process.php file? Why ELSE statement not working?
Parse error: syntax error, unexpected ')' in C:\xampp\htdocs\Login\process.php on line 10
what that's wrong
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.
It worked well enough.. Perfectly working. Thanks a lot!
This code is insecure.
Awesome video. II had to try it And can do so thanks very much, I will follow you to the next video.
thank you bro you help me a lot for my project ....
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 !
very nice explanation... thanq...
This video really help me a lot
Very useful ,thnx, keep upthe good work...
Can you have with this approach? Or it's not necessary to track session on the main login page?
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 :)
simple, easy and u r great & thank u.
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)
Thanks! Dude you saved my project :)
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 ???
It was really helpful. Thanks!
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?
Same issue yesterday, tech support for 30 minutes... went this morning traded in cable box, it worked for 20 minutes, Please Wait, called tech support, suggested reboot, You mean where I unplug the box, wait 1 minute, plug back in, L-9, L-8, L-3... Please Wait, scheduled a noon-1pm for Tuesday tech to come out, must tell boss my tv is more important than the job. If he had his priorities straight he would understand.
defined in easy way thanks
Is there an updated version that one can use for php 7, the syntax mysql_fetch_array was removed in php 7 , tried just changing it to mysqli_fetch_array but it didn't work. Please help ASAP.
error: Parse error: syntax error, unexpected '$row' (T_VARIABLE) in C:\xampp\htdocs\login\process.php on line 19