INSERT DATA ORACLE TO MYSQL-PHP

Berikut kodingan PHP untuk narik data oracle k mysql.. i tried n succes

<?php

//langkah pertama bikin koneksi ODBC ORACLE

$connect = odbc_connect("connectSLA","admin","123") or exit("Couldn't connect to DB");

$query="select * from intps.mpp_sla_analysis";

$result = odbc_exec($connect, $query);

$numOF = 0;

// langkah kedua bikin koneksi mySQL

$con = mysql_connect("localhost","root","");

if (!$con)
  {
  die('Error koneksi mySQL: ' . mysql_error());
  }
mysql_select_db("dbserver", $con);

?>
// table buat show data oracle
 <table border="0" align="center" cellpadding="8" cellspacing="1">
    <tr>
      <td bgcolor="#666666"><strong>No.</strong></td>
      <td bgcolor="#666666"><strong>PERIOD</strong></td>
      <td bgcolor="#666666"><strong>APPLICATION</strong></td>
      <td bgcolor="#666666"><strong>BUSINESS_UNIT</strong></td>
      <td bgcolor="#666666"><strong>USER_COUNT</strong></td>
      </tr>
<?php

 while(odbc_fetch_row($result)){
   $of1 = odbc_result($result, 1);
   $of2 = odbc_result($result, 2);
   $of3 = odbc_result($result, 3);
   $of4 = odbc_result($result, 4);

   $numOF++;

   // langkah ketiga query insert

   $query = "INSERT INTO dbserver.tbl_temporary
   SET PERIOD='".date('Y-m-d',strtotime($of1))."',
   APPLICATION='".$of2."',
   BUSINESS_UNIT='".$of3."',
   USER_COUNT='".$of4."'
   ";

   mysql_query($query);

   ?>

    <tr>
      <td align="right" bgcolor="#CCCCCC"><?php echo $numOF; ?></td>
      <td bgcolor="#CCCCCC"><?php echo $of1; ?></td>
      <td align="center" bgcolor="#CCCCCC"><?php echo $of2; ?></td>
      <td align="right" bgcolor="#CCCCCC"><?php echo $of3; ?></td>
      <td align="center" bgcolor="#CCCCCC"><?php echo $of4; ?></td>
    </tr>
    <?php
   
}
  ?>
  </table>
<?php
odbc_close($connect);
mysql_close($con);

Semoga Bermamfaat. Happy koding... :)