PHP - Simple Import XML File

Submitted by razormist on Friday, July 12, 2019 - 18:15.

In this tutorial we will create a Simple Import XML File using PHP. This code can import XML file to a data table when user upload the xml file. The code use simplexml_load_file to load a block of data from the uploaded xml file in order to view 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 utilize in php as a 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 run PHP scripts. Here's the link for 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 the forms simply copy 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!

Add new comment

585 views