Hello, in this video, I am going to show you how to extend what we had from the previous video. So you can load data from a database using Ajax. So what we have is index four, and this Ajax four right here. So this index is exactly the same on the, you know, modifying this, this Ajax file, I'm literally just replace the code with the code from the video of connecting to a database, and highly recommend you know that you go ahead and do that. So I haven't removed these yet, but you will want to get rid of these because what happens if you don't, and like I'll put something in there which, which is what triggers the AJAX dot php file, it returns anything that gets echoed out which we don't want it, you know, you're returning this. So we'll get rid of that.
And if you have any errors, you need to handle them in some other way. You might actually print you know, pumping out data, but you'll pump it out and then hand in PHP the way you want to display tech would do that. No, it's all Good. So this is connected to local, we actually go on myadmin epi database, and we can potentially get something from here. So what we are going to see is in here. So there's a few different things that we could potentially do with, you know, the database.
So actually, there's technically unlimited amounts that we can do. You could create some sort of user system or something I'm going to touch, touch at, you know, in a later part in the series in a separate section, you could get the, you know, data, maybe some results, maybe you are searching for a user, and it prints out, you know, essentially their data for sample and I think what we could do is some Fein along, you know, those lines. So, so let's have a look. Yeah, let's do something like that. So let's essentially just do a simple select query. So what we want to do is down here, we want to create a query, query equals connection.
Prepare, I've got one thing in here, instead of you know, sending something as unknown, we're gonna send the user name. But this is and obviously, if you're doing something really sensitive, I recommend a switch this to a post request, which was a separate task from the previous video to switch this up. So you know, feel free to do that in this video if you didn't do it in the previous video. Okay, so I'm gonna call this user search, search and usage, okay, so set that back in here we need to actually get that data. So we're going to say dollar user equals So this is you know the data that we want to search now I'll say dollar get you that so we can see the distinction between yield with this equal dollar on the school get the name and make sure that's where I named it.
Yes username. Okay, fantastic. So now we can do a prepare our query. So we are gonna select the select everything from the US table, where were the username to the user name field is equal to Dollar get user. And now we need to actually execute the query. So query execute.
And what I'm going to do now is dollar result equal dollar query, set fetch mode, PD. Fetch associative, so it's going to fetch it as an associative array. So good even docking code needed this. So let's just see what we gave the echo dollar query. So if you go back, reload, we'll talk something in here. We have a couple go recoverable fatal error on line 25.
Echo dollar query, if we actually put a username so if we put Batman Yep, still doesn't like that. Okay, so let's go back here instead of doing this to the actual. Okay, so that could potentially be returning data. We're going to take a step further, we're going to do a for each. So for each new recursive array iterator, query, fetch all as garlic And then from here, because we cuz I know that will only ever be the one thing that's returned actually there could be multiple, there could be multiple usernames potentially with the same we never did that check in you know separately so you know, multiple data could actually be returned. So this will be interested in say, Echo, dollar value.
And I'm gonna say dollar ID, and with the dot, colon dot dollar value and get the username services from the database dot I'm going to put a line like so. So you should be ready to run so far, we load up to one, we are getting no data return. If I tell him that, man, we get the data and as you can see, the website didn't reload. I'm going to put this in here. Could we have two of these? We should get 30.
You know, co London this 31. co London this 22 Conan and this. So if I do that, there you go. Yeah, you can see works with that it doesn't with that it does. And space is a different thing as well. So there you go. So that's literally how you get data from a database using Ajax.
Dino this fall will essentially still be you know, the basic PHP, get the data as you want form, ideally formatted into some sort of structure that is easily manipulated in here around what used to do as an extra tack is, you know, figure out because when we echoed out, fetch all it was returning an array, and we need to work out how to actually pass the array in here on the front end JavaScript. side. But that's really it how to get data from the database by going to extend a bit more, making more useful. And yeah, that's it any questions, feel free to pop me a message. And as usual, I look forward to seeing you in the next video.