File Manager

Editing File: /home/cienp/public_html/portal/xml/xml_locl.php

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

$s_nu_nivl = $_POST[nivl];
    settype($s_nu_nivl, 'integer');
    $s_nu_nivl--;

$sql  = "SELECT id_locl, de_locl ";
    $sql .= "FROM ".$pref_tabl."almx_locl ";
    $sql .= "WHERE fl_atvo = 'S' ";
    $sql .= "AND nu_nivl = '$s_nu_nivl' ";
    $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;            
?>

Back to Directory File Manager