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
Your Answer:
Login to answer
310
27
Other forums
Need PHP help... have all the elements... just need help putting them together :
Hey Guys,
I was wondering if someone could help me. I am doing a website for a client which
Search with relational database
Hey,
I have quite a complicated (for me anyway ) relational database for an apartments syste
PHP & Java
Hello,
can PHP code be used inside java code?
Code: [Select]<SCRIPT LANGUAGE=&q
how to insert value
I am having file bookissueadd.php..... in which i am having tag
<td height="21&q
xml
<?php
echo "<h1>XML Articles</h1>";
$home
big pagination problem in php
<?php
$connect = mysql_connect("localhost", "root", "")
i have no idea why this isn't working
Code: <?php
session_start();
include("connect.php");
error_reporting(E
default SAP userid
hi,, I just like to know if it is ok to use the default SAP user id (SAP*)?
Count of reciepients in php mailer
How can i sent a mail to large no of reciepients say 10,00,00 Using PHP MAILER
How do i use vars in an array
Hiya peeps!
How do I use a var in an array. You will see $id but it isnt working.