How to Use PHP for MySQL to XML. An XML file displays rows and columns you retrieve from a MySQL database. Using PHP, ... Create the MySQL connection and retrieve the information.

Next, use PHP's mysql_select_db function to choose a database on the server. Upon a successful connection, you can now use other PHP functions to query the database and display the results on your ...

From the window, select Connect to an existing database and, from the drop-down, select MySQL. Click Next and then make sure Connect using JDBC is selected (Figure B). Figure B.