Generating xml file by reading data from MySQL table in PHP

We will collect the each records by using Mysql query and PDO. We will store all our output in string and then we can write to a file with .xml extension or print to webpage by using htmlspecialchars() function. You can read more on PHP & XML here.

Demo of the output in XML format

Here is the code.

<?Php
require "config1.php"; // Connect to database

//////////////////////////////////////
$sql="select *  from student"; 
$str ="<?xml version="1.0" encoding="UTF-8"?>n<student>";

foreach ($dbo->query($sql) as $row) {
$str .= "\n<details>\n\t\t\t<id>$row[id]</id>\n\t\t\t<name>$row[name]</name> ";

$str .= "\n\t\t\t  <class>$row[class]</class>\n</details>";
}
$str.= "\n</student>";
//$str=nl2br($str);
//echo htmlspecialchars($str); // remove this line if you are writing to file
echo $str;
/////////////////////////////  
/// Write to file ////////////
/*
$file_name="test_file.xml";               // file name
$fp = fopen ($file_name, "w");  
// Open the file in write mode, if file does not exist then it will be created.
fwrite ($fp,$str);          // entering data to the file
fclose ($fp);                                // closing the file pointer
chmod($file_name,0777);  
*/
?>

Using MySQLi database connection and SimpleXMLElement to addChild()

<?Php
header('Content-Type: text/xml');
require "config.php"; // database connection file

$e = new SimpleXMLElement('<detils/>');
if($stmt = $connection->query("SELECT id, name ,class, mark FROM student")){

while ($row = $stmt->fetch_assoc()) {
	//echo $row['id'],$row['name'],$row['class'].$row['mark']."<br>";
	$add=$e->addChild('student');
	$add=$e->addChild('id', $row[id]);
	$add=$e->addChild('name', $row[name]);
	$add=$e->addChild('class',$row['class']);
	$add=$e->addChild('mark', $row[mark]);
}
}else{
echo $connection->error;
}
echo $e->asXML(); 
?>

Read more on displaying records
Download the student table here

Subscribe to our YouTube Channel here

Xml file from database

Subscribe