In this tutorial, we will create a Simple Import XML File using PHP. This code can import the XML file to a data table when the user uploads the XML file. The code uses simplexml_load_file to load a block of data from the uploaded XML file to view it as a readable table format. This is a user-friendly kind of program feel free to modify it.
We will be using XML as a markup language that utilizes in PHP as HTML data. It is designed to store and transport data that can be manipulated within the local server.
Getting Started:
First, you have to download & install XAMPP or any local server that runs PHP scripts. Here’s the link for the XAMPP server https://www.apachefriends.org/index.html.
And, this is the link for the bootstrap that I used for the layout design https://getbootstrap.com/.
Creating The Interface
This is where we will create a simple form for our application. To create a copy of the form and write it into your text editor, then save it as index.php.
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8" name="viewport" content="width=device-width, initial-scale=1" />
<link rel="stylesheet" type="text/css" href="css/bootstrap.css"/>
</head>
<body>
<nav class="navbar navbar-default">
<div class="container-fluid">
<a class="navbar-brand" href = "https://sourcecodester.com">Sourcecodester</a>
</div>
</nav>
<div class="col-md-3"></div>
<div class="col-md-6 well">
<h3 class="text-primary">PHP - Simple Import XML File</h3>
<hr style="border-top:1px dotted #000;" />
<div class="col-md-4">
<form method="POST" action="" enctype="multipart/form-data">
<h5>Upload XML here</h5>
<input type="file" name="file"/>
<br />
<center><button name="import" class="btn btn-primary">Import</button></center>
</form>
</div>
<div class="col-md-8">
<?php include'import.php'?>
</div>
</div>
</body>
</html>Creating the Main Function
This code contains the main function of the application. This code will upload and display a xml data when the button is clicked. To make this just copy and write these block of codes below inside the text editor, then save it as import.php.
<?php
if(ISSET($_POST['import'])){
$file_name=$_FILES['file']['name'];
$exp=explode('.', $file_name);
$name=end($exp);
if($name=="xml"){
?>
<table class="table table-bordered" >
<thead class="alert-info">
<tr>
<th>Firstname</th>
<th>Lastname</th>
<th>Address</th>
</tr>
</thead>
<tbody>
<?php
$xml = simplexml_load_file(''.$file_name);
foreach($xml->member as $member){
echo '
<tr>
<td>'.$member->firstname.'</td>
<td>'.$member->lastname.'</td>
<td>'.$member->address.'</td>
</tr>
';
}
?>
</tbody>
</table>
<?php
}else{
echo"<script>alert('Please upload xml file only')</script>";
}
}else{
?>
<table class="table table-bordered" >
<thead class="alert-info">
<tr>
<th>Firstname</th>
<th>Lastname</th>
<th>Address</th>
</tr>
</thead>
<tbody>
<td></td>
<td></td>
<td></td>
</tbody>
</table>
<?php
}
?>There you have it we successfully created Simple Import XML File using PHP. I hope that this simple tutorial help you to what you are looking for. For more updates and tutorials just kindly visit this site. Enjoy Coding!
