MS Access data into a html table

Posted on 16th Feb 2014 07:03 pm by admin

Hi everyone, I am quite a novice at php but I have created some helpful scripts that fetch data
from a ms access database that is used by our POS program at work ( a spa/salon)

My boss asked me to create a table kind of like this
which breaks down which clients an employee has seen and what months they have visited.

I've started by putting all the appointment data into an array
here my code
Code: <?php

$cn = odbc_connect(edge,admin,sharp);
$sql = "SELECT Code,FName,LName FROM Employees";
$res = odbc_exec($cn,$sql);

while(odbc_fetch_row($res))
{
$employees[odbc_result($res,'Code')] = array(fname=>odbc_result($res,'FName'),lname=>odbc_result($res,'LName'));
}


foreach($employees as $code => $details)
{
$sql2 = "SELECT ApptDate,CliDesc FROM Appointments WHERE EmpCode='".$code."' AND CliType<>'none'";
$res2 = odbc_exec($cn,$sql2);

while(odbc_fetch_row($res2))
{
$employees[$code]['appointments'][odbc_result($res2,'CliDesc')][] = odbc_result($res2,'ApptDate');
}
}

?>

I just can't wrap my mind about how I can create a table now...

Any suggestions or ideas would be awesome.

Thanks


PS
I have uploaded the sample database that the program demo comes with if you want to play around.
http://www.breze.ca/sample.mdb
Thanks for any help

Your Answer:

Login to answer

Other forums

'210010106140040100' == '210010106140040101'
Debugging this simple line of a PHP script

Code: if($a == $b){ }
I've found that with val

i have no idea why this isn't working
Code: <?php
session_start();
include("connect.php");

error_reporting(E

Text file to .Dat file Conversion in PHP
Hi All,
Could anybody provide code for Text file to .Dat file Conversion in PHP.

Tha

Procedural to OOP
John Kleijn said that to avoid writing "crappy code", we should learn OOP and common OO pr

cPanel API
Hi Guys,

Need a little guidance. I'm trying to get my script to communicate with cPanel (or W

Select Rows as Columns..
is there a way to select COLUMN_NAME from user_tab_columns where table_name='TABLENAME';
and ha

Sorting JTable on more than just the values listed in the columns
I have a collection of objects that store (among other things) two integer values. I only want to di

mod_rewrite.c on windows ??
why it's not working on windows while it's working on other hosts???

this is the code i got

need help with this contact form
I made this form and I need it to read the data and write the data to a table and its not working ca

php web service error
hey guys,
I'm working on a project requires the use of web services. I've been trying a few tutor