history

<?php

$user = "SYSTEM";
$pass = "12345678";
$host = "localhost/ORCL";

$conn = oci_connect($user, $pass, $host);
$sql  = oci_parse($conn, "select to_char(A.TXN_DATE,'YYYY-MM-DD HH24:MI:SS') AS ""DATE"",a.PLANT, B.SENS_TYPE ||' ' || B.DESCRIPTION as DESCRIPTION, C.DESCRIPTION AS STATUS From TKII_SEC_TXN a,
                                          TKII_MASTER_SENSOR b,
                                          TKII_TXN_CODE c
                            where a.plant = b.plant
                            and a.c_no =b.c_no
                            and a.txn_code = c.txn_code
                            AND A.TXN_DATE > SYSDATE - 3
                            AND ROWNUM < 100 ORDER BY 1 DES");

oci_execute($sql);

$rows = array();
while($r = oci_fetch_assoc($sql)) {
$rows[] = $r;
 }
$locations =(json_encode(array("result"=>$rows)));
echo $locations;
?>