The MySQL Workbench GUI is cross-platform, open source, and incredibly easy to use.

Use the PHP extension for MySQL to access data from the MySQL database.

Right-click the PHP file you want to use to identify the existing table. Click "Open With" and select your PHP editor. Connect to the MySQL database. The following code connects to a database ...

To illustrate, suppose for example that you have a database called DB1 set up for a forum with a table called "posts" that includes four columns: ID, username, subject and content.