PHP XML Data Provider

This is a very simple data provider for the cascading dropdown example. A *real* data provider would most likely connect to a database, use xslt and implement some level of security.

<?php



    // This is a very simple data provider for the cascading dropdown

    // example. A *real* data provider would most likely connect to

    // a database, use xslt and implement some level of security.



    Header("Content-type: text/xml"); 

    // get query string params

    $filter = $_GET['filter'];

    $xml = '';

    $iscountry = 1;

    // build xml content for client JavaScript





    include 'dbcon.php';



    mysql_select_db($database, $conn);

    $query  = "SELECT * from subcategory where cat_id = '$filter'";

    $result = mysql_query($query);

    while($row = mysql_fetch_assoc($result))

    { 

        if ($iscountry == 1)

        {

        $xml = $xml . '<continent name="' . $row['category'] . '">';

        }

        

        $xml = $xml . '<country id="' . $iscountry . '">' . $row['subcategory'] . '</country>';

        $iscountry = $iscountry + 1;

    }    

    $xml = $xml . '</continent>';

    

    if ($iscountry == 1)

    {

        $xml = $xml . '<continent name="none">';

        $xml = $xml . '<country id="0">no countries found</country>';

        $xml = $xml . '</continent>';

    }



    // send xml to client

    echo( $xml );

?>