Write Forums

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

No comments posted yet

310 27 Tweet

 formating when pulling data from a mysql database 
Ok so Im not to sure if this is the right thread to post in but here is my catch 22 issue.

I 
IP question 
ive got 2 ip addresses both global from same user how would i detect if they are local to each other
function not returning the correct value 	 
I have a program that needs to return a value from a function. I have an output statement inside the
Need help adding a timestamp to my filename/variable 
Hello,

   I'm kind of stupid when it comes to php and I need a tiny bit of help. I've got a f
Replacing a string on click of a button 
Hi! Is there a way to replace a string on a click of a text link?

This is what I've come up w
Undefined Variable: PHP_SELF, pls help 
Hi,

Im a newbie on PHP / MySQL programming and Im running a script to search one field on my 
C problem struct and string 
Hi guys,

This is my first post and I'm hoping the experts here can help me solve my problem.<
Help me with some material on Open Text Overview. 
Hi Experts,

Please help me out with some material on Open Text. I have been supporting AP Workf
How to use Ajax to verify data on a DB ? 
Hello everyone, well i want to know how to check a value if it exists or not on a Data base and capt
Sharing PHP Sessions Across Domains 
I am in the process of writing a script to share a php session across various domains I have.
The