Viewing File: /home/cienp/public_html/portal/xml/xml_locl_pais.php

<?
    require "../includes/conecta.php";

    $s_id_locl = $_POST[locl];
    settype($s_id_locl, 'integer');

    $sql  = "SELECT id_locl, de_locl ";
    $sql .= "FROM ".$pref_tabl."almx_locl ";
    $sql .= "WHERE fl_atvo = 'S' ";
    $sql .= "AND id_locl_pais = '$s_id_locl' ";
    $sql .= "ORDER BY de_locl ";
    #echo $sql;
    $res  = mysqli_query($conn, $sql);
    if (mysqli_num_rows($res) > 0) {

        $xml  = "<?xml version=\"1.0\" encoding=\"ISO-8859-1\"?>\n";
        $xml .= "<locais>\n";               

        while ($linha = mysqli_fetch_array($res)) {  
            $xml .= "<local>\n";     
            $xml .= "<codigo><![CDATA[".$linha[id_locl]."]]></codigo>\n";                  
            $xml .= "<descricao><![CDATA[".$linha[de_locl]."]]></descricao>\n";         
            $xml .= "</local>\n";    
        }            

        $xml.= "</locais>\n";

        Header("Content-type: application/xml; charset=iso-8859-1"); 

    } 

    echo $xml;            
?>