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

login from external site
Hi my new experience begins, Now what i am trying to do is i make three pages, login.php logout.php

Parse String
I need to parse the string below into three variables. How would I do that?

john + 10/20/2008

Count number of records in all the tables with a querry URGENT PLEASE...
I downloaded ORACLE 9I DATA DUMP into my comp. There are number of tables. I need to find out the

keeps going back to index.html ???????
ok so i started making my site using mostly.html files now i have added a fair chunk of php. My inde

batch file not building to webapps folder
Hello. I just started running Vista :P and can't seem to get my projects deployed. I found out how

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.

SQL Query/echo not working
Hey all,

I'm trying to run (what I thought) was a simple operation and it isn't working. I h

This is driving me nuts!
This insert query looks to be alright, however I get this error:

QuoteYou have an error in yo

Need help with basic sql
Hi,

I am using oracle 10g, and having some small doubts related to sql , here goes the si

Dynamic links in an include file
I am working on a small piece of code that counts records from a database and displays the result to