| Subject: |
Export mysql database table data to xml file |
| Level: |
Intermediate |
| Code Lines: |
31 |
| Requirements: |
PHP web server, MySQL server, text editor, write access to folder XML file will be stored |
<?php // www.chriswashington.net/tutor
// STORE DATABASE VARIABLES
$hostname_cnConnection = "website.com";
$database_cnConnection = "databasename";
$username_cnConnection = "username";
$password_cnConnection = "password";
$cnConnection = mysql_pconnect($hostname_cnConnection, $username_cnConnection, $password_cnConnection);
// CONNECT TO DATABASE
mysql_select_db($database_cnConnection, $cnConnection);
$query_rsRecordset = "SELECT * FROM tablename";
$rsRecordset = mysql_query($query_rsRecordset, $cnConnection) or die(mysql_error());
$row_rsRecordset = mysql_fetch_assoc($rsRecordset);
$totalRows_rsRecordset = mysql_num_rows($rsRecordset);
// START STORING DATA IN VARIABLE TO PLACE IN XML FILE
if($totalRows_rsRecordset > 0) {
$strXML = "<?xml version=\"1.0\"?>\n";
// STORE NAME OF TABLE
$strXML = $strXML . "<tablename>\n";
// STORE FIELD AND FIELD DATA IN ONE HIARCHY, REPEAT FOR MULTIPLE FIELDS
$strXML = $strXML . " <fieldname title=\"PrimaryID\">\n";
do {
$strXML = $strXML . " <id>" . $row_rsRecordset['fieldname'] . "</id>\n";
} while ($row_rsRecordset = mysql_fetch_assoc($rsRecordset)); $strXML = $strXML . "</tablename>";
$strXML = $strXML . " </fieldname>\n";
// OPEN FILE, WRITE TO FILE, CLOSE FILE, CLOSE RECORDSET
$XMLFile = fopen("myxmlfile.xml", "w");
fwrite($XMLFile, $strXML);
fclose($XMLFile);
}
mysql_free_result($rsRecordset);
?>
