PHPuss

<?php $db_conn = ocilogon("root", "admin", "//localhost/xe"); $cmdstr1 = "SELECT *FROM TESTS WHERE TEST_TIME BETWEEN TO_DATE('2012-01-01','YYYY-MM-DD') AND TO_DATE('2012-02-02','YYYY-MM-DD')+1 and SYSTEM_NAME like '%SYSTEM_1%' "; $cmdstr2 = "SELECT *FROM TESTS WHERE TEST_TIME BETWEEN TO_DATE('2012-01-01','YYYY-MM-DD') AND TO_DATE('2012-02-02','YYYY-MM-DD')+1 and SYSTEM_NAME like '%SYSTEM_1%' and RESULT='0'"; $parsed1 = ociparse($db_conn, $cmdstr1); $parsed2 = ociparse($db_conn, $cmdstr2); ociexecute($parsed1); ociexecute($parsed2); $nrows1 …

I have code , and I need to change color row when in last column 'status' appears value = 'error' <?php //first, get the file... $file = file('log.txt'); //now count the lines .. $lines = count($file); //start the table here.. echo '</br>'; echo'<table border="1" width="600">'; echo ' <td width="400">Date</td>'; echo …

Oracle : 11.2.0.1.0 Apache 2.0 Handler PHP Version 4.4.9 Windows XP I have problem to connect with Oracle 11g. Log apache : PHP Warning: Unknown(): Unable to load dynamic library 'C:\\Program Files\\Apache Group\\Apache2\\php\\extensions\\php_oracle.dll' - The specified module could not be found.\r\n in Unknown on li when I open phpinfo : …

I have calendar in php and two veriable : date3 , data4 When i run a statement <input type="button" name="button2" id="button2" value="Date" onClick="javascript:alert('from date : '+this.form.date3.value+' ,to date: :'+this.form.date4.value);"> I have in response two dates I need to use this dates in query to oracle to filtr result from db. …

$stmt=OCIParse($conn,'SELECT *FROM USERS where USER_NAME = "USER_1"); when I want to execute this stmt , I have problem with "32" , error: OCIStmtExecute: ORA-00904: "32": invalid identifier maybe somebody know how to replace "" to validate character apache 4 oracle 11

When I run this script , I have a error : Warning: Invalid argument supplied for foreach() in C:\Apache\test.php on line 28 <?php $conn =OCILogon("xxxx", "yyyy", "localhost/xe"); $query = 'SELECT *FROM TEST'; $stid = OCIParse($conn, $query); print '</br>'; $stmt=OCIParse($conn,'SELECT *FROM TEST'); $ret=OCIExecute($stmt); $nrows=OCIFetch($stmt,$results); if ($nrows>0) { echo "<table border='1' align='left' …

I have two problems... Here is code : <?php // Create connection to Oracle $conn = oci_connect("root", "admin", "//127.0.0.1/xe"); $query = 'select * from TEST_RESULTS'; $stid = oci_parse($conn, $query); $r = oci_execute($stid); print '</br>'; // Fetch each row in an associative array print '<b> MONITORING SRODOWISK TESTOWYCH </br>'; print '</br>'; …