How to Use PHP for MySQL to XML. An XML file displays rows and columns you retrieve from a MySQL database. Using PHP, you can export data from a database table to a Web form.

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