Nowadays you hardly ever hear PHP
mentioned without MySQL close behind. Why? Well, PHP and MySQL make a great
pair for web application development efforts. MySQL is often used in
conjunction with PHP for the same reasons PHP is so popular - it is free,
widely available, and most web hosts have it installed. There are other
database systems that PHP works with, but MySQL seems to be the most common.
In this section,
I’ll familiarize you with using MySQL to connect to a MySQL database and
perform the basics. Advanced MySQL and it’s SQL language is a little beyond the
scope of this book, so we won’t dive very far in to heavy details (I don’t want
to lose you!). However, MySQL’s commands are written in almost-plain-english,
and you can usually figure it out just by looking at it.
Most other
PHP/MySQL books also tell you how to install MySQL and configure it. We’re not
going to do that here. Your web host most likely has MySQL available for you,
and they have simple ways to create databases. The two hosts that I have been
using for years are pair Networks and Hostgator. Hostgator uses CPanel, and
pair Networks uses a custom built control panel - both make it very easy to set
up a database, and they provide the information you need to connect to it with.
No comments:
Post a Comment