22 | INSERT INTO Database Using PHP From Your Website! | 2023 | Learn PHP Full Course for Beginners

In this PHP tutorial I will teach you how to INSERT INTO database using PHP from your website! 🙂 Being able to insert data into your database directly from your site, opens up a lot of cool opportunities and features you can do in a website, and is one of the milestones most people look forward to reaching when it comes to PHP.
➤ TIMESTAMPS
00:00:00 - Introduction
00:00:25 - Prepared Statements & SQL Injection
00:02:39 - User signup HTML form
00:05:19 - Creating formhandler.inc.php
00:08:00 - Grabbing the user data
00:11:32 - Grabbing the DB connection
00:13:49 - Creating our INSERT SQL query
00:15:21 - Positional parameters Prepared Statement
00:19:50 - Named parameters Prepared Statement
➤ GET ACCESS TO MY LESSON MATERIAL HERE!
First of all, thank you for all the support you have given me!
I am really glad to have such an awesome community on my channel. It motivates me to continue creating and uploading content! So thank you!
I am now using Patreon and KZbin Memberships to share improved and updated lesson material, and for a small fee you can access all the material either from my memberships or Patreon, depending on your preference. I have worked hard, and done my best to help you understand what I teach.
I hope you will find it helpful :)
Memberships: / @dani_krossing
Patreon: / mmtuts

[@MessianicJudaism]

I may have to cut my hair, too. I am dealing with cancer. I pray you are not. Thank you for your lessons. It's greatly appreciated.

[@Dani_Krossing]

I'm so sorry to hear that Kelly. In my case I'm dealing with psoriasis, so it isn't nearly as serious as yours. I had to cut my hair in order to give the psoriasis a chance to calm down, since it gets worse over the summer heat.

[@edunjobiemmanuel4200]

So sorry about that. You can FIGHT it✊you got it in YOU

[@farsfuad3002]

I hope you all get well soon

[@danielbuleandra3981]

try eating 2 cups of oats with hot water and banana for a week and see what happends. Itworked for me on head skin issues. I hope you all get well soon.

[@DharmYogi]

There is a lot of research now which indicates that you should avoid sugar and carbs to fight against cancer. Also meditate and do yog(a). stay strong

[@rodgence9641]

New look Dan 😂 Thanks for your premium courses Africa is watching

[@OpenBoxReviewss]

A year ago I was dreaming about making websites and today here I am building one, thank you, your help is much appreciated.

[@Gupatik]

Okay, now this channel is a true real gem for me, it has everything. Maybe it will affect the algorithm a little bit, but that's not all the point of this, the true thing that matters is the lives you have changed with this golden information.

[@user-wu8ow2iw2i]

You have been so clear in your explanation with every single code that you typed

[@edunjobiemmanuel4200]

Kross, you are really saving life with this tutorial. Thanks.

[@akashgola2153]

Like everyone said in the comments, keeeping it simple is the best , also there are viewers from other countries who r not native english speakers hence i believe keeping the english as simple as possible is definitely the way to go . Great Vid.

[@ianmugai6923]

Thank you krossing, you have helped me complete a final year php project with these tutorials. straight foward and easy to learn, I couldn't have asked for more. Be blessed

[@moraaoo4889]

Thanks for simple and clear english, i almost understood everything without subtitle, a lot of loves from Egypt ❤

[@45Marki45]

Man, you are fantastic. I am developing a CRM with freelance developers. But things got expensive and quite slow (we are 10 months into the project). To speed things up I decided to learn web programming and create certain portions of the CRM. I did quite well with HTML, CSS and JavaScript, but when i got to the database part I got stuck until I found your videos. Big thank you!

[@mettysingictsolutions9555]

You're an amazing tutor. I appreciate your sacrifice of giving us this full packaged php content.

[@antomac1511]

I've been watching your videos for a few years now and they are easily some of the best out there in terms of explantation and clarity , keep up the great work!

[@aye6518]

Great series of videos. I hope everything is okay with your health. Stay strong ❤

[@theanonymous41]

great tutorial. Hope you're good man

[@animextreme7]

Your the best teacher i'ved ever watched! keep up Sir

[@chocobo1]

Really awesome series, I followed your last one and now I'm following this one and the slight changes to the code are really helping me understand the differences and what impacts what. Looking forward to more

[@samnako]

Great one Dani, keep it up

[@NkanyeziShenge]

You are so cool bro your lessons are so informative, great foundation

[@neilakrika9964]

thank you for your efforts , better than uni lectures

[@user-xb4xx4yw4t]

Thank you for this tutorial!

[@tejaspathak933]

Thanks a lot Dani!Awesome Tutorial series :) Please take care of your health!

[@AdelinBonheur]

You're my ROLE MODEL, I wish you success in everything!

[@DharmYogi]

Dani Thank you for your lessons. I learned a lot. I just created my sample form and now I will work on creating the real one. I manage to get the database connection part working and loading the data. So I am quiet happy as to how far I got. Thanks again.

[@amaduscamara4378]

i don't have nothing to said thank you 😊😊 your contend is other level

[@TheAllMarket]

Your videos are absolutely the best! You go above and beyond other instructors. You not only explain things perfectly, but you show us all that we need to know about the code and ways you can implant it into our own. Your series is the golden tutorial for anybody learning PHP and even things most videos don't teach such as PHP security which is a must for anybody learning to make their own website using PHP.

[@TheAllMarket]

Your channel is the one I have been looking for. You have earned one more loyal subscriber.

[@user-yp4te1rw8l]

Thank you, very good job

[@janvitek5487]

awesome tutorial I have yet to see your other videos but POD caused me quite a headache since I am working with docker containers as my test environment so I had to improvise for the mysqli connection would be great to have that option as video 22.1 with the bells and whistles you have for this video Overall thank you very much

[@EL_WAFI_CHERKAOUI]

so prepared statements enable the code to separate between data inputs and the actual sql code to prevent SQL injunction , thank you

[@bassemkhozam]

Thanks a lot Dani for the great tutorials and sharing your knowledge. ❤

[@bassemkhozam]

BTW, I love your new haircut 💇‍♂️

[@delta13dek]

You mentioned you cut your hair for health reasons, I hope you are doing well today!

[@Dani_Krossing]

I am thanks 🙂 the hair is fully grown out again

[@dahyun8664]

Waiting for next episode!!

[@RigorousExplorer]

You earned a sub

[@satishg6965]

whenever i see an ad in your video i click them because, this way i give you something, nobody have taught me PHP in your way.

[@rikabel8301]

haircut! but also, great series so far - thanks for all your hard work and clear explanations.

[@wasdaletimelapse7658]

Hi Dani, I have just come across your excellent video whilst searching for a solution to passing data from an ESP32 sensor into an SQL database. I have very limited knowledge of this kind of subject but I am able to follow your instructions very easily but I would like to know if I can use this method to pass the data instead of from a web form but from an ESP32 sensor. I have already tried several solutions but I keep getting stuck at the point of passing the sensor data to the .php file. Again, due to my complete lack of knowledge and understanding of this subject I just seem to be going around in circles. I would really appreciate any pointers you could give me. I will try and follow your PHP full course videos to help me better understand. Thanks in advance.

[@danieldang7239]

quick question I keep getting this message after pressing the button "Query failed: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'username' cannot be null" and it won't send the data to my phpmyadmin database. Do you know how to fix this?

[@fiveten4092]

Help I followed the instructions, but then I clicked the sign in this shows up " Not Found The requested URL was not found on this server. Apache/2.4.56 (Win64) OpenSSL/1.1.1t PHP/8.2.4 Server at localhost Port 80 "

[@maitreethakar5353]

In formholder.in.php i added the location but when i click the submit button i am getting the code of my formholder.inc.php code instead of going back to the previous location....what might be the error here... ??

[@micopalencia]

that new look tho!

[@simsolchanel]

Hello teacher, I would like to ask a question, I have seen some websites use 2D website ... What should we do? Thank you very much teacher ...

[@kylehawks2966]

I keep getting same thing,,,Undefined variable $pdo line 13 Formhandler...same problem can I nest the file some how?

[@j4d_ate]

Hey dear! How may i save images as well as display images? I dont think pgpmyadmin svars images? I am looking forward to nobody but your help. Thank you!

[@satishg6965]

0:20, Bro please take care of your health, im praying from here.

[@LiezelHebbert]

Hi Dani how many rows can php display?? And can you make it more than 500?

[@jasonramirez6182]

bindParam vs bindValues what are the diff of these two sir?

[@dancharlesplange-annan7227]

Please help me out, Hello. I have a button called register that takes care of inserting the users' input into the database. But when i clicked on the button, it showed me the code I inputted for the phpcode for the connection to my database

[@peterochekpo6601]

Hello Mr Dani, thank you for all your good work. I implemented similar thing but this is the error I am getting, "Insert value list does not match column list: 1136 Column count doesn't match value count at row 1". Can you help?

[@peterochekpo6601]

Ignore my challenge please. I was the one who made an error, after a careful check, I discovered I forgot to put a comma (,) in between 2 placeholder question marks.

[@deepindark]

Hi Dani - Your series about using SQL from the website is helping me a lot! However, when I follow along the video to the "Positional parameters Prepared Statement" section, I tried to type-in a new user for sign up so that it can get upload to the database. Instead of that, I keep getting this error and cannot solve it. Do you have any ideas in how to solve that? (I do find out about something that related to 'mySQL default socket' inside the XAMPP folder but all of the fix where mainly the cause from WordPress db sever). "Connection failed: SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: YES)"

[@deepindark]

It's alright now Dani. I have found out the way to fix the issue! 😄

[@stevenoduro1435]

Uncaught PDOException: could not find driver i checked and it said Configuration File (php.ini) Path how do i fix this isssue?

[@MichaelHoague]

I have been a fan of your knowlege. I am dealing with a stoke so excuse me. I am running an issue when I "require_once dataObjects.php". Please Help

[@Tense2006]

does anyone know why after i do $stmt = $pdo->prepare($query); the rest of the things turn into html

[@MyNimrods]

excellent lesson Dani, sorry to see your hair gone. Oh BTW query in English is said "kwee-ree" when spelt phonetically. Hope you don't mind as your English is way, way better than my Danish.

[@Dani_Krossing]

Thank you, yes the hair is a shame, but at least it has gotten a chance to calm my psoriasis a bit. 🙂 and thanks for the tip on query. The “kwe” is hard for Scandinavians to pronounce, same with “thr” hehe. I’ll practice it and see if I manage to say “query” without tying up my tongue in a knot 😂

[@currentlydead303]

Did this and getting request denied. Contacted host and they told me my credentials are right and it's the code. Just so lost right now :/ Edit: I fixed it!

[@alexmienko3112]

Hello, I have a question, hope you can answer. How do I open a file index.php in the browser? If I do it the regular way it returns just the code inside the file. Thanks)

[@Dani_Krossing]

I show how in the first two videos in my PHP playlist 🙂 you gotta make sure you open the site, using your local server, and not by just opening the index file directly in the browser.

[@jeremiahorpilla6537]

the SQL query runs smoothly but why do I get Uncaught Error: Call to undefined function null() when I put the $pdo = null(); $stmt = null(); in the try block?

[@Dani_Krossing]

Remove the () 🙂

[@jeremiahorpilla6537]

@@Dani_Krossing mb already saw it after typing this haha

[@maxjeje8090]

This is the moment Dani became Heisenberg.

[@hatemhashlamoun1915]

I need help, I implemented the same code, but once I submitted my first INSERT code the databaase completly crashed and I couldn't even keep it running on the XAMPP

[@Dani_Krossing]

That seems odd… My only guess is that it is a hardware issue, or you somehow looped the query repeatedly until the server crashed. 😅 I don’t see any other explanations…

[@Trunk_Tech]

Hello Dani please help me sort out this error which state : ***Fatal error: Uncaught Error: Array callback must have exactly two elements in C:\xampp\htdocs\Socialhub_Php\Includes\formhandler.inc.php:2 Stack trace: #0 {main} thrown in C:\xampp\htdocs\Socialhub_Php\Includes\formhandler.inc.php on line 2****

[@Trunk_Tech]

Now this ***** Fatal error: Uncaught Error: Call to a member function prepare() on null in C:\xampp\htdocs\Socialhub_Php\Includes\formhandler.inc.php:17 Stack trace: #0 {main} thrown in C:\xampp\htdocs\Socialhub_Php\Includes\formhandler.inc.php on line 17***** Anyone with an idea

[@kylehawks2966]

I'm getting a 403 code after I submitt but data is going to table,also not getting pop up for the first page is this something to worry about or ....?

[@Dani_Krossing]

I believe that is caused by a incorrect username or password in your dbh.inc.php file.

[@kylehawks2966]

@@Dani_Krossing I've looked I don't see 1 $dbusername, $dbpassword?......also $dbpassword = "";

[@Dani_Krossing]

@@kylehawks2966 These two videos should help you out. kzbin.info/www/bejne/qnmupI2aiJ2Cq8k&ab_channel=DaniKrossing kzbin.info/www/bejne/bXKvh3Znmryamqs&ab_channel=DaniKrossing

[@kylehawks2966]

@@Dani_Krossing I don't mean to be a pest.... but I literally have your code to the letter and using your editor everything I tried the cleaning tables nothing i'll try a pasword

[@kylehawks2966]

I now can't get into my admin ...yes put password in inc file

[@lifeinspirers]

Please do these videos in mysqli

[@Dani_Krossing]

My older PHP course uses MySQLi if you are interested 🙂 it can be found on my channel page

[@dylankatamba8124]

i used all your codes but am getting an error [HY000] 2006 , server has gone away , please help

[@TechTheNoob]

You're like the Mr Beast of PHP MySQL tutorials. I'm now rich with knowledge now, thanks.

[@Izkawi33]

why you didn't use bindParam method when using question mark?

[@Dani_Krossing]

As I explained in the video, we pass it in using an array instead, inside the execute() method. 🙂

[@Izkawi33]

@@Dani_Krossing but as I red it is better to use binParam method everytime after prepare statement to secure and prevent sql injection

[@Dani_Krossing]

Both methods are for protecting against SQL injection 🙂 The bindParam() function is just a small part of the overall prepared statement that we create, in order to protect against injection. bindParam() is just used to bind the users data to our statement, using a keyword that we decided using a placeholder like ":username" inside the query. We can do the same when using non-named parameters, which means we don't need to assign the users data to for example a ":username", since we used "?" as placeholders instead. So by using non-named placeholders inside the query using "?" instead, we no longer need to match the placeholder with the data, and can just pass the data directly inside the execute() function as an array. 🙂 Again... It's just two different ways of using placeholders for the parameters. 😊 Both are preventing SQL injection. So choose the one you like more.

[@rgbcheck2155]

I need your Help. i do everything and i get this Error. Query failed: SQLSTATE[3D000]: Invalid catalog name: 1046 No database selected Can u tell me what else i need to check. Because all files. are good but if i submit i get this message ??? :(

[@Dani_Krossing]

It means you didn't select a database for the query. Maybe you made a typo in the databases name in the dbh file.

[@rgbcheck2155]

still the same Error Message. Idk if thats important but look at this Code here $dsn = "mysql:host=localhost;dbname = frst_db" the equal before my frst_db i had to put space before and after the equal sign. The only Problem ist when i submit the data. After clicking the button i´ll get this Error. @@Dani_Krossing

[@CreamyLiez]

anyone ever tell you that you look like Elon musk a little?

[@nimomaniachannel]

😆😆

[@pkpotate]

BRUH that's the feeling I was getting when it was grown out haha

[@hamdikurdi]

yeah, i have been thinking about this even right now ,he looks like him and speaks like him.

[@klirmio21]

For health reasons? Are you okay Dani?

[@user-ch2tt1po7h]

Hi Dani - I keep getting this error and cannot solve it. Any ideas? Connection failed: SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: YES) Warning: Undefined variable $pdo in C:\xampp\htdocs\MyWebsite\includes\formhandler.inc.php on line 13 Fatal error: Uncaught Error: Call to a member function prepare() on null in C:\xampp\htdocs\MyWebsite\includes\formhandler.inc.php:13 Stack trace: #0 {main} thrown in C:\xampp\htdocs\MyWebsite\includes\formhandler.inc.php on line 13 Thanks!

[@user-ch2tt1po7h]

I fixed it!

[@kunalyadav9727]

bro im also facing the same error how to fix it @@user-ch2tt1po7h

[@kunalyadav9727]

??

[@user-ch2tt1po7h]

I believe I had to add "root" to both $dbusername and $dbpassword in the database connection page, or delete both and just put ""@@kunalyadav9727

[@mackevinmontano7888]

how din you solve it bro?

[@user-ge1sq3nx1z]

I’m trying to learn to do his right so its really frustrating to spend a lot of time typing in code and trying to figure out what it is doing only to have you say, but this is not the way we should do it. I don’t care how we shouldn’t do it, only how you should.

[@Dani_Krossing]

I am a teaching channel, not a how to channel. I’m sure there are other channels out there, that only focuses on giving you quick solutions. 🙂

[@user-ge1sq3nx1z]

@@Dani_Krossing What’s the difference. Aren’t you teaching how to?

[@user-ge1sq3nx1z]

@@Dani_Krossing I’m not looking for quick solutions, I’m looking to understand “how to”. I, unlike most, am looking to actually understand what is going on with the software so that I can craft a solution for any situation. I don’t want you to show me your way and then attempt to memorize it as that leaves you with one solution and one solution never fits every problem. I spent most of my life fixing computer hardware. I was very successful at it because I, unlike most, actually knew how the equipment worked. I’m taking that same attitude into learning modern software. The paradigm where we have html, css, javascript on the browser side, http in the middle, with php and sql on the server side is really interesting for me and I enjoy your explanations as I want to know the details. To many sites want you to memorize and copy “their” solution which probably works most of the time. As the software evolves they are left back at the old way because they don’t actually understand what the details are and how they fit. Please don’t take offense, I was just telling how it looks from my side. Regards, Terry

[@Stash.J4d]

For health reasons? are you okay? We hope your as healthy as possible at the time.

[@Dani_Krossing]

Yes I am healthy 😊

[@ColorfulWonders]

I followed this tutorial to the letter but for some reason my database isn’t updating when I use the form. There no error message, so I’m not sure what the problem is. I’ve gone over this video and my code multiple times, I’ve restarted my computer and everything, still doesn’t work. I have no idea why. Help? Love this video series btw.

[@Dani_Krossing]

Paste your PHP code here 🙂

[@ColorfulWonders]

@@Dani_Krossing

[@ColorfulWonders]

@@Dani_Krossing

[@ColorfulWonders]

@@Dani_KrossingI keep trying to share my code but I think youtube may be deleting my comments :(

[@Dani_Krossing]

Yeah it sometimes does that. I can see it now. I’ll check it out once I get back to my PC later 🙂

[@stranger9951]

Do you know u/colschrapnel from Reddit?

[@breawen]

10:54 "so i'm going to _die~_ "

[@DejanPavlovic-tu8vj]

You look better with long hair :) after ton of advices you gave to us, perhaps we can give one suggestion to you ? :) hehe GL

[@nimomaniachannel]

i miss his hair 😢

[@waldoglas3412]

we like the long hair more

[@waldoglas3412]

Also your video helped a lot thx

[@mkumsengaung5438]

Hi @Dani_Krossing I am truly grateful for your videos. I appreciate your hard work and fantastic explanation. I do face an issue while following along your tutorial, When I submit the form, it states "NOT FOUND: The requested URL was not found on this server." I would truly appreciate it if you can help me. Thank You!

[@Dani_Krossing]

It means that your path inside the "action" of your form, doesn't point to the correct file. 🙂 So either you made a typo in the path, or your files are differently structured than what I do in the video.

[@mkumsengaung5438]

@@Dani_Krossing You were right! I had a typo. Thank you for the reply! Greatly appreciate it! You are the best! 🫡

[@new-in8yt]

thank you so much and i have a question what is the deference between this $query = "INSERT INTO users (username, pwd, email) VALUES (?,?,?);"; $stmt->execute([$username, $pwd, $email]); and this $query = "INSERT INTO users (username, pwd, email) VALUES (:username, :pwd, :email);"; $stmt->bindParam(":username", $sername); $stmt->bindParam(":pwd", $pwd); $stmt->bindParam(":email", $email); $stmt->excute(); and which one better or when we use they ?

[@Dani_Krossing]

Each do things slightly different, but it's more from a maintainability point of view. So it's not about "which is safer" or "better". 🙂 The first one is called "positional placeholders", and essentially just match the data you later give it, in the same order as the "?" in the query. So kind of like how arrays work. Where as "named placeholders" allow us to actually label the "?" inside the query, which makes it easier for us as the developer, to know what the "?" are supposed to be. So whether you use one or the other, is more about personal preference, or if your work place demand that you use named parameters, to make it easier to hand off the project to someone else. So basically it's about: "Do you want slightly less code?" or "Do you want the parameters named?" 🙂

[@new-in8yt]

thank you so much ❤❤❤@@Dani_Krossing

[@stateofalawites4039]

Idk why once Iclick submit somehow it puts me in the dbh.inc.php page And The data I sent isn't getting inserted into the database Even tho I eventually copied ur code literally

[@Dani_Krossing]

I can guarantee you with 100%, that there is a typo in your code, based on the description of the error you are giving :)

[@stateofalawites4039]

​@@Dani_Krossingoh yeah... I didn't notice I typed post instead of POST in the if condition equality to the request method Thanks

[@jamesosteen982]

@@stateofalawites4039 wish i knew what was causing my problem. I enter the form data, hit submit, it goes back to the form index page like it submitted everything. No errors. But nothing in database either. Ugh. I've looked over the code 10 times and its exactly the same.

[@tonester1964]

Help! I followed the steps outlined. When I click the Submit button I get 404 Not Found Error. What could I've done wrong? The only 3 files I have are the index.php, dbh.inc.php, and formhandler.inc.php. I'm unsure how to fix this. Any help is greatly appreciated. The difference is with the database name, mine is named "ais_db". $dsn="mysql:host=localhost;dbname=ais_db";

[@Dani_Krossing]

404 is a "page not found" error. Meaning that the link in your form inside the 'action' attribute, is incorrect, and doesn't point to a page.