Other Applications 31

O

THER 

A

PPLICATIONS

MySQL is most often used with other applications to display data. For displaying data on

the web, Dreamweaver, PHP, and Perl are probably the most common methods used, and

Python is also useful.

The  PHP,  Python,  and  Perl  examples  assume  that  you  already  know  how  to  use  those

programming languages.

Dreamweaver

Dreamweaver makes it fairly easy to make simple web pages using MySQL and PHP. The

screenshots on this page are from Dreamweaver MX 2004.

Create Select Statement

The first thing you need to do is tell Dreamweaver that your site is a dynamic site using

PHP/MySQL server technology.

Then, you'll need to tell it where you want your  test server  to be. Normally, you'll edit

locally, then upload to a remote testing server (as I've shown below). In this case, however,

we'll want to edit and test locally. We set up our database on  this computer .