How to parse XML in order to extract data from MySQL Database.

Question

Hello

Here is a simple form to send to admin_xml.php

<form name="review" action="admin_xml.php" method="post">
<textarea name="xml" cols="40" rows="10"></textarea>
<input class="submit" type="submit" value="Submit Request">
</form>

---

Here is the XML which I want to enter into the form to extract Data from MySQL Database.

<?xml version="1.0" encoding="UTF-8"?>
<GetOrdersIds>
    <Credentials>
        <Username>my_username</Username>
        <Password>my_password</Password>
    </Credentials>
    <Criterions>
        <OrderNumber></OrderNumber>
        <CustomerName></CustomerName>
        <StartDate></StartDate>
        <EndDate></EndDate>
        <OrderStatus></OrderStatus>
    </Criterions>
</GetOrdersIds>

---

What I want to achieve is when I enter the above XML data in the HTML form, it should go through my Database and match the tags in my database and extract that data and retrieve it back.

How to create a new request and add changes in admin_xml.php (parse xml request, check up, and then extract data from the database).

I would like to automate it, create certain fields which would be selectable. In this way, i can select which tags(data) from the database.

Can some suggest a tutorial or a book on such issue ?

Answer 1

Check out this tutorial. You can handle pretty much any XML file with the stuff there.