Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
MySQL is by far the most popular database management system for small- to medium-sized web projects. In this course, Bill Weinman provides clear, concise tutorials that guide you through creating and maintaining a MySQL database of your own. Bill explores the basic syntax, using SQL statements to create, insert, update, and delete data from your tables. He also covers creating a new database from scratch, as well as data types, transactions, subselects, views, and stored routines. Plus, learn about the multi-platform PHP PDO interface that will help you connect your database to web applications.
In this movie, I'll show you how to install the SID application on a PC running Windows. First thing we're going to do is we're going to bring up php My Admin, we're going to import some databases. So I bring up Local Host and, I click on php MyAdmin. I'm going to come over here to Import. And choose File. So there is three databases we're going to import. I'm going to import each of these one at a time, so I start with album MySQL, want to make sure the character set is set to UTF-8 and if it's not you want to select that, and I'll scroll down here and press Go and that import it.
That first album database. And now we're going to do the same thing for the other two so, scratch, open, UTF-8, Go. And, world. Open. UTF-8, and this one takes just a little bit longer. And there we go. So now if we come over here to databases we see these databases that we just imported. There's the album database, and the scratch database, and the world database.
So I'l go ahead and close the browser for now, and now we're going to install SID and another application called CRUD. And we're going to install these in the xanp folder and under xanp. See a folder called htdocs. And that's where everything goes that can be seen by the web server. And so that's where our applications are going to get installed, so I'm going to come over here to our exercise files, I'm going to take these two folders, SID and CRUD. I'm holding down the Ctrl key as I select them so that I get both of those folders, and.
There into our HT docs folder I'm just going to drag those. I'm going to hold down the Ctrl key while I drag them so that they get copied, and not moved. So, now we have copies of them and you see that they still exist here in the exercise files. And that's important. Because if, for some reason you make a mistake while editing them or something, you've still got another copy of them. They're not very big. So we'll start in the SID folder. And we're going to edit this sid.php. I've got it configured here so that when I, open a php file it, opens it with, Notepad++.
Or you can right click on this and you can select Open with. And under more options you can find out how to open it with Notepad++ the application. So I'm just going to go ahead and open this with Notepad++ and there's our sid.php and as I scroll down here. Somewhere around line 50 you'll see something that says MySQL pass and you notice that the user's already set to SID but you want to make sure that the user is set to SID and then the password is going to be that password that you entered in the lesson on setting up the users.
And I'm going to enter the silly password that I entered there, press Ctrl+S to save, and again don't use this password, this is just for demonstration purposes. And so I'm going to go ahead and close SID, and I'm going to Open. See if this will give me the same directory. It does. So under htdocs I'm going to come over here to CRUD. And I'm going to open Crud.php and you notice that the user here is Web and the password is going to be whatever password you entered for Web. And I'm going to enter my silly password.
Ctrl+S to Save, close that, close this, close this, and bring up the web browser. Now here I can type in localhost, and I'm going to type a slash and SID in all caps and another slash and sid lowercase .php and that's the path to the SID application there. In the htdocs which is where web server reads all files from. And I press Enter and there we have SID, and SID is working and we can see it's bringing up the database.
I can bring up the album database here and just type in a query, SELECT asterisk FROM track and press Go and there's all the tracks. In our track table in the album database. And I can test each of these different databases here. From the scratch database, I can use the customer table. And I get results. And from the world database, I can use the City table. There's a very long list of over 4,000 cities. You'll notice we have a little status line here.
It tells us how many rows are returned and the elapsed time. And so the SID application's working. I can drag this out onto my toolbar. And now, every time I press that, I get this SID application. And I can go ahead and. Get to the CRUD application, which is all caps CRUD/crud.php press Enter up here, there we go. There's our CRUD application. CRUD of course stands for create, read, update, delete that's the. Four basic functions of any database system.
And here we have, this is authenticating with the web user, you remember. And it's using the album database. And so if I come over here to this album, you notice there's the tracks in the album. And this application is working as well. And I can bring this down here and I can put it in my toolbar. So I've got CRUD and I've got SID, and I can get to those. From my toolbar very easily. So now that SID is installed and working you have everything you need to follow along with the exercises in this course. So, let's get started
There are currently no FAQs about MySQL Essential Training.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.