PHP and MySQL Basic Overview

[Audrey]

This will be a very basic overview for working with PHP and MySQL together.

What are PHP and MySQL?

PHP and MySQL are two coding languages very different from one another. However, when used together, they can create dynamic web pages.

What can I do with PHP and MySQL?

When PHP and MySQL are used together, you can create some of the most popular web aspirations. Here are a few of them:

• Online Catalogues
  
• User Accounts
  
• User Login/Register Pages
  

[Audrey]

What is PHP?

PHP is a popular coding language. It is flexible, easy to use, and happens to work well with MySQL. PHP can be embedded into HTML files which makes it even easier to use. Once PHP is learned, you can use it just like any other coding language. It allows for an easy-to-create interactive web pages.

What is MySQL?

MySQL is the coding language designed specifically for databases. It tells the database what to do using "queries". Queries can move, add, delete, etc. information.

Working Together

PHP and MySQL are both free, easy to use, and work well together. Once a database connection has been created, MySQL can tell the database what to do. PHP allows you to do this in an interactive way.

[Audrey]

For Example . . .

You can write a form in PHP to collect a name. With MySQL working with the PHP, the information can be submitted into the appropriate database and table.

[Audrey]

Databases

Databases are controlled by MySQL. But what is a database? Databases store information. They can't do anything else. PHP and MySQL together can retrieve and use the information. They are organized into tables and cells to make them well organized and easy to navigate.

All in all, when used together, PHP and MySQL can make a very useful coding tool.

[Amxs]

OOH! I think you use MySQL in cutenews, well, first idea that came into my head because that has accounts and a database and things! Oh, and alot of coding! xD

[Audrey]

Yep, Cutenews is a PHP script. It stores users, passwords, e-mails, and of course, the news. That's a perfect example.

[Amy]

So...Confused!