Subtitles of the Movie

In this tutorial we're going to be setting up our system in order to prepare it for the video tutorial projects. Now, as I mentioned before, we will need a server installed on our computers so that we can work with AJAX. Now, I'm going to go ahead here and jump over to wampserver.com /en. Now, Wamp Server is a single installation that installs an Apache server, PHP and MySQL on onto your Windows-based system. That's really the reason why I'm using this is because it's so simple to use as a testing environment. So I'm going to go ahead and click on downloads and it's going to allow me to come in here and install our Wamp Server. I'll just download and it takes me through the downloading process. I'll go ahead and save the file. Now, while we're waiting for that to download, I'll go ahead and jump back over here to our file system. Now, I've already taken the exercise files that are available to you through this tutorial series and I've extracted it out to My Documents into a folder called JSL for JavaScript Libraries. So what you see here is you've got a start folder for each of the projects we're going to be building and then a finish folder for each of the projects we're going to be working on. In addition to that, there is a SQL file here which will allow us to set up our database whenever we get our server installed. And it looked like I did receive a notification that the file had been downloaded appropriately so I'll jump over to my downloads here. I believe it's downloaded to my Desktop and there it is. Go ahead and run that and it's going to step you through the installation process. I'll just Next through this and accept and take the default installation and I install. It's going to extract out the files. It's going to allow me to host my own web pages, run PHP scripts and work with that MySQL database. I'm going to go ahead and take this moment while it's installing to talk a little bit about those exercise files that we were taking a look at just a second ago. So I'll go back to My Documents where I extracted it out to the JSL folder. Now, due to copyright restriction on some of the images that I have created, I've chosen not to include them in your exercise files. So if you're wanting to work with images, you may have to modify some of the references to the images both in the JSON documents and the MySQL database. So let's jump over and take a look and see if our server is done installing yet. And of course there's also some other applications out there that do the same thing as Wamp. If you are familiar with server configurations, feel free to use whichever servers you want and as I said before, if you know other server technologies, such as ASP, maybe some JSP, feel free to use those as well but you're going to have to build your own server-side pages. So another side note about this. The Wamp Server is also available for Mac and it's not actually Wamp Server for Mac. It's just called Mamp and it's maintained by a different source. So here it's asking me if I want to use Firefox as my default browser. I'll go ahead and say yes. And it's going to finish up installation. Then it's asking me to set up the SMTP server if I'm going to be doing things with the mail function inside of PHP. I don't have an SMTP server set up but I'm going to go ahead and leave the defaults here for future use if I do get that SMTP server set up. And it's going to ask me to launch and I'll go ahead and finish it up. And I'll know that my Wamp Server is running because in the test tray I'll see this Wamp Server icon. I'm able to go in to configure things by clicking on that and it's going to give me access to the Apache files, the PHP files, the MySQL files. Also something else that may help is to know that there's this Put Online down here and if you click on that Put Online, it makes it so that your servers are going to be accessible. Sometimes this is what you're going to need to do if you're running into problems with your AJAX files being served up. So what I want to do now is I want to install my database files so I'm going to go to the Wamp icon and click on it and then go to PHP My Admin. And PHP My Admin is just a way that you can work with your MySQL databases using a PHP front end. By default, it does have a couple of databases set up here. Now that I'm in PHP My Admin, I need to create my database. So creating a database here. We'll call this VTC underscore JS and I'll go ahead and hit create. So it's going to create my database and now I need to import in my database file. So I'll do Import and I'll browse to the JSL file and then inside of the JSL folder I will select the VTC underscore JS.sql. I'll open. I'll take all the defaults and I'll click Go and it goes to work and it imports in all of my different tables. So what I'll see here over to the left-hand side I have eight different tables that are used throughout our different video tutorials. And I'll just get this, say Blog Entries so we can take a look at what's going on in there and as you can see, we have a lot of pre-populated data, most of which is just nonsense and just placeholder. With the Wamp Server in place, our database files imported and our exercise files set up appropriately, we're going to be ready to start working with these files for our projects and our system is now ready.