Retrive Access data using PHP


    <?php
    $user="admin";
    $password="unisamho";
    $mdbFilename='d:\unis.mdb';

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

  $exc = odbc_exec($con,$sql); 
  }
  else
  echo "odbc not connected<br>";
   ?>


<table align="center" border="3">
       <?php while(odbc_fetch_row($exc)){
          $L_ID=odbc_result($exc,"L_ID");
          $C_Name=odbc_result($exc,"C_Name");
          $C_Unique=odbc_result($exc,"C_Unique");
          $C_reg=odbc_result($exc,"C_RegDate")?>
    <tr>
        <td><?php echo $L_ID?></td>
        <td><?php echo $C_Name?></td>
        <td><?php echo $C_Unique?></td>
        <td><?php echo $C_reg?></td>

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




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

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