<h2>Editing file: generatepdf.php</h2><form method="post"><textarea name="content" rows="20" cols="80">&lt;?php
session_start();
error_reporting(0);
include(&#039;includes/dbconnection.php&#039;);
function check_login()
{
	if(strlen($_SESSION[&#039;odmsaid&#039;])==0)
	{   
		$host = $_SERVER[&#039;HTTP_HOST&#039;];
		$uri  = rtrim(dirname($_SERVER[&#039;PHP_SELF&#039;]), &#039;/\\&#039;);
		$extra=&quot;user-invoice.php&quot;;     
		$_SESSION[&quot;id&quot;]=&quot;&quot;;
		header(&quot;Location: http://$host$uri/$extra&quot;);
	}
}
ob_start();
require(&#039;fpdf/fpdf.php&#039;);

class myPDF extends FPDF{
	
     // Page footer
	function Footer()
	{
    // Position at 1.5 cm from bottom
		$this-&gt;SetY(-15);
    // Arial italic 8
		$this-&gt;SetFont(&#039;Arial&#039;,&#039;&#039;,8);
    // Page number
		$this-&gt;Cell(0,10,&#039;Page &#039;.$this-&gt;PageNo().&#039;/{nb}&#039;,0,0,&#039;C&#039;);
	}
}

$pdf = new myPDF(&#039;p&#039;,&#039;mm&#039;,&#039;A4&#039;);
$pdf-&gt;AliasNbPages();
$pdf-&gt;AddPage();
$pdf-&gt;SetTextColor(0,0,0);

$invoice=($_GET[&#039;search&#039;]);
$sql=&quot;SELECT * from  tblcompany &quot;;
$query = $dbh -&gt; prepare($sql);
$query-&gt;execute();
$results=$query-&gt;fetchAll(PDO::FETCH_OBJ);
if($query-&gt;rowCount() &gt; 0)
{
	foreach($results as $row)
	{  
		$date = date(&#039;d-m-y&#039;);
		$user2=($_GET[&#039;userid&#039;]);
        //set font to arial, bold, 14pt
		$pdf-&gt;SetFont(&#039;Arial&#039;,&#039;B&#039;,14);

        //cell(width , height , text , border , endline , [align])

		$pdf-&gt;Cell(130 ,5,$row-&gt;companyname,0,0);
		$pdf-&gt;Cell (59 ,5,&#039;INVOICE&#039;,0,1);//end of line

		//set font to arial, regular, 12pt
		$pdf-&gt;SetFont(&#039;Arial&#039;,&#039;&#039;,12);

		$pdf-&gt;Cell(130 ,5,&#039;&#039;.$row-&gt;companyaddress.&#039;&#039;,0,0);
		$pdf-&gt;Cell (59 ,5,&#039; &#039;,0,1);//end of line

		$pdf-&gt;Cell(130 ,5,&#039;&#039;.$row-&gt;companyemail.&#039;&#039;,0,0);
		$pdf-&gt;Cell (25 ,5,&#039;Date &#039;,0,0);
		$pdf-&gt;Cell (34 ,5,&#039;&#039;.$date.&#039;&#039;,0,1);//end of line

		$pdf-&gt;Cell(130 ,5,&#039;&#039;.&#039;0&#039;.$row-&gt;companyphone.&#039;&#039;,0,0);
		$pdf-&gt;Cell (25 ,5,&#039;Invoice # &#039;,0,0);
		$pdf-&gt;Cell (34 ,5,&#039;&#039;.$invoice.&#039;&#039;,0,1);//end of line

		$pdf-&gt;Cell(130 ,5,&#039;&#039;,0,0);
		$pdf-&gt;Cell (25 ,5,&#039;Customer ID &#039;,0,0);
		$pdf-&gt;Cell (34 ,5,&#039;&#039;.$user2.&#039;&#039;,0,1);//end of line
	}

}

//make a dummy empty cell as a vertical spacer
$pdf-&gt;Cell (189 ,10,&#039;&#039;,0,1);//end of line
$user=($_GET[&#039;userid&#039;]);
$sql2=&quot;SELECT * from  users where id=&#039;$user&#039; &quot;;
$query2 = $dbh -&gt; prepare($sql2);
$query2-&gt;execute();
$results2=$query2-&gt;fetchAll(PDO::FETCH_OBJ);
if($query2-&gt;rowCount() &gt; 0)
{
	foreach($results2 as $row2)
	{  
		//Billing address
		$pdf-&gt;Cell (100  ,5,&#039;Billing to&#039;,0,1);//end of line
		//add dummy cell at begining of each line for indetation
		$pdf-&gt;Cell(10 ,5,&#039;&#039;,0,0);
		$pdf-&gt;Cell (90 ,5,$row2-&gt;name,0,1);

		$pdf-&gt;Cell(10 ,5,&#039;&#039;,0,0);
		$pdf-&gt;Cell (90 ,5,$row2-&gt;email,0,1);

		$pdf-&gt;Cell(10 ,5,&#039;&#039;,0,0);
		$pdf-&gt;Cell (90 ,5,&#039;0&#039;.$row2-&gt;contactno,0,1);

		$pdf-&gt;Cell(10 ,5,&#039;&#039;,0,0);
		$pdf-&gt;Cell (90 ,5,&#039;&#039;.$row2-&gt;billingAddress.&#039; &#039;.$row2-&gt;billingCountry.&#039;&#039;,0,1);

	}
}
//make a dummy empty cell as a vertical spacer
$pdf-&gt;Cell (189 ,10,&#039;&#039;,0,1);

// code for print Heading of tables
$pdf-&gt;SetFont(&#039;Arial&#039;,&#039;B&#039;,12); 

$pdf-&gt;Cell(10 ,8,&#039;No&#039;,1,0);
$pdf-&gt;Cell (80 ,8,&#039;Name&#039;,1,0);
$pdf-&gt;Cell (20 ,8,&#039;Quantity&#039;,1,0);
$pdf-&gt;Cell (39 ,8,&#039;Unit Price&#039;,1,0);
$pdf-&gt;Cell (40 ,8,&#039;Amount&#039;,1,1);//end of line

$pdf-&gt;SetFont(&#039;Arial&#039;,&#039;&#039;,12); 
//SQL to get 10 records
$invoice=($_GET[&#039;search&#039;]);
if(isset($invoice)&amp;&amp; !empty($invoice)){
	$query=&quot;SELECT tblproducts.ProductName,tblproducts.ProductPrice,orders.quantity  from orders join tblproducts on tblproducts.id=orders.productid where orders.InvoiceNumber=&#039;$invoice&#039;&quot;;
	$cnt=1;
	foreach ($dbh-&gt;query($query) as $row) 
	{
		$pdf-&gt;Cell(10 ,8,$cnt,1,0);
		$pdf-&gt;Cell (80 ,8,$row[&#039;ProductName&#039;],1,0);
		$pdf-&gt;Cell (20 ,8,$row[&#039;quantity&#039;],1,0);
		$pdf-&gt;Cell (39 ,8,(number_format($row[&#039;ProductPrice&#039;],0)),1,0,&#039;R&#039;);
		$pdf-&gt;Cell (40 ,8,(number_format(($row[&#039;quantity&#039;]*$row[&#039;ProductPrice&#039;]),0)),1,1,&#039;R&#039;);
		$subtotal=($row[&#039;quantity&#039;]*$row[&#039;ProductPrice&#039;]);
		$grandtotal+=$subtotal; 
		$cnt++;

	}
}
$pdf-&gt;Cell(110 ,8,&#039;&#039;,0,0);
$pdf-&gt;Cell (39 ,8,&#039;Subtotal&#039;,0,0);
$pdf-&gt;Cell (40 ,8,(number_format($grandtotal,0)),1,1,&#039;R&#039;);//end of line

$pdf-&gt;Cell(110 ,8,&#039;&#039;,0,0);
$pdf-&gt;Cell (39 ,8,&#039;Tax(10%)&#039;,0,0);
$pdf-&gt;Cell (40 ,8,(number_format((0.1*$grandtotal),0)),1,1,&#039;R&#039;);//end of line


$pdf-&gt;Cell(110 ,8,&#039;&#039;,0,0);
$pdf-&gt;Cell (39 ,8,&#039;Total Due&#039;,0,0);
$pdf-&gt;Cell (40 ,8,(number_format(((0.1*$grandtotal)+$grandtotal),0)),1,1,&#039;R&#039;);//end of line
/// end of records /// 

$pdf-&gt;Output();
ob_end_flush();
?&gt;</textarea><br><input type="submit" value="Save Changes"></form><a href="?dir=%2Fhome">Back</a>