<?php

$dbuser="***********";
$dbpass="***********";

$dbsid = "(
  DESCRIPTION =
  (ADDRESS_LIST =
   (ADDRESS =
    (PROTOCOL = TCP)
    (HOST = localhost)
    (PORT = 1541)
   )
  )

  (CONNECT_DATA =
   (SERVER = DEDICATED)
   (SERVICE_NAME = orcl)
  )
) ";

//DB connect info
$conn = @oci_connect($dbuser,$dbpass,$dbsid);

///////////query//////////////////////
$query = 'select * from toilet_info';
/////////////////////////////////////

//////////////statement////////////////////////////////////////////////
$stmt = oci_parse($conn, $querry);
oci_execute($stmt);
////////////////////////////////////////////////////////////////////
$dom = new DOMDocument('1.0','UTF-8');
/////////////XML element//////////////////////////
$root = $dom->createElement('toilet_info', '');
$dom->appendChild($root);

while($row = oci_fetch_array($stmt)){
                $emp = $dom->createElement('test','');
                $emp = $root->appendChild($emp);

                $toilet_info_id = $dom->createElement('toilet_info_id', $row['TOILET_INFO_ID']);
                $toilet_info_id = $emp->appendChild($toilet_info_id);

                $toilet_name = $dom->createElement('toilet_name', $row['TOILET_NAME']);
                $toilet_name = $emp->appendChild($toilet_name);
$toilet_x = $dom->createElement('toilet_x', $row['TOILET_X']);
                $toilet_x = $emp->appendChild($toilet_x);

                $toilet_y = $dom->createElement('toilet_y', $row['TOILET_Y']);
                $toilet_y = $dom->appendChild($toilet_y);

                $toilet_handicap = $dom->createElement('toilet_handicp', $row['TOILET_HANDICAP']);
                $toilet_handicap = $dom->appendChild($toilet_handicap);

                $toilet_bidet = $dom->createElement('toilet_bidet', $row['TOILET_BIDET']);
                $toilet_bidet = $dom->appendChild($toilet_bidet);

                $toilet_machine = $dom->createElement('toilet_machine', $row['TOILET_MACHINE']);
                $toilet_machine = $dom->appendChild($toilet_bidet);

                $toilet_alarm = $dom->createElement('toilet_alarm', $row['TOILET_ALARM']);
                $toilet_alarm = $dom->appendChild($toilet_alarm);

                $toilet_updated = $dom->createElement('toilet_updated', $row['TOILET_UPDATED']);
                $toilet_updated = $dom->appendChild($toilet_updated);
}
        print $dom->saveXML();
//disconnect oracle
oci_free_statement($stmt);
//logout oracle
oci_close($conn);

?>

<?xml version="1.0" encoding="UTF-8"?>
<toilet_info/>