<html>
<head>
<meta charset="utf-8" />
<title>jQuery_PHP_Qracle Function Editor</title>
<style type="text/css">
html, body { height: 100%; }
.TB2 { border:2px solid navy; color:green; }
.TB1 { border:2px solid green;color: navy;
vertical-align:text-top;width:300px; height:100px;}
.sp1 { width: 450px; height:100px; overflow:auto;color:navy;}
.td1 { width: 60px; height: 10px;background-color:#b0c4de;}
.td2 { width: 60px; height: 20px; font-size:12px;}
.td3 { width: 50px; height: 20px;} </style>
<script src="http://frontiersoft.net/jquery-latest.js"></script>
<script type="text/javascript" src="http://manas9/jQuery/jquery-latest.js"></script>
<script>
//Code Starts
$(document).ready(function() {
var doc2 = document.getElementById("div3");
$.ajaxSetup({ cache:false});
$("a.RR").click(function (){ location.reload();
$('input[type=textarea]').each(function() {
$(this).val('');
});
}); // reload the page
});
</script>
</head>
<body>
<!-- http://manas8x/BareBone_PHP/Oracle_StoredProc_QueryTool1.php -->
Oracle SQL-Querying-a stored function ||<br/>Using PHP Script
<br/><a class="RR" href="#">re-load()</a>||
<form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
<textarea name="sql" class="TB1" >begin:bv:=CTOF(29.25);END;</textarea><br>
<input type="submit" name="submit" value="Submit Form"><br>
</form>
<?php
$sql = "";
if(isset($_POST['submit']))
{
$sql = $_POST['sql'];
echo "Oracle sql-query <span class='sp1'> <br/>:" . $sql ."</span>";
$conn = oci_connect('hr', 'Son', 'localhost/orcl.gateway.2wire.net');
if (!$conn) {
$e = oci_error();
trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
echo" DB connected: querying a table <br/>";
}
$stmt = oci_parse($conn, $sql);
oci_bind_by_name($stmt, ":bv", $p1, 6);
$result= oci_execute($stmt);
echo"<br/> Output ..".$p1. ".. end of message<br/>";
oci_free_statement($stmt);
oci_close($conn);
echo "<br/> Oracle db connection closed";
//
}
?>
</body>
</html>
Change input values, and submit :
