oci_var_dump1
Objective:
  • oci_bind_by_name()
    As the name stands for, this function allow a php-variable to  bind a column-name retrieved with a SQL statement.
    oci_define_by_name($stmt, 'ENAME', $ename);
     
  • PHP var_dump(parameter 1_ n): The prints data and value from an array.
SCOTT.EMP table

Script:

<?php
echo "Example OCI_FETCH ..OCI_define_var_dump1.php <br/>";
$sql = "select empno, ename from emp WHERE rownum <=6";
$conn = oci_connect('scott', '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_define_by_name($stmt, 'ENAME', $ename);
oci_define_by_name($stmt, 'EMPNO', $empno);
oci_execute($stmt);
//
while ($row = oci_fetch($stmt)) {
var_dump($empno, $ename,"<br/>");
}
//
echo " no of rows : ". oci_num_rows($stmt);
oci_free_statement($stmt);
oci_close($conn);
echo "<br/> Oracle db conection closed";
//
?>
 

display: