fatika Posted April 26, 2020 Share Posted April 26, 2020 <?php require('../fpdf/fpdf.php'); include_once'../db/connect_db.php'; $id = $_GET['id']; $select = $pdo->prepare("SELECT * FROM tbl_invoice WHERE invoice_id=$id"); $select->execute(); $row = $select->fetch(PDO::FETCH_OBJ); $pdf = new FPDF('P','mm', array(80,200)); $pdf->AddPage(); $pdf->SetFont('Arial','B',16); $pdf->Cell(60,10,'Haske Eye Specialist',0,1,'C'); $pdf->Line(10,18,72,18); $pdf->Line(10,19,72,19); $pdf->SetFont('Arial','',8); $pdf->Cell(60,3,'No 16 Musa Shehu Close',0,1,'C'); $pdf->SetFont('Arial','',8); $pdf->Cell(63,3,'Behind Nunu International School, Kawo Kaduna',0,1,'C'); $pdf->SetFont('Arial','',8); $pdf->Cell(63,4,'No. Telp: +234 09015445656',0,1,'C'); $pdf->Line(10,30,72,30); $pdf->Line(10,31,72,31); $pdf->SetY(31); $pdf->SetFont('Arial','B',10); $pdf->Cell(60,6 ,'Purchase Orders',0,1,'C'); $pdf->SetFont('Courier','B',8); $pdf->Cell(20,4 ,'Rept No. :',0,0,'C'); $pdf->SetFont('Courier','BI',8); $pdf->Cell(10,4 ,$row->invoice_id,0,1,'C'); $pdf->SetFont('Courier','B',8); $pdf->Cell(20,4 ,'User name :',0,0,'C'); $pdf->SetFont('Courier','BI',8); $pdf->Cell(10,4 ,$row->cashier_name,0,1,'C'); $pdf->SetFont('Courier','B',8); $pdf->Cell(20,4 ,'Date & Time:',0,0,'C'); $pdf->SetFont('Courier','BI',8); $pdf->Cell(21,4 ,$row->order_date,0,0,'C'); $pdf->SetFont('Courier','BI',8); $pdf->Cell(10,4 ,$row->time_order,0,1,'C'); ////////////////////////////////////////////// $pdf->SetY(55); $pdf->SetX(6); $pdf->SetFont('Arial','B',8); $pdf->Cell(27,8 ,'Product',1,0,'C'); $pdf->SetFont('Arial','B',8); $pdf->Cell(7,8 ,'Qty',1,0,'C'); $pdf->SetFont('Arial','B',8); $pdf->Cell(18,8 ,'Price',1,0,'C'); $pdf->SetFont('Arial','B',8); $pdf->Cell(18,8 ,'Total',1,1,'C'); $select = $pdo->prepare("SELECT * FROM tbl_invoice_detail WHERE invoice_id=$id"); $select->execute(); while($item = $select->fetch(PDO::FETCH_OBJ)){ $pdf->SetX(6); $pdf->SetFont('Arial','B',8); $pdf->Cell(27,5,$item->product_name,1,0,'L'); $pdf->Cell(7,5,$item->qty,1,0,'C'); $pdf->SetFont('Arial','B',7); $pdf->Cell(18,5,'Naira '.number_format($item->price),1,0,'R'); $pdf->Cell(18,5,'Naira '.number_format($item->total),1,1,'R'); } ////////////////////////////////////////////// $pdf->SetX(43); $pdf->SetFont('Arial','Bi',8); $pdf->Cell(25,8 ,'Total :',0,0,'C'); $pdf->SetFont('Arial','BI',7); $pdf->Cell(1,8 ,'Naira ' . number_format($row->total),0,1,'C'); $pdf->SetX(43); $pdf->SetFont('Arial','BI',7); $pdf->Cell(25,4 ,'Paid :',0,0,'C'); $pdf->SetFont('Arial','BI',7); $pdf->Cell(1,4 ,'Naira '. number_format($row->paid),0,1,'C'); $pdf->SetX(43); $pdf->SetFont('Arial','BI',8); $pdf->Cell(25,8 ,'Due :',0,0,'C'); $pdf->SetFont('Arial','BI',7); $pdf->Cell(1,8 ,'Naira '. number_format($row->due),0,1,'C'); ////////////////////////////////////////////// $pdf->SetY(80); $pdf->SetX(7); $pdf->SetFont('Arial','BU',5); $pdf->Cell(75,4 ,'Returns Drugs Are Not Accepted',0,1,'L'); $pdf->SetFont('Arial','BU',5); $pdf->Cell(45,4 ,'Collect Your Receipt ans Call:-09015445656 for Enquiries',0,0,'C'); $pdf->Output(); Quote Link to comment https://forums.phpfreaks.com/topic/310650-fail-to-show-product-price-and-qty-in-print-out/ Share on other sites More sharing options...
StevenOliver Posted April 27, 2020 Share Posted April 27, 2020 (edited) Turn error reporting on! Begin your php code with ini_set('display_errors', 1); ini_set('display_startup_errors', 1); error_reporting(E_ALL); Catch errors in PDO with 'try' and 'catch' (google this) example: try { $db = new PDO blah blah blah your stuff goes here } catch(Exception $e) { echo 'Exception -> '; var_dump($e->getMessage()); } I don't know anything about PDF... so I'm not reading your pdf code :-) Edited April 27, 2020 by StevenOliver 1 Quote Link to comment https://forums.phpfreaks.com/topic/310650-fail-to-show-product-price-and-qty-in-print-out/#findComment-1577272 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.