How to nesting function?

[Anon]

The blow code will show error:
function connect()
{
putenv("ORACLE_SID=ORCL");
putenv("ORACLE_HOME=/opt/app/oracle/product/8.0.5");
$conn = ocilogon("wz","wzforedu");
return $conn;
}

function select()
{
connect();
$sql="select * from module ";
$stmt = OCIParse($conn,$sql);
ociexecute($stmt);
OCIFreeStatement($stmt);
OCILogoff($conn);
return 1;
}

if I assembled the two function as below,It will work.
function select()
{

    putenv("ORACLE_SID=ORCL");
    putenv("ORACLE_HOME=/opt/app/oracle/product/8.0.5");
$conn = ocilogon("wz","wzforedu");
$sql="select * from  module ";
$stmt = OCIParse($conn,$sql);
ociexecute($stmt);
OCIFreeStatement($stmt);
OCILogoff($conn);
return 1;

}

why?

[Anon]

Change your select() like this:
function select()
{
$conn=connect(); //this line
$sql="select * from module ";
$stmt = OCIParse($conn,$sql);
ociexecute($stmt);
OCIFreeStatement($stmt);
OCILogoff($conn);
return 1;
}

[Anon]

Just to explain Hunte's fix: as this is written, $conn is a variable only visible inside the function. When you return it, it's still not "visible" to the select() function, unless you check the return value of connect().

Another way of handling this would be to leave your code as is except change "return $conn;" to "global $conn;", and add "global $conn;" to the select() function. But that would be bad program design =)

HTH

AC