php - Newbie problems with FPDF displaying values from database -
i new fpdf , im starting learn,
i trying display query database using php
and here codes.
<?php session_start(); $conn = @mysql_connect("","",""); $db = @mysql_select_db(""); require("../pdf/fpdf.php"); $qry = "select sum(order_detail.quantity*order_detail.price) chenes, orders.date order_detail left bring together orders on order_detail.orderid=orders.serial"; mysql_set_charset("utf8"); $result = @mysql_query($qry); if($result === false) { die(mysql_error()); // todo: improve error handling } while ($row=mysql_fetch_array($result)){ ?> <?php $pdf=new fpdf(); $pdf->addpage(); $pdf->setfont("arial","","13"); $pdf->cell(0,10,"sales reports",0,1,"c"); $pdf->setfont("arial","i","10"); $pdf->cell(0,10,"$row[chenes]",0,0,"c"); $pdf->output(); ?> <?php } ?>
and problem, fpdf error: info has been output, can't send pdf file how prepare it? want display values database, explanation nice. :)
try line:
$pdf->cell(0,10,$row['chenes'],0,0,"c");
php pdf fpdf
No comments:
Post a Comment