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

database design
Hi,

I got a page which allow candidate to type in their previous working experience,
I let

Mail functionality from localhost to server
Hi

I am facing problem of mail functionality.

When i tested mail functionality in my

serializing objects - loses methods - the point being?
Hi

I know that serializing an object will lose the methods. But whats the point in that? What

SQL Injection
In my attempts to protect my database from mySQL injection I have created another problem for myself

php include email form with attachment
I have had no luck with finding a email form all over the Internet for various reasons. Some insecur

Printer configuration
Hi All,
Suppose one of the user deleted the printer settings unfortunatly ,then what is the pro

To change the name of label on SAP screen XK02.
Hi All,

Can one suggest me how to change the label of an input field of a sap standard s

Getting a variable to work in function params
I have this fuction which is inside a class:

Code: public static function generateEmbedCode($

Check premium expire
Hi,

I am making a simple file hosting site and want to check if users premium subscriptions h

if php cookie set, show code...
Hi all.. I need to figure out this little snippet right quick.. seems like it should be easy enough