9:30, is getting the data from the form to the database (sign up), 17:48, is log user in and redirect them to the home page with their content and things
Out of all the tutorial video that I watch, your video is a much more helpful it's informative and easy to follow. I really learned a lot and continue what you are doing, God bless you :) Thank you!!
Thank you so much for this video, it is a lifesaver. I have created the registration form but for my website I have added a drop-down list which allows users to select their diet and from this when the user logs in after verification it shows them the corresponding meal plan page for the diet they clicked (if that makes any sense) but I am unsure how to do so. Can you please help.
I've downloaded the source code, but the problem is it just registers one user i.e., the next registration is not updated in the database, therefore the 2nd user cannot log in.
At 23:05 you are adding a hyperlink so that the user gets redirected to the login page after the session gets destroyed/ends which I understand, but I don't think I understand why you add "?logout='1'" to the hyperlink string. Does it mean: "if user clicks hyper link, the if statement gets triggered (in server.php) and thus the session gets destroyed/unset"? And the 'logout=1' means that logout is true so the if statement (in server.php) gets triggered and session gets destroyed? Because if I make it false ('logout=0') everything still works. Thank you for the great tutorial! Your coding style is very nice!
great video everything works fine except that i cannot make the .content class look like form in the css file. no matter what i write a changes won't affect the content class in index.php. can someone help me? Update: nevermind its just Firefox Developer edition being trash..works fine in Microsoft Edge
it would be good if you could also put your code in the description so we didn't have to type it along with you while having to pause the video to do so.
I have a question. On the registering then redirecting to index part, after registering I don't have the "Welcome 'username" and "Logout" button, only the header. I'm sure I've followed your code to the tee, of course editing some so it's not completely plagiarized. I checked and retyped the code multiple times, but they're still missing. There are no errors, the homepage is just missing the welcome and logout. Any insights? Thank you for this video, by-the-way, it's really helping me.
@Awa Melvine i have this problem idk why i ve been writing exact same code but when i click on register button its like this Fatal error: Uncaught ArgumentCountError: mysqli_real_escape_string() expects exactly 2 arguments, 1 given in C:\xampp\htdocs egistration\server.php:12 Stack trace: #0 C:\xampp\htdocs egistration\server.php(12): mysqli_real_escape_string('') #1 C:\xampp\htdocs egistration egister.php(1): include('C:\\xampp\\htdocs...') #2 {main} thrown in C:\xampp\htdocs egistration\server.php on line 12
Bro, please help me with this: I want to login with matching username and password from database table and display only selected data from the other tables using PHP. If you have enough time to. Thank you in anticipation.
hey hi, I followed your video and I have this problem, when I put the data to register them in the database the page disappears and in the database it saves the data in a strange way, I don't see username and email but only the password encrypted in md5, I did everything like in the video I can't understand what the problem is.
Good day sir, how can I fix this "Uncaught Error: Call to undefined function mysql_real_escape_string()"? thank you sir! This video was amazing hope to see your other tutorials.
Bro seriously ? No background music . Can you add the background music or your own voice in next videos. but Excellent Tutorials . Thank you! It's very helpful. @ awamelvine
Hey; I was stacking with this error several days without finding; Here is a guy which explained the same concept and it's working ua-cam.com/video/WYufSGgaCZ8/v-deo.html
How can you set it so that the user cannot register with an account where there is already a record in the database with that existing email? There is no filtering system in this video and duplicate registrations can be inserted into users database, correct?
Does not send email to user upon registration to confirm. How do you know that the email entered belongs to the user i.e. that the user isn't registering with a fake or someone else's email?
i have tried all these. it worked but the data is still returning zero rows in the sql database table. the table is still empty. what do i do to solve that please?
Dude I have İncluded the code error in login but It doesn't work, giving no errors when I press the login button without entered anything on password section. do you have a guess why ?
awsm video bt my prmb is what exact reason behind after login not show successful msg...bt after add account data will successful as well as saved in phpmyadmin....
when typing the syntax in errors.php an error like this occurs? Parse error: syntax error, unexpected token "endforeach", expecting "elseif" or "else" or "endif" on line 5
Are you sure it is right? Use "echo" to check the data that is in your $username and $password and make sure it matches what's in the db. (For password, check after the $password = md5($password) part.) Also check to make sure your "if" statements are nested correctly.
Great video, I only get 1 fatal error which I can't solve by myself. Error on my website: *Fatal error: Uncaught Error: Call to undefined function mysql_real_escape_string()* Error on PHPStorm: *Referenced entity is deprecated. This usually means that you are advised to remove the usage or replace it with other construct.* I don't know what to do, some help please??
@@Sinister_General you need to add $db, infront of the $_post like this $username = mysqli_real_escape_string($db,$_POST['username']); i had the same issue took me like 20mins to figure it out hope this helps
Parse error: syntax error, unexpected 'endforeach' (T_ENDFOREACH), expecting end of file in C:\xampp\htdocs\fonshop\errors.php on line 6 idk what should i do with this, i have the same code as you
Please stop telling people to use real_escape_string. Prepared statements are the only proper way of doing things. You're using mysqli (for the connect) with a mysql feature (for the real escape string). And the mysql extension has disppeared in 7.0.
Not Found The requested URL was not found on this server. Apache/2.4.52 (Win64) OpenSSL/1.1.1m PHP/8.1.2 Server at localhost Port 80 can anyone help pleasee?
code doesnt work. i get a ton of errors where u get 0 at 15:45 I get errors about the variable errors being undefined my server.php is filled with errors HELP
@@AwaMelvine Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in C:\xampp\htdocs\VSC egistration\server.php on line 33 HELP ME PLEASE
I love this tutorial. I got it first from your website. It easy to understand, but I tried to replicate it on my own work but it's not working. When I click on the register button it does not respond. Can you help please
Please help!!! Getting error::::::::: Undefined variable: errors in C:\xampp\htdocs egister\errors.php on line 1 & count(): Parameter must be an array around 15:29
People may find it trouble that you don't talk, but good programming talks for itself, such as this video. Thanks for the video! :)
Prolly visited 100s of channels before I found you. You're the best tutor of all. Thanks man!!!
Get yourself a microphone my friend so you can explain more, but nonetheless this is very good work you did here 👏🏾👏🏾👏🏾..
9:30, is getting the data from the form to the database (sign up), 17:48, is log user in and redirect them to the home page with their content and things
how will I have a code to complete my foam registeration
Out of all the tutorial video that I watch, your video is a much more helpful it's informative and easy to follow. I really learned a lot and continue what you are doing, God bless you :) Thank you!!
would u mind emailing me all of your worked file of this vid? thanks in advance
Thank you for your explanation sir! You inspire me to learn PHP & MySQL.
How to tackle undefined index of the email, password_1, password_2? I cannot log in once registered. It keeps on appearing the required message.
Thank you so much for this video, it is a lifesaver.
I have created the registration form but for my website I have added a drop-down list which allows users to select their diet and from this when the user logs in after verification it shows them the corresponding meal plan page for the diet they clicked (if that makes any sense) but I am unsure how to do so. Can you please help.
Can you please provide me with the source code? My index.php is not working no matter how many times i have cross checked.
I've downloaded the source code, but the problem is it just registers one user i.e., the next registration is not updated in the database, therefore the 2nd user cannot log in.
who is the sorcecode
YOU ARE A GODDDDD. This video was immensely helpful, can't thank you enough.
Hi aditi, your code is working
At 23:05 you are adding a hyperlink so that the user gets redirected to the login page after the session gets destroyed/ends which I understand, but I don't think I understand why you add "?logout='1'" to the hyperlink string. Does it mean: "if user clicks hyper link, the if statement gets triggered (in server.php) and thus the session gets destroyed/unset"?
And the 'logout=1' means that logout is true so the if statement (in server.php) gets triggered and session gets destroyed? Because if I make it false ('logout=0') everything still works.
Thank you for the great tutorial! Your coding style is very nice!
The world needs more programmers like you. This saved me alot of stress, thankyou!
would you mind emailing me all of your worked file from this vid? thanks in advance.
Bon bagay neg pa mesi
i did it and its work as well thank you very much.
thank you, audio was never needed with your clean code.
I have given some information about backend.Thank you!!!
why do we set the length/values property of the primary key to 11? Thanks :)
great video everything works fine except that i cannot make the .content class look like form in the css file. no matter what i write a changes won't affect the content class in index.php.
can someone help me?
Update: nevermind its just Firefox Developer edition being trash..works fine in Microsoft Edge
om gosh u haven't activated windows yet, i can gift u one, cause u help me a lot
it would be good if you could also put your code in the description so we didn't have to type it along with you while having to pause the video to do so.
rigth
I have a question. On the registering then redirecting to index part, after registering I don't have the "Welcome 'username" and "Logout" button, only the header. I'm sure I've followed your code to the tee, of course editing some so it's not completely plagiarized. I checked and retyped the code multiple times, but they're still missing. There are no errors, the homepage is just missing the welcome and logout. Any insights? Thank you for this video, by-the-way, it's really helping me.
when i came here i was searchin for the previous tuto but with audio, and what i found is just another 32 minutes of silence, wtf
very well understandig than other vids
Correct me if I'm wrong but you did not include codes to verify whether or not such user exists in the database upon registration.
Gosh! The font Times Roman is killing me inside !
ikr😅
Change it bro!
Thank you Awa for this video, you are my sensei.
Thanks, Neat and clean Coding in simple way.
@Awa Melvine i have this problem idk why i ve been writing exact same code but when i click on register button its like this
Fatal error: Uncaught ArgumentCountError: mysqli_real_escape_string() expects exactly 2 arguments, 1 given in C:\xampp\htdocs
egistration\server.php:12 Stack trace: #0 C:\xampp\htdocs
egistration\server.php(12): mysqli_real_escape_string('') #1 C:\xampp\htdocs
egistration
egister.php(1): include('C:\\xampp\\htdocs...') #2 {main} thrown in C:\xampp\htdocs
egistration\server.php on line 12
Same issue
I have tried like ten times but it is still not working
Bro, please help me with this: I want to login with matching username and password from database table and display only selected data from the other tables using PHP. If you have enough time to. Thank you in anticipation.
Hi, did you get any solution for this? I'd appreciate it if you could share the same. Thank you
i love this video,this is very helpful for my project- .........Dipen Rabha...
can you make a tutorial : after login the the form in the url can we retrive the user id or a username
hey hi, I followed your video and I have this problem, when I put the data to register them in the database the page disappears and in the database it saves the data in a strange way, I don't see username and email but only the password encrypted in md5, I did everything like in the video I can't understand what the problem is.
excellent tutorial very punctual and precise ideal for those who learn congratulations !!
Hi, I do not know why the home page content not showing, but I follow the video step by step, and codes are all the same
I have a problem...My data doesn't fill in my MySQL database I check my code ,and check...and check..., but cant see were is my fault.Hellp please?
Good day sir, how can I fix this "Uncaught Error: Call to undefined function mysql_real_escape_string()"? thank you sir! This video was amazing hope to see your other tutorials.
make it: mysqli_real_escape_string()
You'll also need two parameters inside the parenthesis.
Just use addslashes() .
@@nicks1171 What are the two parameters to put inside? I can't figure it out
@@lamborghinicentenario2497 Which page and specific line number are you referring to?
Thank you, it is very useful. Thank you so much. Much appreciated. May God bless you always.
Bro seriously ?
No background music .
Can you add the background music or your own voice in next videos.
but Excellent Tutorials .
Thank you! It's very helpful.
@
awamelvine
Hi there have a Fatal error: uncaught error: call to undefined function mysql_real_escape_string(), when I click the register button, do you know why?
Hey; I was stacking with this error several days without finding;
Here is a guy which explained the same concept and it's working ua-cam.com/video/WYufSGgaCZ8/v-deo.html
How can you set it so that the user cannot register with an account where there is already a record in the database with that existing email? There is no filtering system in this video and duplicate registrations can be inserted into users database, correct?
Thank you Awa, you're a lifesaver bro
Thanks man this was a life saver best php registration video i could find i owe you one!
thank you for the tutorial but how can I get the source codes only for learning puropse.
you talk and you share more and we can learn more
Does not send email to user upon registration to confirm. How do you know that the email entered belongs to the user i.e. that the user isn't registering with a fake or someone else's email?
i have tried all these. it worked but the data is still returning zero rows in the sql database table. the table is still empty. what do i do to solve that please?
Hi Awa, In step 29 in style.css How are you generating CSS code?
Hey Sandeep. I wrote it behind the scenes and pasted it to save time. It wasn't generated 😁
is there any solution login system without session? or there is any login system using token with php mysql native?
can anyone tell me why the mysql real escape string is counted as error unlike the one on the video especially: 11:50
Hello, please upload a video, after login user update, delete, change their profile in welcome page...
hi did u get it
27:38 I have the error there Fatal error: Uncaught Error: Call to undefined function mysqli_ram_rows(). Can somebody help me pls?
it is mysqli_num_rows() instead of mysqli_ram_rows()
could you teach us how to make a profile after logged in
Dude I have İncluded the code error in login but It doesn't work, giving no errors when I press the login button without entered anything on password section. do you have a guess why ?
Why mine can't function in mysql_real_escape_string?
at 15:42, I'm not getting those popups that say "Username is required". I have the exact same code as you. Please help
Nvm, I just found out that in "register.php", i didn't have the
awsm video bt my prmb is what exact reason behind after login not show successful msg...bt after add account data will successful as well as saved in phpmyadmin....
when typing the syntax in errors.php an error like this occurs?
Parse error: syntax error, unexpected token "endforeach", expecting "elseif" or "else" or "endif"
on line 5
Hello sir! have a question, how is it available to us $errors = array(); in the file errors.php when we didn't include it in that file?
Is the answer because we included 2 files in the file register.php, namely server.php and errors.php, and in this way those 2 files are connected?
Hi, my validation rules are not working, I have followed your video but cant see why its not working, is there some way I can send you my files?
the " if (empty($_SESSION['username'])) {
header('location: login.php');
}" somehow not working
*I got you bro. **ua-cam.com/users/rhymbil*
Thank you
Can't login, it always says wrong username/password even though it is right. Please help....
Are you sure it is right? Use "echo" to check the data that is in your $username and $password and make sure it matches what's in the db. (For password, check after the $password = md5($password) part.) Also check to make sure your "if" statements are nested correctly.
hi, sorry for my english, how can i get the result of an input type="radio" ? all the other inputs works but the radio input it tells me it's empty !!
u need to create a row in database with datatype of "enum" and give the abbreviation in the order of the HTML code and ur done.
Great video, I only get 1 fatal error which I can't solve by myself.
Error on my website:
*Fatal error: Uncaught Error: Call to undefined function mysql_real_escape_string()*
Error on PHPStorm:
*Referenced entity is deprecated. This usually means that you are advised to remove the usage or replace it with other construct.*
I don't know what to do, some help please??
Please use mysqli_real_escape_string() instead.
@@AwaMelvine I tried your code but it gives me another error:
*mysqli_real_escape_string() expects exactly 2 parameters, 1 given*
It also doesn't send the data to the database :(
@@Sinister_General you need to add $db, infront of the $_post like this
$username = mysqli_real_escape_string($db,$_POST['username']);
i had the same issue took me like 20mins to figure it out hope this helps
Thank you for your explanation sir! You save my life as a student T.T *Thumb up
Source code for every1 here: codewithawa.com/posts/complete-user-registration-system-using-php-and-mysql-database
Sir can you help me on this error it says Call to undefined function mysql_real_escape_string()
hii, May i know why i didn't receive the verification email, i double check my code, it is same with yours..., composer i have also downloaded already
sir guys, just asking if how can you instantly paste your css like he did on 4:30 ?
The logout won't appear even if I copied your code. Can you help me?
Hello, why do the login do not get my password? when i fill it, it still display the password required error? What is the problem?
most of the tutorial that ive seen uses procedural coding...why is that? why not use OOP? like mysqli
thank you so much brada...u help me solve my problem
Github?
how can u just paste and it will type the code? i didnt get it. Thanks!
The errors file gives syntax errors, how did you fix that?
PLEASE PROVIDE SOURCE CODE IN DESCRIPTION
Parse error: syntax error, unexpected 'endforeach' (T_ENDFOREACH), expecting end of file in C:\xampp\htdocs\fonshop\errors.php on line 6 idk what should i do with this, i have the same code as you
I have the same error
why does it got error i follow the code in 12:07 yet i got an error
Please stop telling people to use real_escape_string. Prepared statements are the only proper way of doing things. You're using mysqli (for the connect) with a mysql feature (for the real escape string). And the mysql extension has disppeared in 7.0.
He is also using MD5 for encrypting passwords
can i know what version of xampp you are using? :)
He's using v3.2.3.
anyone got? cause when i want to login, i got wrong username and password combination even it is a right password and username.
Same problem have you find the solution?
please can you tell me why the session_start(); is showing an error i can't understand why
Not Found
The requested URL was not found on this server.
Apache/2.4.52 (Win64) OpenSSL/1.1.1m PHP/8.1.2 Server at localhost Port 80
can anyone help pleasee?
Do the validations (at least for empty fields and email format) on client side.
This saved me! Thank you Awa!
Thank you so much Awa, the code was way clean and understanding one.
Help, when I register a user it does not show in my database
@@Adzy2k1 did you check the database name and table name to your code?
@@Adzy2k1 same
@@sudeepnellur i have the same error but i already checked my database
This code available yes or not..
How do you rename multiple words? for example at 3:30
how to change background color in this project ?
Teacher
this is ັno
ອາຈານ ໃສ່ໂຄດ ແລ້ວບໍ່ຖຶກແກ້ແນວໃດ.?
thankyou for your reply..
code doesnt work. i get a ton of errors where u get 0 at 15:45
I get errors about the variable errors being undefined
my server.php is filled with errors HELP
Same bro. Got the same problem. Could somebody please help us?
me too dude it always says that there is an error in server.php line 11
Fatal error: Uncaught Error: Call to undefined function mysql_real_escape_string() in C:\xampp
ewxampp\htdocs
egistration\server.php:11 Stack trace: #0 C:\xampp
ewxampp\htdocs
egistration
egister.php(1): include() #1 {main} thrown in C:\xampp
ewxampp\htdocs
egistration\server.php on line 11
sourse code?
codewithawa.com/posts/complete-user-registration-system-using-php-and-mysql-database
@@AwaMelvine Help, when I register a user it does not show in my database
@@Adzy2k1 me too
@@AwaMelvine Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in C:\xampp\htdocs\VSC
egistration\server.php on line 33
HELP ME PLEASE
Hi awa, I'm facing an error is
Mysql_query() expects parameter 1 to be string, resource given in c:\xampp\htdocs
egister\server.php on line 35
make sure you link your database correctly with the script
@@saulasamule5550 its correct, Saula. So if u don't mind can you help me via teamviewer or anydesk with remotel connect my laptop.
@@AvtarSingh-jw3xs I'm not the best. I'm also a starter.
I love this tutorial. I got it first from your website. It easy to understand, but I tried to replicate it on my own work but it's not working. When I click on the register button it does not respond. Can you help please
Please help!!! Getting error:::::::::
Undefined variable: errors in C:\xampp\htdocs
egister\errors.php on line 1 & count(): Parameter must be an array
around 15:29
Is this website responsive? Desktop, Ipad, Iphone,...
password is not encrypted using md5 before storing in database
it says url page not found when i press register how do i fix this??