OCI functions in include file?

[Anon]

I have an Oracle backed website. To avoid doing repeated db connections, I'm trying to put the database commands as functions in an include file and return the connection resource to the main pages for display. The resource is not getting returned.

test-include.php:
define('DB_USER', 'scott');
define('DB_PASS', 'tiger');
define('DB_NAME', 'mydb');

$conn = OCILogon(DB_USER, DB_PASS, DB_NAME);

function db_query($conn,$query)
{
$stmt = OCIParse($conn,$query);
OCIExecute($stmt);
return $stmt;
}

A main page:

<?php
include "./test-include.php";
$query = "select item_id, short_desc from products order by item_id";
db_query($conn,$query);
while (OCIFetchInto($stmt,$row))
{
$id = $row[0];
$desc = $row[1];
echo $id;
echo $desc;
}

?>

This returns the error
Supplied argument is not a valid OCI8-Statement resource
at the 'while...' line, which I'm guessing means that there's no value for $stmt.

Any ideas?

Thanks,
Sheila

[khaine]

I think your problem is that the variable doesnt exist outside of the function as an OCI resource. I use a simular system but I dont use a function. the include file I use is

<?php

$conn = OCILogon("scott", "tiger", "testdb");

$stmt = OCIParse($conn,$query);
OCIExecute($stmt);

?>

Then I use it in a program like so.

<?php

$query="select * from testtable";

include("oci.inc");

etc etc
?>

This method works fine the data returns and I store the oci.inc file outside of the document root so noone can find it and gain a logon to the database.

Mark.

[Anon]

That did it, Mark, thanks!

(Although looking at both my solution and yours, I'm still making repeated db connections. I wonder if there's any way to make a 'session connection', once per session, and pass it around? More to play with...)

Sheila

[khaine]

You might be able to do something like that with persistant connections. But I have never realy dabled with them so I cant say for sure.

Mark.