savagenoob Posted March 10, 2009 Share Posted March 10, 2009 I am learning EZ PDF and am not sure how to define table headers and use the data from the database. This code works <?php include ('class.ezpdf.php'); $pdf =& new Cezpdf(); $pdf->selectFont('./fonts/Helvetica.afm'); $data = array(); $result = mysql_query("SELECT Time, Clock, MinutesClock, EmpName FROM timeclock"); while($data[] = mysql_fetch_array($result, MYSQL_ASSOC)) {} $pdf->ezTable($data); $pdf->ezStream(); ?> but when I try to define the table headers it doesnt show the data... Here is what I tried. <?php include ('class.ezpdf.php'); $pdf =& new Cezpdf(); $pdf->selectFont('./fonts/Helvetica.afm'); $data = array(); $result = mysql_query("SELECT Time, Clock, MinutesClock, EmpName FROM timeclock"); while($data[] = mysql_fetch_array($result, MYSQL_ASSOC)) {} $pdf->ezTable($data, array('time'=>'Time','clock'=>'Clock Action', 'minutes'=> 'Minutes', 'employee'=> 'Employee')); $pdf->ezStream(); ?> Hopefully someone has some experience with this class and has a suggestion, thanks. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.