<?php
    include '../Config/konek.php';
    $q=mysql_query('select * from plan');
    $i=1;
    while ($r=mysql_fetch_array($q)){
    $sql="INSERT INTO `plan2` (
    `KODE_PLAN` ,
    `ANGKATAN` ,
    `TGL_MULAI` ,
    `TGL_AKHIR` ,
    `ANGGARAN` ,
    `PST_A` ,
    `TGL_AWAL_REAL` ,
    `TGL_AKHIR_REAL` ,
    `ANGGARAN_REAL` ,
    `PST_REAL` ,
    `KODE_M` ,
    `TEKHNIK` ,
    `STREAM` ,
    `NAMA_M_TRAINING` ,
    `PL` ,
    `JP` ,
    `KODE_INST` ,
    `NAMA_INST` ,
    `KODE_UBIS` ,
    `NAMA_HR` ,
    `KODE_HR` ,
    `KODE_LC` ,
    `NAMA_LC` ,
    `KOTA` ,
    `Terlaksana` ,
    `Komen`
    )
    VALUES (
     $r[KODE_PLAN] ,$r[ANGKATAN] , '$r[TGL_MULAI]' ,' $r[TGL_AKHIR]' , $r[ANGGARAN] , $r[PST] , NULL , NULL , NULL ,NULL,
        $r[KODE_M],'$r[TEKHNIK]','$r[STREAM]','$r[NAMA_M_TRAINING]','$r[PL]','$r[JP]','$r[KODE_INST]',
        '$r[NAMA_INST]','$r[KODE_UBIS]','$r[NAMA_HR]','$r[KODE_HR]','$r[KODE_LC]','$r[NAMA_LC]','$r[KOTA]','$_POST[berhasil]','$_POST[cat]'
    )
    ";
    $h= mysql_query($sql) or die(mysql_error()."<p>$sql");

       $i++;
    }

?>