Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
We are now going to install the course files for this course. We are also going to install the data base and get that set up. And it sounds really scary, some of this stuff, actually trying to do it, but it's a very simple process, as long as you know where the folders are located to do the things you need to do. So lets start with the course files. Now on the PC Side on the C Drive, Zamp has installed a single folder.
On the Mac side, this Mamp folder, which would replace Zamp, is located within your Applications folder. So on the Mac side, you're going to go out to the Applications folder, and look for a folder called Mamp. On the PC side, we go to the C drive, and look for a folder called Zamp. I'll open up Zamp, and, the folder we're looking for within either one of these, is the same name. So what you want, is the HT Docs folder, and that's where the website files are stored, and it's the same folder, in Mamp or in Zamp. So it makes it fairly simple.
If I Open up this folder, Inside this folder within ZAMP, there are some files installed as you can see. Now on the MAMP side, you may or may not have some files installed. But what we are going to do is take our Scuba2U folder, so you want to go out to the lesson 2 start files, for this course, and we're going to Copy those and Paste them into this folder. Our website is now ready to go. It's as easy as that to move our files into the web server. As long as you find that HT docs folder, you just Copy and Paste your website into that area.
Now on the MAMP side, it's exactly the same. Within the HT docs folder within MAMP, Paste scuba2you and that is our website files. So that is the lesson 2, course files, Start. And you want to Paste them into this area, it should be a folder called Scuba To You. Now that takes care of pulling in our website files. Now we need to setup the database piece, and that as simple as well. Now whether you're on Mamp or Zamp, just make sure both Apache and MySQL are running.
We are going to go out to the Admin area for MySQL. And within this Admin area, we're immediately taken to the Home area, and the Home area should say, Create New Database. You can always get to that by Clicking this Home button as well. Now within this area, we need to Create a New Database, and it will be empty and then we're going to import this SQL file and our database will be created for us. So we're going to name this new database the same name as the SQL file, Scuba2U.
So, we'll Create a Scuba2U Website. This will be the database for it. So click Create. Once it's created, you're moved into that database. In between the parenthesis, this is telling you how many tables exist in the database. We don't have any right now. We just have a blank database. But when we're done, we will. I'm going to go over to the Import tab, and within the Import Tab, there is this file to import.
And I simply have to locate this SQL file using the browse button. And I have it on my Desktop to make it easy to find. So, here is my Scuba2u.SQL file. I'll plug that in, as soon as I have that file located, and I'll just double check, make sure I have the right one. Then I go down here in the bottom right, and Click the Go button. This file has everything in it to create all of the tables and populate the tables with the database information that we need for this course.
So, I will Click Go. You can see, there's a whopping one table right now inside our website, and that is the login table. Now if I Click on that in this list, you'll see we have four people inside our database, and this is our Login database. So this is going to allow people to Login. You can see some are admin roll and some are guest roll. Our guest users will not be able to access the administrative area, and the administrative interface. Our admin users will be able to do so.
So that is installing our database and the database table information. So we're all set in terms of setting up our course files. Now what we need to do is go into Dreamweaver, setup our files so Dreamweaver knows where our website files are stored. And we also need to tell Dreamweaver that we're using a testing server, and which Server Side language we will be using. So, we will move to the Dreamweaver piece, Moving Forward, so we can get that setup.
Once we complete the Dreamweaver side, we are all set to go in our testing environment.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 98266 Viewers
61 Video lessons · 85559 Viewers
71 Video lessons · 69522 Viewers
56 Video lessons · 101854 Viewers
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.
Your file was successfully uploaded.