Simple and short... just what I was searching for... if I had found this video before I could have saved hours 😭 but atleast I found a video like this and was successful on following it as well. Truly excellent
OMG i cant express my feelings in words thankyou very much boss u just saved my project after one month of trying to connect to my DB and watching morethan a fucking 50 youtube videos finally i can see the registered user in my Dabatase i swear to God am in tears right now u know the struggle of coding when u on like 18 fucking hours eachday and a same problem "FatalError about Connection" thank you again and again and million times Sir all my prayers and love towards you
@@luckyygaba it means that your website hasn't been accessed via the link, its being access through your computer. make sure you're using WAMP to broadcast your website so you can access it from localhost instead of opening the html file.
@@anmolmittal4763 hi.. i already run xampp and connected to localhost, but still not worked after i click the submit button.. please advice... thank you
The video was informative, I am making a html js quiz in which you can score points and you can keep your personal best in a high score tab. I want to show the scores of each and every people who took my quiz in that tab. Pls help if possible.
Hello sir I have some problems when I submitted my browser write me. Parse error: syntax error, unexpected '$conn' (T_VARIABLE) in insert.php on line 16.
Hey bro im finished and put all script on site and im register on site and get error -> Connect Error(1045)Access denied for user 'root'@'localhost' (using password: NO) Please bro Help me :)
OMG! Honestly, there are a bunch of videos out there that teach the same. The major advantage you have is that your video is perfectly short! Just above 6 mins and forwarding most of it I watched it in just 2. Love the that you have given the source code as well. Check I'll definitely like, share and subscribe!
I needed a review of PHP's syntax. Thank you. The only thing I'd mention is around 4:03. Your verification logic isn't quite right. You'd want to make sure that "username" AND "password" AND gender, etc... are all entered. Your logic allows for only one of those things to be entered; you have a bunch of OR checks. Like "their username OR their password should be entered". Basically, in logical terms, you have a bunch of disjunction checks where there should be conjunction checks.
I don't know how to thank you 💓. I was struggling for this for 3 weeks and by god's grace, I found this wonderful video tutorial. Thank you so much, bro.
Greetings! I have done all the required thing, when i enter information on my localhost page and click submit, i don't see the successful or error information, the information just disappear and when i checked it on mysql in xampp, I don't see the information I entered, please, what might have been the issue
Fatal error: Uncaught Error: Call to a member function bind_param() on bool in i cant get rid of this error please help please help please help please help
sir i am have this error Fatal error: Uncaught Error: Call to a member function bind_param() on bool in E:\xampp\htdocs\test\insert.php:22 Stack trace: #0 {main} thrown in E:\xampp\htdocs\test\insert.php on line 22 plz help me
Showing this error👇 Fatal error: Uncaught Error: Call to a member function bind_param() on bool in /storage/emulated/0/htdocs/register/insert.php:29 Stack trace: #0 {main} thrown in /storage/emulated/0/htdocs/register/insert.php on line 29
thank you very much ...... with the help of videos like this .....i am much more confident to face my teacher now who always think students are wrong and dont know shit.
@Code And Coins THANKS............ AND HAVE YOU MADE A VIDEO TO HOW TO PUBLISH A WEBSITE ON GOOGLE IN WHICH ANYONE CAN WATCH OUR WEBSITE? ACTUALLY I AM IN CLASS 8....AND ARE YOU INDIAN?
I am from Nepal, to publish your website on the internet you need domain name and hosting. Here is my video th-cam.com/video/5a0Aa6BCc_E/w-d-xo.html. You can also create your first website using Blogger for free.
Thanks for your teachings, below is the error i keep getting after i used your codes, i even copied the source codes but when i feel the form, this is error keeps coming...please help Fatal error: Uncaught Error: Call to a member function bind_param() on bool in C:\xampp\htdocs\test\test.php:22 Stack trace: #0 {main} thrown in C:\xampp\htdocs\test\test.php on line 22
i got the same problem, i fixed it by changing the name of the table of the data base, in the video he used "register" you should change it to the name of the table in your database, change "register" in these commands : $SELECT = "SELECT email From register Where email = ? Limit 1"; $INSERT = "INSERT Into register (username, password, gender, email, phoneCode, phone) values(?, ?, ?, ?, ?, ?)";
what to do if there is a problem when I click submit form it asks me to open php file why?? and there is no record saved on database...………. how can I correct my mistakes......
I only have $fullName and $email: ---> $stmt->bind_param("s,i", $fullName, $email); Fatal error: Uncaught Error: Call to a member function bind_param() on boolean in /Applications/XAMPP/xamppfiles/htdocs/Freelance-landingPage/forms.php:12 Stack trace: #0 {main} thrown in /Applications/XAMPP/xamppfiles/htdocs/Freelance-landingPage/forms.php on line 12. what shall I do?
its been a month and you probably got through with this.. But if not and for anyone else who has that problem the solution is: $stmt->bind_param("ss", $fullName, $email); There are no commas between the "ss".. also i assume your $fullName and $email are both strings.
It says New records entered successfully every time I do it no matter what, I've tried solving it for hours but I don't know where it's going wrong. Please help
You get this error is due to your table in phpMyAdmin doesn't connect to your coding. Here is my solution: I) Change your web server. ii) Try this →line 17: $conn = new MySQLI($host,$dbUsername,$dbPassword,$dbname);
Been looking for a tutorial on this all over TH-cam and yours was the only one that answered my question directly. You did a very thorough job good work!
@@usamanadeem2258 Please help me I have to submit my project on time please help🙏 . I am getting php code after clicking on submit button instead of echo 🤯🥴
Yasemin Yıldız our Dr first time teach us this course I don’t have idea. I used this one it worked for me codewithawa.com/posts/complete-user-registration-system-using-php-and-mysql-database But u need to create database in php my admin to work. there was a problem with these code it didn’t submit so the instructor fix it and it work to me
@@jahnavirainlover I have tried in three different codes. I have also tried the code in this video purely copied code but same result inspite of showing registration successfully it is showing me the php code. I think the problem is not there in the code the problem is in connecting localhost server it's not connecting I don't know why
thanks for the tut, the trouble I'm having is that when i run the webpage the click on the submit button it opens the php file as a text file within the browser.
Hi! I am using Postgress instead of MySQL. By chance, do you know the function to create connection from the code to Postgress? Like instead of mysql(..., ...) or mysqli_connect_error. Also, I need to insert what the user gives to a specific table in the database. How could I do that? Thank you
THANK YOU ! IT WORKING , if someone have error: "Errors There were errors while saving the data." "prepare($SELECT); $stmt->bind_param("s", $email); ...." - you must check your xampp working - files must be in htdocs
Cannot POST /insert.php Please help me. I have been sitting here for so long trying to figure out this problem. I tried your source code, and it stills says that. Got any idea?
Thanku very much, You saved my day, I was struggling alot, gone through many long long video's nothing worked, but this video worked short n sweet. May Allah bless you with healthy and happy life 🥰
Thank you for your explanation. I have done it). This is my first site. But I don't understand why is registered user doesn't stay on my site. How can he sign in? What should I create? It works. But when a user tries to sign in with his login one more time it isn't possible.
i have copied the exact code for both html and PHP files created the same database with same fields and same table name but after clicking submitting button it is showing me php code so what can be the solution for this sir?
Simple and short... just what I was searching for... if I had found this video before I could have saved hours 😭 but atleast I found a video like this and was successful on following it as well. Truly excellent
You're welcome!
@@mnbvcxx same problem for me also how can I overcome this problem bro
Thanks a lot, i was seraching for the same for very long time, to clarify my doubts. .
This guy gave me all I needed!!
Thanks man I understood now how php and sql works linked with html form.
thanks a lot. your video helped me a lot and finally i understood it after months of hardwork
kya baat hai aapne ek hi bar me btadiya thx brother
OMG i cant express my feelings in words thankyou very much boss u just saved my project after one month of trying to connect to my DB and watching morethan a fucking 50 youtube videos finally i can see the registered user in my Dabatase i swear to God am in tears right now u know the struggle of coding when u on like 18 fucking hours eachday and a same problem "FatalError about Connection" thank you again and again and million times Sir all my prayers and love towards you
thank you, wonderful tutorial.
Thank you very much, you are the best.😍😍😍
Thanks for the tutorial but when I click Submit it shows all of my PHP code in a page and nothing happens... HELP, please!
Damn. Same :(
@@luckyygaba it means that your website hasn't been accessed via the link, its being access through your computer. make sure you're using WAMP to broadcast your website so you can access it from localhost instead of opening the html file.
it means you are not using any server for running your code, you can use xampp for the same.
@@anmolmittal4763 hi.. i already run xampp and connected to localhost, but still not worked after i click the submit button.. please advice... thank you
@@murniyatiho6320 you have to put your file in xampp folder in order to run the code on the local server.
it has worked man. Thanks a ton !
You're welcome!
You made a very good, simple and easy to understand video. Thank you
The video was informative, I am making a html js quiz in which you can score points and you can keep your personal best in a high score tab. I want to show the scores of each and every people who took my quiz in that tab. Pls help if possible.
you're the coolest!
you make programming look like a walk in the park brother.
Thank you Mohsen
Thanks a lot for sharing this knowledge and source code.😊😊 I will definitely donate when I completely learn this course..
Thanks once again..😊😊
So nice of you
thank you sir ,it is really helpful❤❤❤❤❤❤❤❤
Thanks for this - going to look at your vids now!
Hope you enjoy!
It worked for me, thank you a lot!
sorry you have added your database it was iterrupting me thanks. it works
Thanks pls continue....
thank you very much, this really helpful to me. but if you can show your File Explorer that is better, because it take me some time to set my file
Best video ever. Straight to the point! Thanks!
Very accurate source code
It helped me to understand
Really Very Helpful Tutorial
Keep it up bro 👍👍
Thanks very much
Oh its very helpful video
Glad to hear that
why it didnt work for me?
when i click submit button, insert.php source code appear.
btw im using wamp server.
same error
Wow wow wow. Thanks man
Question: what if we want to show the user the data saved
Excellent video
thanks very much bro and can you please show how to connect or perform login operations for website
Thank You Code and Coins
you welcome
OMG it actually worked!!! THANK YOU!
You are most welcome
how many software needed to connect html form to mysql database with php?
Hello sir I have some problems when I submitted my browser write me.
Parse error: syntax error, unexpected '$conn' (T_VARIABLE) in insert.php on line 16.
Sir my data is not getting in the SQL table and after executing your pho code it's showing "all fields required"
Nice 👍🏻
Hey bro im finished and put all script on site and im register on site and get error -> Connect Error(1045)Access denied for user 'root'@'localhost' (using password: NO) Please bro Help me :)
OMG! Honestly, there are a bunch of videos out there that teach the same. The major advantage you have is that your video is perfectly short! Just above 6 mins and forwarding most of it I watched it in just 2. Love the that you have given the source code as well. Check I'll definitely like, share and subscribe!
Doesnt your program takes to u to php code and if your this code work help me
I needed a review of PHP's syntax. Thank you.
The only thing I'd mention is around 4:03.
Your verification logic isn't quite right.
You'd want to make sure that "username" AND "password" AND gender, etc... are all entered. Your logic allows for only one of those things to be entered; you have a bunch of OR checks.
Like "their username OR their password should be entered". Basically, in logical terms, you have a bunch of disjunction checks where there should be conjunction checks.
Very good observation 🙂
didn't even know pipeline can be used as OR thanks for pointing out
@@hershey6171 pipelines as or is actually a common in languages like cpp js etc… mist of those languages that uses curly bracets and semicolon
I don't know how to thank you 💓. I was struggling for this for 3 weeks and by god's grace, I found this wonderful video tutorial. Thank you so much, bro.
You are Welcome
th-cam.com/video/9DnCCkosNcc/w-d-xo.html
Greetings! I have done all the required thing, when i enter information on my localhost page and click submit, i don't see the successful or error information, the information just disappear and when i checked it on mysql in xampp, I don't see the information I entered, please, what might have been the issue
The only tutorial that actually worked for me after spending hours on TH-cam. Excellent explanation and very useful video, thank you!
Great to hear!
Same here after long suffering googlering everythi watch many video now i can go to sleep
😅
String ="s"
Int="i"
Date=? Please guide
String
euta Nepali le arko Nepali lai voice le chinxa haha!
keep up the hard work dai
thank you
I need help.
Fatal error: Uncaught Error: Call to a member function bind_param() on bool
I checked multiple times but nothing worked.
same
Fatal error: Uncaught Error: Call to a member function bind_param() on bool in
i cant get rid of this error
please help
please help
please help
please help
I too got the same error bro.
I tried some solutions available on Stack Overflow and TH-cam, still can't get rid of it.
Same
th-cam.com/video/2HVKizgcfjo/w-d-xo.html
sir i am have this error
Fatal error: Uncaught Error: Call to a member function bind_param() on bool in E:\xampp\htdocs\test\insert.php:22 Stack trace: #0 {main} thrown in E:\xampp\htdocs\test\insert.php on line 22
plz help me
same problem with me
have you find any solution Rehab Ramzan
Showing this error👇
Fatal error: Uncaught Error: Call to a member function bind_param() on bool in /storage/emulated/0/htdocs/register/insert.php:29 Stack trace: #0 {main} thrown in /storage/emulated/0/htdocs/register/insert.php on line 29
thank you very much ...... with the help of videos like this .....i am much more confident to face my teacher now who always think students are wrong and dont know shit.
I followed it correctly, but it shows HTTP error 405, why?
After getting "new record successfully” how can we direct to next page or next slide
header('location: index.html');
can u please tell ,me why i m getting php code after pressing submit button
th-cam.com/video/xHRlr8XccUc/w-d-xo.html
This guy has better english than half the comment section.
@Code And Coins THANKS............ AND HAVE YOU MADE A VIDEO TO HOW TO PUBLISH A WEBSITE ON GOOGLE IN WHICH ANYONE CAN WATCH OUR WEBSITE? ACTUALLY I AM IN CLASS 8....AND ARE YOU INDIAN?
I am from Nepal, to publish your website on the internet you need domain name and hosting. Here is my video th-cam.com/video/5a0Aa6BCc_E/w-d-xo.html. You can also create your first website using Blogger for free.
@@CodeAndCourse thanks
Damn you can make a great tutorial you should really be bigger
thank you
I m getting the whole php code on submitting the form
Please help...
Thanks for your teachings, below is the error i keep getting after i used your codes, i even copied the source codes but when i feel the form, this is error keeps coming...please help
Fatal error: Uncaught Error: Call to a member function bind_param() on bool in C:\xampp\htdocs\test\test.php:22 Stack trace: #0 {main} thrown in C:\xampp\htdocs\test\test.php on line 22
i am getting the same error
i got the same problem, i fixed it by changing the name of the table of the data base, in the video he used "register" you should change it to the name of the table in your database, change "register" in these commands :
$SELECT = "SELECT email From register Where email = ? Limit 1";
$INSERT = "INSERT Into register (username, password, gender, email, phoneCode, phone) values(?, ?, ?, ?, ?, ?)";
@@fernandodharmaraja6465 even if i change the table name it's showing the same error.🤷
Tutorial is gud but please use better mic and don't hurry tutorial.Tq
thank you for your suggestion
I'm really thankful to u I'm been search for so long
what to do if there is a problem when I click submit form it asks me to open php file why??
and there is no record saved on database...……….
how can I correct my mistakes......
Can you show me your code.
And here I make another video, which may be helpfull for you. th-cam.com/video/we5IDfvjtVs/w-d-xo.html
@@CodeAndCourse help! mine also does the same thing
did you turn on the xampp apache & mysql ?
same problem
plz reply
@@matthewtang5638 yes i have, but it not reflecting on my db
Thanks a lot...will be implementing it in the project tomorrow.
succeed!
Please help me I have to submit my project on time please help🙏 .
I am getting php code after clicking on submit button instead of echo 🤯🥴
@@virenderkumar9002 yup me too need help
@@virenderkumar9002bro I am also getting like that. What you done after that
Thank you for this wonderful content! We can pass the defense because of this!
I only have $fullName and $email: ---> $stmt->bind_param("s,i", $fullName, $email);
Fatal error: Uncaught Error: Call to a member function bind_param() on boolean in /Applications/XAMPP/xamppfiles/htdocs/Freelance-landingPage/forms.php:12 Stack trace: #0 {main} thrown in /Applications/XAMPP/xamppfiles/htdocs/Freelance-landingPage/forms.php on line 12.
what shall I do?
its been a month and you probably got through with this.. But if not and for anyone else who has that problem the solution is:
$stmt->bind_param("ss", $fullName, $email);
There are no commas between the "ss".. also i assume your $fullName and $email are both strings.
It says New records entered successfully every time I do it no matter what, I've tried solving it for hours but I don't know where it's going wrong. Please help
same error
Same error
same problem any one know about this problem
plz reply
Same here
Same here bro
Fatal. Errors: call to a member function bind_param() on bool please help me to solve this problem??
Here is a solution forum.codeandcourse.com/viewtopic.php?f=4&t=4
you can try this if it works
$stmt->bind_param("s", $email);
You get this error is due to your table in phpMyAdmin doesn't connect to your coding.
Here is my solution:
I) Change your web server.
ii) Try this →line 17: $conn = new MySQLI($host,$dbUsername,$dbPassword,$dbname);
@@CodeAndCourse where we have to save these files pls help me in xampp or wamp and how to execute
@@acltearjerker you use which web server?? For mine is Xampp (recommended)
I have error that when I click submit (showing the code in insert.php file 😔)
Please help reply me please ....
If you've solved that step, see this for an example custom form development:
th-cam.com/video/bNvAO2-_hi8/w-d-xo.html
Been looking for a tutorial on this all over TH-cam and yours was the only one that answered my question directly. You did a very thorough job good work!
Glad I could help!
@@CodeAndCourse i click on insert button then show php file file why????
@@usamanadeem2258 Please help me I have to submit my project on time please help🙏 .
I am getting php code after clicking on submit button instead of echo 🤯🥴
Please help me I have to submit my project on time please help🙏 .
I am getting php code after clicking on submit button instead of echo 🤯🥴
could you give us another link for the source code please, it doesn't seem to be working for me
Same
This tutorial waste my time after an hour of typing it shows error at least share all the code
Yasemin Yıldız thanks I submitted my project before a week but thanks for sharing it will help someone else :)
You're welcome. mine also did not work. I click submit button, it shows the .php file codes. Any idea why?
Yasemin Yıldız our Dr first time teach us this course I don’t have idea. I used this one it worked for me codewithawa.com/posts/complete-user-registration-system-using-php-and-mysql-database
But u need to create database in php my admin to work. there was a problem with these code it didn’t submit so the instructor fix it and it work to me
Yasemin Yıldız my project: drive.google.com/file/d/1rC1BkY42wzmm1HHnlOTCvcdraJ3WZMJp/view?usp=drivesdk
Thank you so much! This helped me give a good start to my project! I was so clueless before.
Glad I could help!
Please help me I have to submit my project on time please help🙏 .
I am getting php code after clicking on submit button instead of echo 🤯🥴
@@virenderkumar9002 What's your code?
@@jahnavirainlover I have tried in three different codes. I have also tried the code in this video purely copied code but same result inspite of showing registration successfully it is showing me the php code. I think the problem is not there in the code the problem is in connecting localhost server it's not connecting I don't know why
If u know something about connecting server then please tell me
It is not work at wapm server why??
When i click submit.. it shows me my php code.. what thehell
same i don't know what to do
Yes.. same
Do you have php installed and configured?
Open your code using localhost
Save both pageb. Php and put in localhost
I tried it and it was successful
I also made my another form and was also successful
thankyouu!
Thanks Bro your tutorial helped me a lot
its showing this page isnt working right now
Can i select the data type of Gender = Boolean? Because its just two things M or F. Please correct me if I am wrong
Yes, you can
Simply great job. Thanks so much.
thanks mehn this really helped me out
That's awesome,
I just learned to store data from HTML from my database
Thank you so much.
very helpful. i already try it, but there's only 1 data can be inputted.. is there any way to submit more than 1 data? thanks
Explain more, how do you want to enter multiple data
100% successfully working thanks bro!
Please help me I have to submit my project on time please help🙏 .
I am getting php code after clicking on submit button instead of echo 🤯🥴
i did make the textbox but it didn't save and said that contact the owner not found
Muito obrigada, funcionou perfeitamente ❤️🙌
Welcome
thanks for the tut, the trouble I'm having is that when i run the webpage the click on the submit button it opens the php file as a text file within the browser.
it looks like first you need to know how to run php code
@@CodeAndCourse instead you could have just told us how to fix it.. hours of copying your code but it doesnt run just opens the ext file of php code
th-cam.com/video/soJOBrePwzQ/w-d-xo.html you are welcome
th-cam.com/video/YsmMVwz1rlo/w-d-xo.html im xampp
What is the data type of datetime like for username it is s than for datetime what will be given plzz reply
You did just excellent work bro..
thank You so much ❤️❤️❤️❤️❤️❤️❤️❤️
Coudn't understand a word but hey the math checks out, thank you
please stop lying in the title
Hi! I am using Postgress instead of MySQL. By chance, do you know the function to create connection from the code to Postgress? Like instead of mysql(..., ...) or mysqli_connect_error. Also, I need to insert what the user gives to a specific table in the database. How could I do that? Thank you
THANK YOU ! IT WORKING ,
if someone have error:
"Errors There were errors while saving the data."
"prepare($SELECT); $stmt->bind_param("s", $email); ...."
- you must check your xampp working - files must be in htdocs
Cannot POST /insert.php
Please help me. I have been sitting here for so long trying to figure out this problem. I tried your source code, and it stills says that. Got any idea?
I'm not getting any error but not find any data in database it also shows new record insert successfully
But not getting any entry in database
Please check out the source code link which is in the description
hi
i am not able to insert it.
instead of showing "new record successfully created" its showing my entire php code.
what should i do?
You may find your solution on forum.codeandcourse.com
sir how I can do the same in shared host I try but when I fill the form it said Could not connect to the database.
Thanku very much,
You saved my day, I was struggling alot, gone through many long long video's nothing worked, but this video worked short n sweet.
May Allah bless you with healthy and happy life 🥰
Glad to hear that 😀
Super bro I watched many they won't work but it was worked.. Thanks a lotttt🤩😊😇
Welcome 👍
Thank you for your explanation. I have done it). This is my first site. But I don't understand why is registered user doesn't stay on my site. How can he sign in? What should I create? It works. But when a user tries to sign in with his login one more time it isn't possible.
i have copied the exact code for both html and PHP files created the same database with same fields and same table name but after clicking submitting button it is showing me php code so what can be the solution for this sir?
did you know how to solve it?
@@sam-fe7wi not yet
when i submit the uotput put is all field are required?