StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POBlank Output PDF using FPDF library - codeigniter
primarykey
Id
12599192
data
AcceptedAnswerId
0
AnswerCount
1
ClosedDate
CommentCount
3
CommunityOwnedDate
CreationDate
2012-09-26T09:59:25.147
FavoriteCount
0
LastActivityDate
2018-08-19T06:01:39.007
LastEditDate
2013-11-06T10:26:16.760
LastEditorUserId
39277
OwnerUserId
1681012
ParentId
0
PostTypeId
1
Score
1
ViewCount
10872
LastEditorDisplayName
text
Body
I'm going to generate a PDF report using FPDF library, but the output is blank. There is no error displayed, how can I fix this problem? Anyway, I tried this code in LOCALHOST and it works perfectly, but when I upload it to the cloud, there's no output to be displayed.. I tried to make the function output like this.. <pre><code>$this->fpdf->OUTPUT('try.pdf','I'); but nothing happens.. </code></pre> NOTE: In my output, C:/backup/employee_..php, the output is in the folder, there's no error and it works fine.. but when I upload this one, there no output to be display This is my CONTROLLER: <pre><code>public function backup_employees_pdf() { $this->load->library('fpdf'); define('FPDF_FONTPATH',$this->config->item('fonts_path')); $this->fpdf =new FPDF('L', 'mm', 'Legal', true, 'UTF-8', false); $this->fpdf->AliasNbPages(); $this->fpdf->AddPage(); //load data $data = array(); $row = $this->m_employee->load_data_employees(); $data = $row->result(); // Whatever written here will come in header of the pdf file. $this->fpdf->Image('assets/images1/mpowerstafflogo.jpg',10,5,50,50,'','www.mpowerstaff.com'); $this->fpdf->SetFont('Arial','B',15); $this->fpdf->Cell(140); $this->fpdf->Cell(50,10,'Employee File Management Website',0,0,'C'); $this->fpdf->Ln(5); $this->fpdf->Cell(140); $this->fpdf->Ln(5); $this->fpdf->SetFont('Arial','',12); $this->fpdf->Cell(140); $this->fpdf->Cell(50,10,'3F Room 305 Jackson Bldg. 926 Arnaiz Ave., San Loreno Village Makati City, 1223 PHILIPPINES',0,0,'C'); $this->fpdf->Ln(5); $this->fpdf->Ln(5); $this->fpdf->Cell(140); $this->fpdf->Cell(50,10,'Tel. (632) 810-4026 * 810-9121',0,0,'C'); $this->fpdf->Ln(5); $this->fpdf->Ln(5); $this->fpdf->Cell(140); $this->fpdf->Cell(50,10,'Email: mpowerstaff@yahoo.com',0,0,'C'); $this->fpdf->Ln(10); $this->fpdf->SetFont('Arial','B',12); $this->fpdf->Cell(140); $this->fpdf->Cell(50,10,'Employees Report',0,0,'C'); $this->fpdf->Ln(15); // Colors, line width and bold font $this->fpdf->SetFillColor(105,100,231); $this->fpdf->SetTextColor(255); $this->fpdf->SetDrawColor(60,89,117); $this->fpdf->SetLineWidth(0.3); $this->fpdf->SetFont('', 'B'); // Header $w = array(35,80,40,40,40,40,61); $this->fpdf->Ln(); //border LRTB $this->fpdf->Cell(5); $this->fpdf->Cell(90,10,'NAME',1,0,'C', 'LR'); $this->fpdf->Cell(60,10,'ACCOUNT NUMBER',1,0,'C', 'LR'); $this->fpdf->Cell(60,10,'ADDRESS',1,0,'C', 'LR'); $this->fpdf->Cell(60,10,'BIRTHDAY',1,0,'C', 'LR'); $this->fpdf->Cell(60,10,'CONTACT NO.',1,0,'C', 'LR'); $this->fpdf->Ln(10); // Color and font restoration $this->fpdf->SetFillColor(224, 235, 255); $this->fpdf->SetTextColor(0); $this->fpdf->SetFont(''); $fill = 0; //data foreach($data as $empsItem) { $this->fpdf->Cell(5); $this->fpdf->Cell(90,10,$empsItem->name,1,0,'C',$fill); $this->fpdf->Cell(60,10,$empsItem->account_no,1,0,'C',$fill); $this->fpdf->Cell(60,10,$empsItem->address,1,0,'C',$fill); $this->fpdf->Cell(60,10,$empsItem->birthday,1,0,'C',$fill); $this->fpdf->Cell(60,10,$empsItem->contact_no,1,0,'C',$fill); $this->fpdf->Ln(10); $fill=!$fill; } $this->fpdf->Ln(30); $this->fpdf->SetFont('Arial','B',10); $this->fpdf->Cell(20, 5,'Total Employees: '.$row->num_rows(), '', 0, 'LR', 0); $this->fpdf->SetY(184); $this->fpdf->SetFont('Arial','I',8); $this->fpdf->Cell(0,10,'Copyright. All Rights Reserved',0,0,'C'); $this->fpdf->Cell(0,10,'Page '.$this->fpdf->PageNo().' of {nb}',0,0,'C'); $dir = 'C:/backup/'; $filename = "employee report"; $this->fpdf->Output($dir.$filename.'.pdf'); } </code></pre> //====THIS IS MY MODEL===// <pre><code>public function load_data_employees() { $query = $this->db->query("SELECT concat(e_first_name,' ',e_middle_name,' ',e_last_name) AS 'name',account_number AS 'account_no',address AS 'address',birthday AS 'birthday',contact_number AS 'contact_no'FROM tb_emp where status='available'"); return $query; } </code></pre> //== CONFIG.PHP==// <pre><code>$config['fonts_path']= "./system/fonts/font/"; </code></pre> that's the details. I tried to fix this but still, there no output.
Tags
<codeigniter><fpdf>
Title
Blank Output PDF using FPDF library - codeigniter
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USDoctor Jones
UserOwnerUserId
1. USwatangka
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. PL
 singulars
 LinkTypeLinkTypeId
 LTLinked
2. PL
 singulars
 LinkTypeLinkTypeId
 LTLinked
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. COCouple of questions: 1) Has this code ever worked remotely, or is this the first test? 2) Does PHP / the user it runs under have access to the output directory?
 singulars
 PostPostId
 POBlank Output PDF using FPDF library - codeigniter
 UserUserId
 USuser1201210
2. COyes.. it works! yes.. it worked remotely and I allow the folder for the user to have an access to write.. and by the way.. before i run it to this output i've tried this: $this->fpdf->Output('file.pdf','I'); and it work but I try to upload it, there no output..
 singulars
 PostPostId
 POBlank Output PDF using FPDF library - codeigniter
 UserUserId
 USwatangka

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.