<table align="center" width="90%">

    <tr>

        <td align="left" valign="top"><br><strong><font color="#000033" size="3" face="Verdana">VESSEL SCHEDULE</font></strong></td>

    </tr>

</table>

<hr>



<form name="vessel" action="<?php $PHP_SELF; ?>" method="post">

<table align="left">

    <tr>

       

      <td><font color="#330000" size="2" face="Verdana">Vessel Name</font></td>

        <td>:<input type="text" name="ves"></td>

        <td><input type="submit" name="submit" value="Search"></td>

    </tr>

</table>

</form>

<?php

if($submit)

{

    $conn=ocilogon(’db_name’,’pass’,’sid’);

    $f5=’db_name’;

    $no=1;

    $non=0;

    $ves = strtoupper($ves);

    $que1 = "SELECT TO_CHAR(VV.BERTHING_DATE,’MM/DD/YYYY HH24:MI:SS’) AS BERTHING_DATE,

TO_CHAR(VV.DEPARTURE_DATE,’MM/DD/YYYY HH24:MI:SS’) AS DEPARTURE_DATE,

VM.VES_NAME

FROM $f5.vessel_voyage VV, $f5.vessel_master VM

WHERE VV.ves_code IN

  (SELECT ves_code FROM $f5.vessel_master WHERE ves_name LIKE UPPER (’%$ves%’) )

  AND VV.VES_CODE=VM.VES_CODE AND ROWNUM<=50

                ORDER BY berthing_date DESC";

    $sta2 = ociparse($conn,$que1);

    ociexecute($sta2);

    ?>

    <table align="center" cellspacing="1" bgcolor=’#d3ecff’ width="98%">

    <tr bgcolor="#000066">

           <td align="center" height="27"><font color=’yellow’ size=’2’ face=’verdana’>No.</font></td>       

        <td align="center"><font color=’yellow’ size=’2’ face=’verdana’>Ves. Code</font></td>

        <td align="center"><font color="yellow" size="2" face="Verdana">Ves. Id</font></td>

        <td align="center"><font color="yellow" size="2" face="Verdana">Voy. Out</font></td>

        <td align="center"><font color="yellow" size="2" face="Verdana">Voy. In</font></td>

        <td align="center"><font color="yellow" size="2" face="Verdana">Ves. Name</font></td>

        <td align="center"><font color="yellow" size="2" face="Verdana">Agent</font></td>

        <td align="center"><font color="yellow" size="2" face="Verdana, Arial, Helvetica, sans-serif">Berthing Date</font></td>

        <td align="center"><font color="yellow" size="2" face="Verdana, Arial, Helvetica, sans-serif">Departure Date</font></td>

    </tr>

    <?PHP

    while(@ocifetch($sta2))

    {

     if ($no%2 == 1) { $style = "row1"; }

              else { $style = "row2"; }

                echo "<tr class=’".$style."’>";

    ?>

        <td align="center" height="15"><?php echo$no;?></td>       



        <td align="center"><?php echo ociresult($sta2,"BERTHING_DATE")?></td>

        <td align="center"><?php echo ociresult($sta2,"DEPARTURE_DATE")?></td>

    </tr>

    <?

    $no++;

    $non++;

    }//END WHILE

}   

?>

</table>

 

1. copy isi folder instant client oracle atau oci.dll ke dalam folder F:\xampp\apache\bin

2. ubah isi file F:\xampp\php\php.ini dengan menghilangkan comment untuk baris yang berisi

extension=php_oracle.dll

extension=php_oci8.dll

contoh file: koneksi :

    $f5=’dbname’;   

$db="(DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

    (CONNECT_DATA = (SID = sidname))

  )";

if (!$conn) {

$m = oci_error();

echo $m["message"];

exit;

}