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.