Store HTML Form Data to MySQL Database

Подписаться 71 тыс.

Просмотров 1,8 млн

50% 1

If you don't know, How to store/save data from HTML Register Form to your MySQL Database using PHP then watch this 6 minutes video.
Requirement: You should know how to run PHP code. If you don't then learn from this playlist first:
PHP Tutorial for Beginner: • PHP Tutorial for Beginner
How to Create Registration Form in HTML= • From Zero to Hero: Bui...
How to connect HTML Form to MySQL Database with PHP= • Connect Your HTML Form...
Donate here: www.paypal.me/nawarajshah
Source Code Here= bit.ly/2Z2pCP9
Software used: xampp for server and database, Sublime Text 3 as a code editor.
Twitter: / codeandcoins
Facebook: / codeandcoins
Google+ : goo.gl/7vjhrp
Blog: CodeAndCoins.blogspot.com
Share this Video and Subscribe to my channel
#CodeAndCoins #HTMLForm

Опубликовано:

19 май 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 1,5 тыс.

@jaydonekal4171 3 года назад

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!

@mohammeddhinojwalal8579 2 года назад

Doesnt your program takes to u to php code and if your this code work help me

@bestfriendaarit4027 Год назад

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

@CodeAndCoins Год назад

You're welcome!

@sudeesh6112 Год назад

@@mnbvcxx same problem for me also how can I overcome this problem bro

@jacksonbodra6450 5 лет назад

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.

@rhitvi6002 Год назад

The only tutorial that actually worked for me after spending hours on RU-vid. Excellent explanation and very useful video, thank you!

@CodeAndCoins Год назад

Great to hear!

@donkanji6785 Год назад

Same here after long suffering googlering everythi watch many video now i can go to sleep

@mujeeburrahman7352 8 месяцев назад

😅

@malayanurvithahavya128 3 года назад

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.

@CodeAndCoins 3 года назад

You are Welcome

@worldofcarsCA 3 года назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-9DnCCkosNcc.html

@HIGHvoltage624 3 года назад

Been looking for a tutorial on this all over RU-vid and yours was the only one that answered my question directly. You did a very thorough job good work!

@CodeAndCoins 3 года назад

Glad I could help!

@usamanadeem2258 3 года назад

@@CodeAndCoins i click on insert button then show php file file why????

@virenderkumar9002 2 года назад

@@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 🤯🥴

@virenderkumar9002 2 года назад

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 🤯🥴

@bahmad6564 5 лет назад

thanks a lot. your video helped me a lot and finally i understood it after months of hardwork

@nisithchakrabarty4774 5 лет назад

Thanks a lot sir.I am trying this since some months,but finally this video helped me a lot.

@christianreibino901 3 года назад

Thank you for this wonderful content! We can pass the defense because of this!

@suyashpal5851 5 лет назад

Thanks Bro your tutorial helped me a lot

@shubhamkaudewar7297 5 лет назад

Thanks man I understood now how php and sql works linked with html form.

@davilavilolo 5 лет назад

Simply great job. Thanks so much.

@dr.sumankumarroy4344 2 года назад

This guy gave me all I needed!!

@vishalwankhade1733 2 года назад

Happiness is getting the exact thing you were looking for 😍🤩...thanks

@grzegorz5763 3 года назад

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

@muralireddy9787 5 лет назад

thank you, wonderful tutorial.

@likhithramesh9065 5 лет назад

Thanks a lot...will be implementing it in the project tomorrow.

@matthewtang5638 4 года назад

succeed!

@virenderkumar9002 2 года назад

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 🤯🥴

@rajivIX2001 2 года назад

@@virenderkumar9002 yup me too need help

@harshithrevuri581 10 месяцев назад

@@virenderkumar9002bro I am also getting like that. What you done after that

@raynewman7172 4 года назад

Thank s for this useful tutorial. It took me a little to deal with the code but it worked at last. Thumbs up

@Ayiamus7 3 года назад

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 🥰

@CodeAndCoins 3 года назад

Glad to hear that 😀

@eggcraft2673 6 лет назад

Men i love you so much, i want you to make me children, tomorrow i have an exam and i have to make a login system but few days ago my computer burnt so i had to find as fast as i can something to replace what i've done and you were there ! thanks bro love you

@ime2093 5 лет назад

WTF

@Q8Duelist 5 лет назад

Lol

@andrew1257 5 лет назад

"i want you to make me children" I had to reread that and I spat my drink out

@Q8Duelist 5 лет назад

@@andrew1257 LMAO

@santoshchappidi9109 4 года назад

😂

@loganadanr4137 3 года назад

I'm really thankful to u I'm been search for so long

@sherondesilva7270 Год назад

Thanks a lot man.... I went through multiple videos but nah couldn't any proper video. Thanks again man.

@CodeAndCoins Год назад

No problem 👍

@banishasiangshai347 4 года назад

Thank you so much sir my register form it work atleast i learn somthing from you sir...once again thank you so much sir... and now i know and understand how to connect database also.

@jahnavirainlover 3 года назад

Thank you so much! This helped me give a good start to my project! I was so clueless before.

@CodeAndCoins 3 года назад

Glad I could help!

@virenderkumar9002 2 года назад

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 🤯🥴

@jahnavirainlover 2 года назад

@@virenderkumar9002 What's your code?

@virenderkumar9002 2 года назад

@@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

@virenderkumar9002 2 года назад

If u know something about connecting server then please tell me

@Orincaby 4 года назад

This guy has better english than half the comment section.

@khalidabdi9537 5 лет назад

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

@jj5ben77 3 года назад

Bruh you save my life! THANK YOU!

@ZeinPlayy 3 года назад

You made a very good, simple and easy to understand video. Thank you

@mraziz3230 4 года назад

That's awesome, I just learned to store data from HTML from my database Thank you so much.

@natures_creativity09 5 лет назад

Thanku sir...yr video helped me.I obtained it successfully 👍

@MegaZainabid 5 лет назад

thank you my dear brother. your video is very very informative thanks

@cgme7076 3 года назад

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.

@CodeAndCoins 3 года назад

Very good observation 🙂

@hershey6171 2 года назад

didn't even know pipeline can be used as OR thanks for pointing out

@youaremad1736 Год назад

@@hershey6171 pipelines as or is actually a common in languages like cpp js etc… mist of those languages that uses curly bracets and semicolon

@glorix21h84 4 года назад

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 :)

@vidhvansak6944 5 лет назад

kya baat hai aapne ek hi bar me btadiya thx brother

@krysteljoyopalecmaala5662 3 года назад

hi! Thank you for this code! I was able to run it with my login html file. Thumbs up for you!

@CodeAndCoins 3 года назад

Glad it helped!

@virenderkumar9002 2 года назад

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 🤯🥴

@tanish4593 3 года назад

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.

@rahuljha1361 3 года назад

Thanks a lot for sharing this knowledge and source code.😊😊 I will definitely donate when I completely learn this course.. Thanks once again..😊😊

@CodeAndCoins 3 года назад

So nice of you

@ishitakumari3766 2 года назад

Thanks a lot, i was seraching for the same for very long time, to clarify my doubts. .

@mamtadwivedi5353 4 года назад

Thanks man! Helped me and a lot of other people

@HalloGaming Год назад

Damn you can make a great tutorial you should really be bigger

@CodeAndCoins Год назад

thank you

@muneebmuzammal3987 4 года назад

100% successfully working thanks bro!

@virenderkumar9002 2 года назад

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 🤯🥴

@bhagyasrisatyavarapu5948 Год назад

Super bro I watched many they won't work but it was worked.. Thanks a lotttt🤩😊😇

@CodeAndCoins Год назад

Welcome 👍

@amiralinaser2452 5 лет назад

May God bless you thanks alot. Useful video

@hammadzafar9704 5 лет назад

You did just excellent work bro..

@Shandeeme 5 лет назад

thankyouu!

@arkadyutipaul246 5 лет назад

Great video. Very helpful. Thanks a lot!

@Dloc47 3 года назад

Thanks for quick, informative and very useful video 🔥🙏

@CodeAndCoins 3 года назад

No problem 👍

@mohammedindorewala3903 3 года назад

String ="s" Int="i" Date=? Please guide

@CodeAndCoins 3 года назад

String

@Sunil_KumarDas 6 лет назад

Tutorial is gud but please use better mic and don't hurry tutorial.Tq

@CodeAndCoins 6 лет назад

thank you for your suggestion

@abswps6724 Год назад

vai tum bohot gr8 ho. Hamara Semester bacha liya tamne toh.

@cdrprithviraj 2 года назад

Bro thanks this tutorial helped me lot during my project. Very nice video. Keep up.

@aliciasilva1421 3 года назад

Muito obrigada, funcionou perfeitamente ❤️🙌

@CodeAndCoins 3 года назад

Welcome

@doctorbrad 4 года назад

Thanks for the tutorial but when I click Submit it shows all of my PHP code in a page and nothing happens... HELP, please!

@luckygaba2993 4 года назад

Damn. Same :(

@benjamincook-pirro938 4 года назад

@@luckygaba2993 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 4 года назад

it means you are not using any server for running your code, you can use xampp for the same.

@murniyatiho6320 4 года назад

@@anmolmittal4763 hi.. i already run xampp and connected to localhost, but still not worked after i click the submit button.. please advice... thank you

@anmolmittal4763 4 года назад

@@murniyatiho6320 you have to put your file in xampp folder in order to run the code on the local server.

@yixinliang8212 Год назад

Thank you so much for introducing me this amazing tutorial and phpMyAdmin. It saves me so much work!

@CodeAndCoins Год назад

You're very welcome!

@exoticme4760 4 года назад

thank yyoooooooouu sooooooo much

@enancovers 4 года назад

I need help. Fatal error: Uncaught Error: Call to a member function bind_param() on bool I checked multiple times but nothing worked.

@stuffandcoisas 4 года назад

same

@mohammadusman3930 5 лет назад

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......

@CodeAndCoins 5 лет назад

Can you show me your code. And here I make another video, which may be helpfull for you. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-we5IDfvjtVs.html

@noctiscaelum6523 5 лет назад

@@CodeAndCoins help! mine also does the same thing

@matthewtang5638 4 года назад

did you turn on the xampp apache & mysql ?

@ganeshpalve6187 3 года назад

same problem plz reply

@leonromo523 3 года назад

@@matthewtang5638 yes i have, but it not reflecting on my db

@claybowser 4 года назад

hello programmer, thank you for the video :)

@aakrutipatel367 5 лет назад

Thank you So Much for detail video

@revathis1552 5 лет назад

After getting "new record successfully” how can we direct to next page or next slide

@cedricjoel1042 4 года назад

header('location: index.html');

@nidhipriya7346 3 года назад

can u please tell ,me why i m getting php code after pressing submit button

@slweb621 3 года назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-xHRlr8XccUc.html

@linconelclems2970 4 года назад

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

@onkarbajwa8946 3 года назад

i am getting the same error

@fernandodharmaraja6465 3 года назад

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(?, ?, ?, ?, ?, ?)";

@sravanimudda516 2 года назад

@@fernandodharmaraja6465 even if i change the table name it's showing the same error.🤷

@mohammedsayeed330 4 года назад

Are Bhai Katai zeher hai Bhai...I will learn SQL and PHP soon

@rishusrivastava01 4 года назад

Really this tutorial was helpful! Thank you very much.

@amandeepsinghbisht2345 4 года назад

Fatal. Errors: call to a member function bind_param() on bool please help me to solve this problem??

@CodeAndCoins 4 года назад

Here is a solution forum.codeandcourse.com/viewtopic.php?f=4&t=4

@calvinrodrigues9489 4 года назад

you can try this if it works $stmt->bind_param("s", $email);

@applezhe19 3 года назад

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);

@anandpaul8196 3 года назад

@@CodeAndCoins where we have to save these files pls help me in xampp or wamp and how to execute

@applezhe19 3 года назад

@@acltearjerker you use which web server?? For mine is Xampp (recommended)

@rehabramzan515 4 года назад

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

@sushantagarwal408 4 года назад

same problem with me

@sushantagarwal408 4 года назад

have you find any solution Rehab Ramzan

@natoisnazi Год назад

VERY HELPFUL 👍 THANK YOU BROTHER!

@cyber_killer 2 года назад

Easy,Realable and thankfull video💯....thankz bro...keep it up😊👍

@CodeAndCoins 2 года назад

Welcome

@cyber_killer 2 года назад

@@CodeAndCoins 😇

@medupiramaboea7742 5 лет назад

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.

@CodeAndCoins 5 лет назад

it looks like first you need to know how to run php code

@miw879 4 года назад

@@CodeAndCoins 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

@miw879 4 года назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-soJOBrePwzQ.html you are welcome

@miw879 4 года назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-YsmMVwz1rlo.html im xampp

@30joybhardwaj55 3 года назад

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

@alricklobo3281 3 года назад

same error

@hacker_jha 3 года назад

Same error

@bestscene8381 3 года назад

same problem any one know about this problem plz reply

@ateeqaaslam3799 2 года назад

Same here

@ketanprajapati4786 Год назад

Same here bro

@memealli 3 года назад

Thank you so much. I was struggling for this really!!!!!!!!!!!!!!!!!! finally, it works!!!!!!!

@CodeAndCoins 3 года назад

Glad it helped!

@virenderkumar9002 2 года назад

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 2 года назад

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 🤯🥴

@armintheboi4935 4 года назад

THANK YOU SO MUCH!!! I think you explain really good, so im gonna sub rn.

@nuradibahzolkepli5223 4 года назад

why it didnt work for me? when i click submit button, insert.php source code appear. btw im using wamp server.

@mumukshapant902 4 года назад

same error

@GDBlackRed 4 года назад

When i click submit.. it shows me my php code.. what thehell

@atinyana9879 4 года назад

same i don't know what to do

@vishaldhangar3470 2 года назад

Yes.. same

@operationgaming8957 2 года назад

Do you have php installed and configured?

@jakomedo5123 2 года назад

Open your code using localhost

@donkanji6785 Год назад

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

@ashakiranpratihari4463 Год назад

Contains exactly what i was searching for

@santoshmahto3255 5 лет назад

Really Very Helpful Tutorial

@Amal-jp9lf 4 года назад

This tutorial waste my time after an hour of typing it shows error at least share all the code

@Amal-jp9lf 4 года назад

Yasemin Yıldız thanks I submitted my project before a week but thanks for sharing it will help someone else :)

@bomboshesap1587 4 года назад

You're welcome. mine also did not work. I click submit button, it shows the .php file codes. Any idea why?

@Amal-jp9lf 4 года назад

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

@Amal-jp9lf 4 года назад

Yasemin Yıldız my project: drive.google.com/file/d/1rC1BkY42wzmm1HHnlOTCvcdraJ3WZMJp/view?usp=drivesdk

@rashirkg5702 5 лет назад

successfully connected with database thank u

@krishannagpal8138 5 лет назад

Help.me

@diyasvlogs2835 3 года назад

Thank you I was searching how to save submitted data and except your video I didn't find any video helpful.

@CodeAndCoins 3 года назад

Glad it helped

@diyasvlogs2835 3 года назад

Sir can you tell how to make bacground of a bigger

@gullugullu7576 2 года назад

Thanku thanku sir successful create ho gya thanku sir🙏👍

@bhupensahoo3667 3 года назад

Thanks a lot bro.... Now I can complete my project..

@CodeAndCoins 3 года назад

Great 👍

@senthuran.j126 4 года назад

Thank you very much it's useful to me for a project 😘😄🖤

@bubblylibran 3 года назад

Great video...very helpful for beginners..thanks for uploading this...do we have any option to notify the customer or the admin once form is submitted through email...?

@bikramghosh7929 5 лет назад

your teaching is best teaching sir....

@bikramghosh7929 5 лет назад

Bus trickiting system

@gregsimon462 5 лет назад

Very informative and demonstrated through software correctly . Thanks!

@sandeepyadav1030 5 лет назад

thanks a lot sir, very very thank you sir.

@sushil4211 6 лет назад

very good tutorial and help full please use better mic and dont hurry..

@rawbee8153 3 года назад

bro kahaa kahaa khojina, last maa hajurko paaye, it really helped a lot 😌🖤

@Subam1993 2 года назад

Thank you brother.Love from India

@CodeAndCoins 2 года назад

Welcome

@techcornerng8134 3 года назад

I so much love this, very instructive.. Thumbs UP Man...

@darleneespelico4238 3 года назад

Thank for new begginers God Bless

@CodeAndCoins 3 года назад

Our pleasure!

@dheerajbadiger 2 года назад

your video description is superbb, awesome video....

@oldAccount7247 3 года назад

That was very useful thank you 👊👊keeep it up💪💪💪💪

@jenniferward6821 3 года назад

Thanks for this - going to look at your vids now!

@CodeAndCoins 3 года назад

Hope you enjoy!

@kailashbhujel7777 4 года назад

Thank you so much! It helped me a lot.

@rodrigolozano7687 2 года назад

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