我想把结果数据放到表中
我想把结果数据放到表中
提问于 2019-08-15 17:30:46
为什么要横着填满桌子呢？我想下去，帮助plis :D
控制器
public function cetak_inbound($id){
$pdf = new FPDF('L','mm','A4');
$pdf->AddPage();
$pdf->SetFont('Arial','B',10);
$pdf->SetX(60);
$Y_Fields_Name_position = 15;
$pdf->SetY($Y_Fields_Name_position);
$pdf->SetX(10);
$pdf->Image('http://localhost/race/assets/frontend/img/logo-race.png',10);
$pdf->ln(30);
$cetakinb = $this->M_inbound->cetak_inbound($id);
foreach ($cetakinb->result() as $row){
$pdf->Cell(40,6,$row->kd_inbound,1,0);
$pdf->Cell(25,6,$row->tgl_inbound,1,0);
$pdf->Cell(67,6,$row->reciver_name,1,0);
}
$pdf->Output();
}模型
public function cetak_inbound($id){
$hasil=$this->db->query("SELECT nama_cs,kd_inbound,tgl_inbound,reciver_name,inbound.status FROM inbound INNER JOIN inbound_detail ON inbound.id_inbound=inbound_detail.id_inbound INNER JOIN service ON service.id_service=inbound_detail.id_service INNER JOIN customers ON customers.id_cs=service.id_cs WHERE inbound.id_inbound='$id'");
return $hasil;
}回答 1
Stack Overflow用户
回答已采纳
发布于 2019-08-15 17:35:23
您可以简单地在最后一列的每一列中添加$pdf->Ln()，如下所示：
public function cetak_inbound($id){
$pdf = new FPDF('L','mm','A4');
$pdf->AddPage();
$pdf->SetFont('Arial','B',10);
$pdf->SetX(60);
$Y_Fields_Name_position = 15;
$pdf->SetY($Y_Fields_Name_position);
$pdf->SetX(10);
$pdf->Image('http://localhost/race/assets/frontend/img/logo-race.png',10);
$pdf->ln(30);
$cetakinb = $this->M_inbound->cetak_inbound($id);
foreach ($cetakinb->result() as $row){
$pdf->Cell(40,6,$row->kd_inbound,1,0);
$pdf->Cell(25,6,$row->tgl_inbound,1,0);
$pdf->Cell(67,6,$row->reciver_name,1,0);
$pdf->Ln();
}
$pdf->Output();
}页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/57507612
复制相关文章
相似问题
腾讯云开发者
