I have manage to query a table in MS Access DB using PDO with PHP programming. But the table displayed in vertical view. I want to change it to normal table but I don't know how.
Here is my code :
<?php
if(isset($_POST['search']))
{
$month = $_POST['month'];
$year = $_POST['year'];
$connectdb = new PDO("odbc:DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=D:\Demo2018.mdb; Uid=; Pwd=COMPLETEPAYROLL;");
$sql = "SELECT *
FROM `tblPAyTrans`
WHERE Month ='$month' AND Year ='$year'";
if ($result = $connectdb->query($sql)) {
echo '<table>';
foreach($result->fetchAll(PDO::FETCH_ASSOC) as $row) {
foreach($row as $key => $value) {
echo '<tr><td>' . $key . '</td></tr>';
echo '<tr><td>' . $value . '</td></tr>';
}
}
echo '</table>';
}
}
?>
The output look like this :
| AutoNumber |<-column
| 39779 |<-value
| Employee ID |<-column
| 1008 |<-value
| Salary Type |<-column
| Monthly |<-value
| Pay Frequency |<-column
| Once a Month |<-value
The output that I want :
|Column Name|Column Name|Column Name|Column Name|
| Value | Value | Value | Value |