<?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>
$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>
কোন মন্তব্য নেই:
একটি মন্তব্য পোস্ট করুন