persisten connection

[m_vito]

hi, why my scripts don't works? I have two pages, my persistent connection closes.

START.php
<?php
Putenv("ORACLE_HOME=xxxx");
$connection = OCIpLogon ("xxx","xxx","xxx");
if ($connection == false){
echo OCIError($connection)."<BR>";
exit;
}

echo "<a href='vis.php'>annulla</a><br>";
?>

VIS.php
<?php
$query = "select * from prova_info";
$cursor = OCIParse ($connection, $query);
if ($cursor == false){
echo OCIError($cursor)."<BR>";
exit;
}

$result = OCIExecute ($cursor);
if ($result == false){
echo OCIError($cursor)."<BR>";
exit;
}

echo "<table border=1>";
echo "<tr><td><b>Full Name</b></td><td> <b>Email Address</b></td></tr>";

while (OCIFetchInto ($cursor, $values)){
$name = $values[0];
$email = $values[1];

echo "<tr><td>$name</td><td>$email</td></tr>";
}

echo "</table>";
echo "<p> $connection </p>";
echo "<a href='sel.php'>dietro</a>";
?>

Tanks a lot.
Vito

[[deleted]]

The connection does not close, but you do not tell php which connection to use.

You MUST ALWAYS use the OCILogon etc functions to create a database connection,
even id you are using persistant connections.

The connection is kept alive between PHP and the server, NOT in your script.

PS: persistant connections are useless, do not use them unless you have severe performance issues.

---

A forum, a FAQ, email notification, what else do you need?

Time to YAPF!: http://www.yapf.net/