Zombie on oracle
| From: | Adi Wibowo | Date: | Thu, 01 Jan 1970 00:00:00 +0000 |
| Subject: | Zombie on oracle | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-22358@lists.php.net to get a copy of this message | ||
Hi, I use Oracle 8.1.6 on Linux with PHP4.03pl1 and Apache-1.3.14.
My problem is when every page executed, it return correct page, but with
additional one oracle child defunct.
I try the same query throgh sqlplus and return the same result but with
no oracle child defunct.
Here is my script :
<HTML>
<BODY>
<?php include "../../include/catalog/orcl_logon.php" ?>
<?php
include "/web/php4/lib/php/FastTemplate/class.FastTemplate.php";
$tpl = new FastTemplate("../../include/catalog");
$tpl->define(array(
"row" => "search_table_row.tpl",
"table" => "search_table_head.tpl"));
//query routine for selecting data
$query = "select mtbl_judul.knokat,k100a,k110a,k110b,k111a,k111c";
$query .= ",k245a,k245b,k245n";
$query .= ",k260c";
$query .= ",k099a,k099b,k099c,k099d,FCNo_Jenis ";
$query .= "from mtbl_judul,mtbl_buku where "
$query .= "mtbl_judul.knokat=mtbl_buku.knokat and ";
if ($source == "title") {
$query .= " ( ";
$query .= "k130a like '%".$keyword."%' or ";
$query .= "k245a like '%".$keyword."%' or ";
$query .= "k245b like '%".$keyword."%' or ";
$query .= "k245n like '%".$keyword."%' or ";
$query .= "k534t like '%".$keyword."%' or ";
$query .= "k490a like '%".$keyword."%' or ";
$query .= "k490v like '%".$keyword."%' ";
$query .= " ) ";
$query .= "order by k245a";}
//Getting data using query
$stmt = OCIParse($conn,$query);
OCIExecute($stmt,OCI_DEFAULT);
// ... creating table based on query result
$i = 1;
while (OCIFetch($stmt)) {
$tpl->assign("ROW_NUMBER",$i++);
$tpl->assign("AUTHOR",OCIResult($stmt,"K100A));
$tpl->assign("TITLE",OCIResult($stmt,"K245A));
$tpl->assign("YEAR",OCIResult($stmt,"K260C"));
$tpl->assign("CALL_NUMBER",$str_temp);
$tpl->parse("ROW_DATA",".row");
}
$tpl->parse("CONTENT","table");
$tpl->FastPrint();
?>
<!------ END OF ORACLE QUERY and CREATING TABLE ---------->
<?php include "../../include/catalog/orcl_logoff.php"; ?>
</BODY>
</HTML>
orcl_logon.php and orcl_logoff.php simply contain like this :
<?php
putenv("ORACLE_HOME=/db01/app/oracle/product/8.1.6");
putenv("ORACLE_SID=spektra");
putenv("TNS_ADMIN=spektra-development");
$conn = OCILogon ("<user>","<password>");
?>
<?php
OCILogoff($conn);
?>
Thank you for your help.
Adi Wibowo -------------------------------
* Work matter : adiw@peter.petra.ac.id
* Private matter : adiwibowo@excite.com
------------------------------------------