This is my code that will receive data from the database, then save it in a table for the .pdf file:
<?php
error_reporting(E_ALL);
include('includes/pdf/class.ezpdf.php');
$pdf = new Cezpdf();
session_start();
require_once('connect/ticketivity_connect.php');
$sql_cust = "SELECT * FROM customers where customer_id = '".$_GET['customerid']."'";
$res_cust = mysql_query($sql_cust);
$num_cust = mysql_num_rows($res_cust);
$row_cust = mysql_fetch_assoc($res_cust);
$db_data[] = array('first' => 'Customer Name:', 'second' => $row_cust['cust_name']);
$db_data[] = array('first' => 'Phone Number:', 'second' => $row_cust['cust_phone']);
$db_data[] = array('first' => 'Address:', 'second' => $row_cust['cust_address']);
$db_data[] = array('first' => '>Customer Ref/ Room Number:', 'second' => $row_cust['cust_ref']);
$sql_orderinfo= "SELECT * FROM orders where customer_id = '".$_GET['customerid']."'";
$res_orderinfo = mysql_query($sql_orderinfo);
$num_orderid = mysql_num_rows($res_orderinfo);
$row_orderid = mysql_fetch_assoc($res_orderinfo);
$orderid_len = strlen($row_orderid['order_id']);
if($orderid_len == 1) {
$db_data[] = array('first' => 'Order ID:', 'second' => '00000'.$row_orderid['order_id']);
} else if ($orderid_len == 2){
$db_data[] = array('first' => 'Order ID:', 'second' => '0000'.$row_orderid['order_id']);
} else if ($orderid_len == 3){
$db_data[] = array('first' => 'Order ID:', 'second' => '000'.$row_orderid['order_id']);
} else if ($orderid_len == 4){
$db_data[] = array('first' => 'Order ID:', 'second' => '00'.$row_orderid['order_id']);
} else if ($orderid_len == 5){
$db_data[] = array('first' => 'Order ID:', 'second' => '0'.$row_orderid['order_id']);
} else if ($orderid_len == 6){
$db_data[] = array('first' => 'Order ID:', 'second' => $row_orderid['order_id']);
}
$col_names = array(
'first' => 'first',
'second' => 'second',
);
$table_title = 'Customer Details';
$pdf->ezTable($db_data, $col_names, $table_title, array('width'=>550));
if (isset($d) && $d){
$pdfcode = $pdf->output(1);
$pdfcode = str_replace("\n","\n<br>", $pdfcode);
echo '<html><body>';
echo trim($pdfcode);
echo '</body></html>';
} else {
$pdf->ezStream();
}
?>
Conclusion:
%PDF-1.3 % 1 0 obj << /Type /Catalog /Outlines 2 0 R /Pages 3 0 R >> endobj 2 0 obj << /Type /Outlines /Count 0 >> endobj 3 0 obj << /Type /Pages /Kids [6 0 R ] /Count 1 /Resources << /ProcSet 4 0 R >> /MediaBox [0.000 0.000 595.280 841.890] >> endobj 4 0 obj [/PDF /Text ] endobj 5 0 obj << /Creator (R and OS php pdf writer, http://www.ros.co.nz) /CreationDate (D:20100817) >> endobj 6 0 obj << /Type /Page /Parent 3 0 R /Contents [ 7 0 R 8 0 R ] >> endobj 7 0 obj << /Filter /FlateDecode /Length 120 >> stream x 2 300P@& ҹ , \ `di gfb `ah gai `h d )(h8 ) $f k* d) pb1h 8sK qF @ F@ m\ - endstream endobj 8 0 obj << /Filter /FlateDecode /Length 94 >> stream x 2 300P@& ܹʹ , L, ,, r`" @$ Qi Jct 03 |C4 (" 7 2D a T4z endstream endobj xref 0 9 0000000000 65535 f 0000000015 00000 n 0000000080 00000 n 0000000126 00000 n 0000000257 00000 n 0000000286 00000 n 0000000391 00000 n 0000000464 00000 n 0000000657 00000 n trailer << /Size 9 /Root 1 0 R /Info 5 0 R >> startxref 823 %%EOF
What do I need to do / add?
source
share