Home Logo
Show Full Menu
Hide Full Menu
 

Welcome to MySQL

Created: 12/10/10 Views: 2122 myFave Image


In this introduction we will learn what MySQL is and how we are going to use it
MySQL is a database that you can access on the internet, it allows you to store data into tables and then retrieve them. MySQL is in fact a very complicated system, however luckily the smart guys who created it made it extremely easy to use. I will not go into the glory details as I don't want to bore you, but if you are planning on creating a interactive or adjustable website, then MySQL is going to be a must in your scripting vocabulary. We will be using PHP to control MySQL.

To begin with I want to just list a few examples of its use
  • Store user information
  • Create a log in area
  • Hold products
  • Hold web pages and it's content
  • Create a posting wall
  • Save data from a form
  • etc etc etc


Ok, so that's the little introduction over with, there is just a couple of important things we need to go over before we move on.

Firstly you need to know PHP very well. Secondly the important thing is to have PHP and MySQL installed on your server, if it's not installed it's not going to work. Unlike HTML where it works via the browser reading the script and displaying it, PHP requires the web server to make all of its tasks work and MySQL requires the whole MySQL system to be installed.

So if you're not sure if you have PHP and MySQL installed or how to, you'll need to do either of these,

1. Get yourself a domain name and hosting, either a free version or a priced one, I would personally recommend purchasing a domain name and hosting account as free hosts do tend to be very limiting, if you aren't sure where to start with getting such things I would recommend 123-Reg for the domain name and JSHosts for the web hosting, they are very reliable, very cheap and very helpful, I've certainly never had anything bad to say, and with them if you choose the basic cheap hosting, it will do far more than you'll need it to!
Note: You may have to wait around 24 hours for your account to be 100% active.

2. Get a local server set up, and for this I personally only recommend one program for the job, and that's Xammp, it's free and reasonably simply to set up and will do everything you need it to.
Note: For any confusion on set up, follow the tutorial on this in the Misc tutorial Subject.

Now, if you've got PHP and MySQL set up, you may now carry on with the rest of the tutorials. I recommend that you go through these tutorials in order so you do not get lost


next tutorial: PHPMyAdmin

There are no comments