Synchronize Access Data to Oracle using PHP

 <?php

    $user="admin";
    $password="unisamho";
    $mdbFilename='\\\\192.168.0.19\unis$\unis.mdb';

   $con = odbc_connect("Driver={Microsoft Access Driver (*.mdb)};Dbq=$mdbFilename",$user, $password);
   if(!$con){
   die('Connection Error ');
    }
   if ($con)
  {
   $sql =  "select * from tEnter";

  $exc = odbc_exec($con,$sql);
  }
  else
  echo "odbc not connected<br>";
 
  //save_data($C_Name);
  $conn=oci_connect('t', 't','ala');

   ?>


<table align="center" border="3">
       <?php while(odbc_fetch_row($exc)){
          $C_Date=odbc_result($exc,"C_Date");
          $C_Time=odbc_result($exc,"C_Time");
          $L_TID=odbc_result($exc,"L_TID");
          $L_UID=odbc_result($exc,"L_UID");
          $C_Name=odbc_result($exc,"C_Name");         
          $C_Unique=odbc_result($exc,"C_Unique");
          $C_Office=odbc_result($exc,"C_Office");
          $C_Post=odbc_result($exc,"C_Post");
          $C_Card=odbc_result($exc,"C_Card");
          $L_Mode=odbc_result($exc,"L_Mode");
          $L_IsPicture=odbc_result($exc,"L_IsPicture");?>
   
       <?php

  $sql=  oci_parse($conn, "INSERT INTO enter(C_DATE,C_TIME,L_TID,L_UID,C_NAME,C_UNIQUE,C_OFFICE,C_Post,C_Card,L_Mode,L_IsPicture) SELECT '$C_Date','$C_Time','$L_TID','$L_UID','$C_Name','$C_Unique','$C_Office','$C_Post','$C_Card','$L_Mode','$L_IsPicture' FROM DUAL WHERE ('$C_Date','$C_Time') NOT IN(SELECT C_DATE,C_Time from enter)");
  $query=oci_execute($sql);

        ?>
        <?php }?>
</table>

কোন মন্তব্য নেই:

একটি মন্তব্য পোস্ট করুন