Hello, in this video, I am going to show you how to insert data into your database more specifically into a table using the insert query. Because up till now, all we've been doing is using select query to get data. And any data that we added was through the, you know, PHP, my admin panel is great for testing. But if you're, you know, running a live website, people are gonna want to add data, like if it's a YouTube comment, or a post or video, wherever it is, then it's to happen automatically. Luckily, it's really easy to do. So I'm gonna comment out this.

So really, all we need is these two queries. So we need a query and then we need to execute you don't need to resolve anything. I'm gonna look into that, you know, a bit more for a later video of getting some of the, you know, data back, but for now, we just want to insert it and we'll check it here. So we've got users You know, this is what we've got so far. So let's add a number one, this just get added as soon as the website loads. So when we refresh, you're literally add another one.

And you could do it on a button press doesn't matter, you get the picture. So what you want to do, we'll get rid of that. And you want to put insert into, and first of all need to put the table name. So you then you want to specify basically which columns that you'll be inserting data into, we have a default for title. If we didn't put anything in type, it wouldn't matter. We want to have username filled in IDs auto increment, but I'm gonna put something into type as well.

So I'm going to say for you say which columns that you're going to be inserting data into. So it's user name and type the user name and column type like so. Next, you want to specify the value for input values and then here brackets and then you want to put the value so quotation marks. And for the first one for the username, I'm going to put the comma and for the user or for the type of Sif log, actually what was the classification? The Sif no sis master. have a quick look so for no slide, oh, wait.

This is no sis master. Go into the fandom and the AMA did quite quite a bit to reason about it and pigley as in was Darth Vader as a flawed and adopted Oh yes, he was adopted. I agree with that. And he will first will the Jefferson did not begin unsafe However, he was taken as an apprentice and give the title docile. Yes, he's a Sith Lord. Okay.

So see if load Yep, so if we save that run it nothing displays on here but if I go back here as you can see the data have been added. Obviously if I refresh it twice it will add it to more time but as you can see the ID is being incremented literally that is it. That is how you add information using the insert query into a database database. Really simple stuff. Any questions though, feel free to pop me a message and as usual, I look forward to seeing you in the next video.