<html> 
 <head> 
  <title>My Shop</title> 
 <head> 

 <body> 
  <h1>Welcome to my shop</h1> 
 <br> 
  In my shop you can buy: 
  <ul> 
   <?php 
     // Create connection to Oracle 
     $conn = oci_connect("shop", "welcome1", "//oradb_database_1/mypdb"); 

     if (!$conn) { 
        echo "shop/welcome1//oradb_database_1/MYPDB"; 
        $m = oci_error(); 
        echo $m['message'], "\n"; 
        exit; 
     } 
     else { 
      //  print "Connected to Oracle!"; 
        $query = 'select * from shop.products'; 
        $stid = oci_parse($conn, $query); 
        $r = oci_execute($stid); 

        print '<table border="1">'; 
          print '<tr>'; 
          print '<td><b>Name</b></td>'; 
          print '<td><b>Description</b></td>'; 
          print '<td><b>Link</b></td>'; 
          print '</tr>'; 
        while (($row = oci_fetch_array($stid, OCI_BOTH )) != false) { 
          print '<tr><td>'; 
          echo $row[1]; 
          print '</td><td>';
          echo $row[2]; 
          print '</td><td>'; 
          echo '<a href="'.$row[3].'">'.$row[3].'</a>'; 
          print '</td></tr>'; 
          } 
        print '</table>'; 
    
     } 
     // Close the Oracle connection 
     oci_close($conn); 
   ?> 
  </ul> 

 </body> 
</html> 
