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

Session problem?!?
Hello All! I am very new to the php world but I am working on fixing things that a previous programm

Php mysql - select?
Hi i have this code:
Code: $iteminfo = mysql_query("SELECT desc FROM wc_items WHERE itemid =

Coding question?
Hey guys, I have a quick question. If I want to make a way for people to pay for health in my game,

unexpected T_SL without a shift left token
Nothing too see here, I'm an idiot and resolved the problem.

building a function with multiple outputs
I want to build a function that has multiple outputs.

I know but am not to sure how I should

Send inserts to mysql thru port 80
Hi!

I have an application that must do some inserts in a mysql db. This db is behind a firewa

send message to the java application
Oracle 10g with Windows platform.

I have a java application that periodically pings the d

Array help
Hello i got this code to fetch data from database but it is not working it displays
7
Array

Turning Data into URLs?
This may seem very basic to you, but I'm having a hard time figuring out how to do this since I don'

utl_file open error
i have file in the unix path

Path /popdev01/pop/popdevb/tfi/

File name