LOOPING-DEFAULT MENGGUNAKAN SCHEDULED TASK

1. bikin file koneksi  conn.php 

<?php
  
$host = "127.0.0.1";
$user = "root";
$pass = "";
$dbname = "dbserver";
$conn = mysql_connect($host,$user,$pass);
if($conn) {
    $sele = mysql_select_db($dbname);
    if(!$sele) {
    echo mysql_error();
    }
}
error_reporting(0) ;
?>

2. buat query insert file sch_sla.php

<?php
    date_default_timezone_set("Asia/Jakarta");
//    session_start();
    include_once("conn_sla.php");

      $DATE=date('Y-m-d');
     
      mysql_query("INSERT INTO tbl_apps_ofa (DATE, USER_COUNT, UPTIME_TARGET, UPTIME_ACTUAL, ID_CUSTOMER)
      VALUES('$DATE','90','810','810','1')");
?> 
3. buat file .bat untuk menjalankan query insert

4. setting Scheduled Tasks

a. control panel -> system and security -> add scheduled -> next

 b. pilih command prompt -> next

c. Disini saya pilih daily karena scheduled task akan d running per daily -> next

d. Pilih waktu scheduled task d running -> next

e.  masukkan user name dan password server anda -> next

f.  Finish

g. browse file .bat yang telah kita buat tadi 

h. Klik apply -> OK

 
Note : Per daily jam 08:00 am query yang d jalankan scheduled task akan looping otomatis ke table
output nya :

Selamat mencoba, Terimakasih ..

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... :)