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

Email to a friend script problems
I have this send-to-a-friend script with 2 issues:


1) When you open the form popup on a p

how can i make a .gif images for my site
Dear Friends ,

Pls solve my problem , I am starting making new site but i dont know how can i

MII Netweaver Server stopped due to CPIC connection Problem
Dear Experts,
We have SAP XMII 12.0 setup running on Netweaver 2004s,7.0, Java Stack only.

Word Trimming
Hi Guys & Gals!!

Hope you are all ok....

I need some help with the following

Server side $_SESSION
how does one keep the session completely server side. no cookies to the browser at all. i need this

Using unserialize()
Hi there.

I have some data in my database that is serialized.

e.g.

a:2:{i:0

PHP search multiple input field box help
I am having a problem with my search script. At current it will simply search by a selected date whi

Progress bar tracking file downloads
Hey guys, was wondering if there was a way to track how far a file has been downloaded. I know there

Do not allow posting of whitespace
Currently the script below works if the user does not type a name/message, but if i create a whitesp

Binding 2 UDP sockets on same port, connected to different destinations, 1 receives
Hello,
My application wants to send/recv data to 2 different UDP ports on a remote computer, us