<html><head>
<title>:: arul's PHP script to update data from a table stored in oracle :: arul john ::</title>
</head>
<body>
<h2>updated contents of the table</h2>
<?
$username = "myName";
$password = "myPassword";
if (!($conn = ora_logon($username, $password))) {
echo "failed!!";
exit;
}
$cursor = ora_open($conn);
$name = "wolf";
$oldLanguage = "perl";
$newLanguage = "jsp";
$query = "update person set language = '$newLanguage' where name = '$name' and language = '$oldLanguage'";
$result = ora_parse($cursor, $query);
$result = ora_exec($cursor);
if ($result > 0) {
echo "<b>updated table with query</b><br> $query";
}
ora_commit($conn);
ora_close($cursor);
ora_logoff($conn);
?>
</table>
</body>
</html>
syntax highlighted by Code2HTML, v. 0.9.1