How to connect oracle with php

[skbeacon]

Hello everyone,

I need to know whether it is posible to make any connection between oracle and php? If so can anyone provide me the code or whatever needed to to my task? That would be very helpful for me.

Thank you ALL

[boss1]

hei, u can try this code:

If you are using php to simply connect and select data would require this.

Code: ( php )

 
<?php
 
  $conn = oci_connect('username', 'password', 'database');
  if (!$conn) {
    $e = oci_error();
    echo htmlentities($e['message']);
    exit;
  }
 
  $query = 'SELECT * FROM DEPARTMENTS';
 
  $stid = oci_parse($conn, $query);
  if (!$stid) {
    $e = oci_error($conn);
    print htmlentities($e['message']);
    exit;
  }
 
  $r = oci_execute($stid, OCI_DEFAULT);
  if (!$r) {
    $e = oci_error($stid);
    echo htmlentities($e['message']);
    exit;
  }
  print '<table border="1">';
  while ($row = oci_fetch_array($stid, OCI_RETURN_NULLS)) {
    print '<tr>';
       foreach ($row as $item) {
         print '<td>'.($item?htmlentities($item):'&nbsp;').'</td>';
       }
       print '</tr>';
  }
  print '</table>';
  oci_close($conn);
?>
 
 

[amitpatel66]

Boss1,

Pleaes make use of [code] tags everytime you post source code in this forum

Thanks
MODERATOR