Save HTML Form Data to a MySQL Database using PHP

No video

Save HTML Form Data to a MySQL Database using PHP

Рет қаралды 199,177

Dave Hollingworth

Күн бұрын

Пікірлер: 383

@dave-hollingworth 2 жыл бұрын

What do you find most challenging about working with HTML forms and PHP?

@judgeguilty 2 жыл бұрын

Security on the client and server side.

@realchicagophill 2 жыл бұрын

You currently have a course on codeigniter 4 on Udemy. How comprehensive is that tutorial covering features of the framework? I might be interested in that one.

@dave-hollingworth 2 жыл бұрын

@@realchicagophill It's pretty comprehensive - you can access the course here: davehollingworth.net/codeignitery

@realchicagophill 2 жыл бұрын

@@dave-hollingworth I'm half way through it.

@davidacq2026 2 жыл бұрын

The question of how much input sanitization e.g. strip_tags( trim( $_POST['value'] ) ) would be advisable before validation, or rather not using any sanitization at all before input validation.

@dryandave Жыл бұрын

This channel deserved more than 8k+ subscribers , hopefully you will not get tired in continuing in sharing your knowledge with us Dave. Blessed you. more power. ❤

@someutubchannel69 2 жыл бұрын

Dave is an amazing teacher and Masters PHP, I took one of His courses in Udemy and it was one of the best courses I have ever taken.

@FriedrichBoettger Жыл бұрын

I'm with you. His Beginner's PHP course was so simple even I understood it. Dave's a cut above most of the instructors on Udemy (though many are knowledgeable). He's got a great and measured speaking voice, knows his subject and takes his time explaining the subject.

@jchuillier 10 ай бұрын

Usually I need to watch 5 tutorials do be able to do something, you managed to make everything working well on the first try, many thanks for your help

@rajashreejarande7907 Жыл бұрын

Thank you soooo much for this video. I was literally struggling to complete my project based on a similar concept. I referred to 10+ websites and other videos but i finally understood how to actually do this after watching your video. SO a big thank you. Please keep helping people

@earlpatterson6404 Жыл бұрын

Hi Dave, I am new to PHP and have tried about a dozen different videos but could not get the data from my registration form to populate into my database. Your the first one that I had success. I also learned a lot while I was following along. I hope you decide to do a tutorial on designing a membership login system. Keep up the great work and I appreciate you taking the time to do this video.

@dave-hollingworth Жыл бұрын

I do have a signup and login system video already, that I hope to expand on soon with a "part 2": kzfaq.info/get/bejne/a7JpiMuA09vTo2Q.html

@thejoker8705 Жыл бұрын

We had a 1st gen Echo in our master bathroom for listening to music in the morning kzfaq.infoUgkxABghAEkaIDGZfHRBH3D3rBrlraNmnC71 and while in the shower. I didn't realize how tinny and awful the sound output on the original Echo was until we replaced it with the Studio. It was a sonic upgrade far beyond what I was expecting. Just wow. I love it because it's like having speakers IN the shower. My friend likes it because the music is so loud that she can no longer hear me singing. So that's a win-win.

@sathvikthandra8592 Жыл бұрын

Saved my day, month ,semester

@yherair-jk5qh 2 жыл бұрын

Thanks Dave I was able to understand and returned back in html, php & sql coding again.

@ianalfwani7638 Жыл бұрын

This is the simplest and best explained tutorial on PHP and SQL very very helpful Hollingworth.......... respect

@emilym4441 Жыл бұрын

This video helped me so much! Thank You! I watched so many other videos trying to figure out this topic and you were the first to explain it well enough and show exactly how to complete the steps.

@antoniopango1841 Жыл бұрын

Thanks Dave! I'm really impressed how you lecture. You find the right time to explain a concept or parameter. Well done!

@porshkabir2535 11 ай бұрын

Your content is a life saver. It's really difficult to find content where it takes you step by step process with a good explainaton. after tons searching I found this gold mine :)

@CodeLaniakea-tf5no Жыл бұрын

Clear Explanation so I can follow your instruction with no error! Thankyou Dave

@hakanyargici 3 ай бұрын

You deserve more subscriber!

@mathdothings 7 ай бұрын

This channel is awesome! Thanks for every content you do, I can see how much effort you expend to bring us truly good videos. I know this is beyond this video scope, I'm curious to know which distro you're generally using on your videos showcases?

@dave-hollingworth 7 ай бұрын

I use Xubuntu 22.04 LTS

@ravichandrasangam1162 11 ай бұрын

Excellect video with minute details. Thanks so much for uploading this video. I am sure I will be watching more of your videos

@novabunny663 2 жыл бұрын

Hey, I just watched this video and this was quite helpful to me, Thanks Man. Im gonna check all your videos. Love you man. Your discription was way good and understandable.

@hinglemcdingleberry5511 Жыл бұрын

You are a great teacher my friend! Good moderate pace and very well explained.

@FebryanIbadurrahman Жыл бұрын

Thank you Dave! You helped me to understand the part that i dont understand to make my coursework :) I wish you everything good in life :)

@arminegilavyan952 Жыл бұрын

Thank you so much, had a dozen of tries , but no success, and here...my problems are solved any more!!!

@user-xd9ru6pm4l 6 ай бұрын

thank you so much for helping me. I'm a newbie in web development. looking a mentor. :) i will followed you and thank you so much. im from philippines.

@Lowlandlilin Жыл бұрын

Greatest video i've ever seen. You might just be a genius at the process of education

@mateuszmurak9965 Жыл бұрын

Exactly what I needed. Man, i owe you my college diploma

@aloalo-ss5vl 7 күн бұрын

Thank you sir

@craigc5879 2 жыл бұрын

Funny was only thinking yesterday, we must be due for a video. Purchased three of your courses on Udemy and found them easy to learn to the point I am cutting code in a major work project

@orlignegron1790 Жыл бұрын

Excellent video, the best explanation I've had, thank you.

@aloalo-ss5vl 7 күн бұрын

Legendary tutorial

@TradingToolkit Жыл бұрын

Amazing Tutorial, absolutely life saver!

@dragunyt2727 Жыл бұрын

Very well explained and easy to follow, thanks.

@nazareno.marcelli 4 ай бұрын

Best Tutorial ever!

@akhileshkumar-iu9uq 2 жыл бұрын

I have subscribed your api course from udemy

@OpenFreeTechnologies Жыл бұрын

its good precise and to the point

@user-ww7yz3mk4w 3 ай бұрын

thank you ! helpful

@nadergad8725 Жыл бұрын

Thank you very much seriously. Simple, focused, and powerful.

@atharvambokar6187 Жыл бұрын

thank you for your wonderful explanation sir

@Adhithya2003 Жыл бұрын

Superb video, you are calm and composed :)

@micheldenostredame408 7 ай бұрын

This is stuff that i could buy :)

@kramerbua4306 2 жыл бұрын

really excellent, noone could explain it better

@Mari_SMS 7 ай бұрын

Great job Sir 👏

@thomasmv6440 11 ай бұрын

Thank u Dave, good

@monduli Жыл бұрын

Great tutorial - thank you very much. You've got a new subscriber!

@romilpatel9968 2 жыл бұрын

very detailed explanation helped alot thank you....

@ansaraliakash Жыл бұрын

Thank you so much Dave! I'm really curious about security of php code as I'm new to it

@kimmimiley900 2 жыл бұрын

Thank you thank you thank you for all of these amazing videos about php!

@gensys244 2 жыл бұрын

This is amazing clear nice speed and amazing as usual i really enjoy every one you do. Thank you for you work on these !

@Divinetots Жыл бұрын

this video saved me. thanks.

@yashashreeprabhukhanolkar3277 10 ай бұрын

thank you so much☺

@rixochixo Жыл бұрын

THANK YOU SO MUCH!!! :D

@RishirajDesigns Жыл бұрын

Excellent teaching skills!

@mojtabaheidari3170 Жыл бұрын

GREAT VIDEO😄😄😄

@raziehzabihiasrami9264 2 жыл бұрын

Your explanation was excellent and sweet and understandable thanks

@fredericoamigo 2 жыл бұрын

Brilliant video! I am trying to learn how to do this I JavaScript. For some reason I find this easier to do in php.. If you by chance know about a good resource that teaches how to do this I JavaScript also I would appreciate that:-) In the meantime, I’ll stick with this in php:-)

@rayaneeeee Жыл бұрын

you're a legend!! thanks a lot, sir.

@ilya_123__ Жыл бұрын

thank you

@sixtusushahemba9419 Жыл бұрын

Great job, thank you!

@dusabimanamartin5395 4 ай бұрын

Thank you sir now I can connect html form to database! The problem is that I can only see one record in the database after adding more

@dave-hollingworth 3 ай бұрын

This could be for many reasons - try comparing your code to the code from the video (link in the description)

@bigsmoke5930 2 жыл бұрын

Thank you very much sir! God bless you

@InspirationBroadcast 2 жыл бұрын

Thanks for your wonderful contents. It's really helping me. Please can you make a core PHP tutorial with the Twitter API? Thank you

@dave-hollingworth 2 жыл бұрын

Thanks for the idea!

@user-tg4vl8sl3w Жыл бұрын

Hi Dave, thanks for the video I was looking for. Everything else is working fine instead the records are not inserting into message table and there is no error showing in code or error log. Connection to the database was successful.

@dave-hollingworth Жыл бұрын

Try using the mysqli_error function just after the code is insterted, and temporarily comment out the line that redirects so you can see the error. Documentation is here: www.php.net/manual/en/mysqli.error.php

@callmejames1010 Жыл бұрын

first i'd like to convey words of appreciation for your impressive work. are u using visual studio to write the code or any recommendation for HTML,PHP texteditor? do i need to start the mysql server in my xampp before doing all this? or are you using xampp at all in the first place? your answer is greatly appreciated. thanks

@dave-hollingworth Жыл бұрын

I used Atom for the video, but this has been discontinued now. At the moment I recommend VSCode as an editor. Yes, you need to start the web server and the database server for this to work. I'm using (and recommend) XAMPP.

@aaronargottelopez3488 Жыл бұрын

thanks!

@imlittledoo6969 6 ай бұрын

is it possible to replace the "echo" at 23:40 with an html page (with css and stuff)?

@dave-hollingworth 6 ай бұрын

Absolutely, just close the PHP with the closing tag ?> and start some HTML

@dowhilltourismorganisation1979 Жыл бұрын

It is terrific

@Tech_With_Elisha 2 жыл бұрын

Thank you.

@edbull4891 2 жыл бұрын

Great presentation. When an error is experienced, or the form was completed successfully how do you restart the form entry ?

@dave-hollingworth 2 жыл бұрын

In this example, you just go back in the browser. If you want to clear the form, you can refresh it by holding down the left shift key while pressing reload. In practice you'd probably have some client-side validation in JavaScript on the form, to make sure the form is valid when it's submitted. The server-side validation is just to make sure valid data doesn't get to the database.

@xanzerex1926 2 жыл бұрын

Very nice video you are an absolute help for me 🤠

@AmirKartik Жыл бұрын

thanks you for the guide! is there a way to send everything done here to another PC and for it to work the same? including the DB configuration on phpmyadmin? how do i do that? if not what can i do to create a simple page with db to be able to send it to others and work the same as it works for me?

@3101199 2 жыл бұрын

Could you please make a video about how to show the stored data and be able to filter it? Thanks in advance

@guodalaurinaviciute487 Жыл бұрын

Great video

@nguyenhuuhoang8131 9 ай бұрын

nice tutorial

@Kysk Жыл бұрын

thank u very helpful

@farhadali593 2 жыл бұрын

Amazing, Love you buddy!

@cheeksmcclappeth6407 Жыл бұрын

This video is very insightful. Thank you! I ran into trouble when I clicked the button to submit the form. Instead of displaying an array, the PHP code is displayed. I moved the files to the root folder for XAMPP, and received a similar error (error 405, "this page isn't working") until I typed in localhost/[directory]. Hope this helps people with a similar issue.

@makavich 11 ай бұрын

you found any fix?

@wanplanet7083 2 жыл бұрын

Nice work

@HkH-ie9eg 10 ай бұрын

Hello. I repeated the steps like you, but when I click on the form, I see a blank page and no information is entered in my phpmyadmin. What do you think is the problem?

@dave-hollingworth 10 ай бұрын

Please see this video: kzfaq.infoK4TMD0mLOJY

@cosmonautilus1181 2 жыл бұрын

Hey, I have a question. Let's say I want to use one form that is able to insert data into multiple tables, how do you do that? In the tutorial there is only one table that is being inserted with data. I can imagine you need multiple variables that have the "INSERT INTO tablename (X, Y, Z) VALUES(?, ?, ?, )" but how do you deal with the $stmt and mysqli_stmt_execute? Btw the tutorial was top notch. Learnt a lot from your vid!

@dave-hollingworth 2 жыл бұрын

I replied to this in the code Gist here: gist.github.com/daveh/c5a691136c7e3b81dc8e72b3fc1054b3?permalink_comment_id=4232439#gistcomment-4232439

@cosmonautilus1181 2 жыл бұрын

@@dave-hollingworth Hi Dave, thanks a lot for your reply. You're a great teacher and I subbed to your channel and followed your Github!

@Un.imaginabl 9 ай бұрын

When I submit the form with information, I don't see any output on my screen. It's just a blank screen. Why would this happen? Is this because I'm on a Mac?

@dave-hollingworth 9 ай бұрын

Please see this: kzfaq.infoK4TMD0mLOJY?feature=share

@sreevallis7751 7 ай бұрын

The data is entered in to php tables is it possible to insert into mysql tables.

@frantzlapointe9965 11 ай бұрын

wow thanks a lot!

@programist1898 6 ай бұрын

I've got a problem when i submit my form, I am just geting the php code and the data isn't sent. How can i make it work ?

@dave-hollingworth 6 ай бұрын

kzfaq.infol7ERVQd7Ti8?si=ooLBabhDo-qR3Rj6

@MrMahesh7001 Жыл бұрын

Hi Dave, Nice video tutorial . One small query here, how to run it on localhost?

@dave-hollingworth Жыл бұрын

You need a web server and database server installed - I recommend XAMPP if you don't have one

@ehm243 2 ай бұрын

but how can i take this to a web server? I have in my server on ubuntu the file.php and the index.html copied from your video and when I access the server with my phone and enter the message, on phpmyadmin I can't see nothing.

@dave-hollingworth 2 ай бұрын

You need to upload the files to a web server, e.g. davehollingworth.com/go/hosting

@chibuzordesmond3937 2 жыл бұрын

Was character binding originally introduced for security? There are easier ways to edit strings and I’m completely new to php [and web dev], kinda curious. Those methods do involve quotes, but the param binding still ends in quotes, so is there a real difference between it and the other string manipulation methods?

@AkshatGarg-xk7tt 5 ай бұрын

awesome

@Dean1991x Жыл бұрын

Brilliant video! Is this possible to do but where the html form is stored in a shared drive and the database is Microsoft access? Any guidance on this would be amazing!

@dave-hollingworth Жыл бұрын

You can connect to an Access database using PHP, details here: www.infocaptor.com/microsoft-access-database-using-php-pdo-odbc-example Although you'd still need a web server to run the PHP code.

@Dean1991x Жыл бұрын

@@dave-hollingworth thanks! Maybe this could be your next video? Haha

@reeissu Жыл бұрын

Hey there Dave, I have a slight problem with the code, I've used the data from github and made my files they same way you did, but my problem is that whenever I submit the form it shows me the code of the php file, do you have a fix for this problem? thank you.

@dave-hollingworth Жыл бұрын

If you're seeing the PHP code, it's likely that you're opening the file using the web browser as a file manager, and not in a web server - you need to have a web server installed and the URL (the address in the browser's address bar) needs to be something like localhost/process-form.php (and not something like C:\files\form.html)

@reeissu Жыл бұрын

@@dave-hollingworth Thanks, is there a tutorial on how I can install a web server?

@dave-hollingworth Жыл бұрын

@@reeissu I recommend XAMPP - you can download it from here: www.apachefriends.org/

@reeissu Жыл бұрын

@@dave-hollingworth thank you, I've downloaded the program, do you have an idea on what I should do next?

@dave-hollingworth Жыл бұрын

@@reeissu Follow the installation instructions for your OS. Then you should get an application running where you can start Apache running. Then put your PHP file in the web root folder (the application will tell you which folder this is - usually called "htdocs" inside the XAMPP installation folder). Files in this folder are available at localhost/

@anpvr Жыл бұрын

Hai, I have a doubt, i have changed the mysql and apache server port numbers, I have printed the values in the aray but can't connect to localhost, need to add any additional codes because i have change the default port numbers

@dave-hollingworth Жыл бұрын

You can specify the MySQL port number as the fifth parameter to mysqli_connect: www.php.net/manual/en/mysqli.construct.php

@karimkaunda6733 2 жыл бұрын

That is awesome Boss

@anthonyplanos1580 9 ай бұрын

what shortcut did you use to automatically adjust the indentation in vscode?

@dave-hollingworth 9 ай бұрын

Highlight the text you want to indent, press tab (or shift-tab to reduce the indentation)

@bankoledada Жыл бұрын

can you create a search function to pull from the database created via the html form? i am thinking this would be a php funtion

@KnowledgePower-xg5ff Жыл бұрын

I want to enroll to your course. But im really looking on how to extract data from mysql and display it to html. none of these tutorial here works on newer version of chrome browser.

@dave-hollingworth Жыл бұрын

I've tried it in Chrome and it works for me - what exactly is the problem you're having?

@BenjaminDeMesmaeker Жыл бұрын

Hi Dave. I am still a bit new to coding but was wondering if it is possible to add a button: "take photo". Can a picture then be taken and added to the mysql database or does this option not exist?

@dave-hollingworth Жыл бұрын

You can do this with JavaScript in the browser, e.g. usefulangle.com/post/352/javascript-capture-image-from-camera To save it, you'd have to upload it to the server. You don't usually store binary files like images in a MySQL database, what you'd do is upload the file to a folder on the server, and store the filename in the database instead.

@martinbatista5429 Жыл бұрын

trying to make it work on my website and getting configuration issues.

@buwiesit2813 Жыл бұрын

Hello! ive been wondering where can you access phpmylogin because I can't find that certain web. Do I need to download it?

@dave-hollingworth Жыл бұрын

Yes, you need to install it - if you're using XAMPP, it's included

@joshuazaldana7681 Жыл бұрын

Hi Dave! When I submit the form, instead of being processed through the PHP file it just shows me the code from the process-form.php. I do have the method="post" in my form, so I really don't know what is going on. Could you please help me?

@dave-hollingworth Жыл бұрын

Please see this video: kzfaq.infol7ERVQd7Ti8?feature=share

@Balaa0528 8 ай бұрын

Is it only works if you have a website? I mean can I do it in my pc only with vscode?

@dave-hollingworth 8 ай бұрын

You need a web server in order for this to work. You can install one with XAMPP.

@tonyg5132 Жыл бұрын

Can you please tell me why I can't even do the very beginning of this because my php files download instead of showing Array([Type]=> 1) I've been trying everything and I have no idea what is causing this.

@dave-hollingworth Жыл бұрын

Are you opening your files served from a web server or using the browser as a file explorer? If the address in the address bar of the browser is something like file:///Downloads/form.html then this is why - the address needs to be something like localhost/form.html. If you don't have a web server installed, I suggest XAMPP.