douan4347 2018-02-17 10:02
浏览 110
已采纳

使用php将mysql中的数据打印成pdf文件

I am using FPDF for the PDF and so far in my search I saw this similar question to my question and followed the code there and when I ran it no Error was being called and the PDf can be downloaded. But the problem is when I open the PDF file it is empty and I can't seem to understand the problem. This is my PHP code:

<?php
include("connections.php");
require("fpdf181/fpdf.php");
$pdf = new FPDF(); 
$name = $address = $email = "";
$nameErr = $addressErr = $emailErr = "";

if($_SERVER["REQUEST_METHOD"] == "POST"){ 
if(empty($_POST["name"])){
    $nameErr = "Name is required!";
}else{
    $name = $_POST["name"];
}
if(empty($_POST["address"])){
    $addressErr = "Address is required!";
}else{
    $address = $_POST["address"];
}
if(empty($_POST["email"])){
    $emailErr = "Email is required!";
}else{
    $email = $_POST["email"];
}   
}
//When button is clicked the pdf will be generated
if (isset($_POST["btn_1"])) {
$pdf = new FPDF();
$pdf->AddPage();
$pdf->SetFont('','',12);

$view_query = mysqli_query($connections, "SELECT * FROM sample");
//where the database is accessed
while ($row = mysqli_fetch_assoc($view_query))
{
$db_name = $row["Name"];
$db_address = $row["Address"];
$db_email = $row["Email"];

$pdf->Cell(0,10,'', $db_name,1); 
$pdf->Ln();
$pdf->Cell(0,10,'', $db_address,1); 
$pdf->Ln();
$pdf->Cell(0,10,'', $db_email,1); 
$pdf->Ln();
}
$pdf->Output();

}
?>
<style>
.error{
color:red;  
}
</style>

<form method = "POST" action= "<?php htmlspecialchars("PHP_SELF");?>">

<input type = "text" name="name" value="<?php echo $name; ?>"><br>
<span class = "error"><?php echo $nameErr;?></span><br>

<input type = "text" name="address" value="<?php echo $address; ?>"><br>
<span class = "error"><?php echo $addressErr;?></span><br>

<input type = "text" name="email" value="<?php echo $email; ?>"><br>
<span class = "error"><?php echo $emailErr;?></span><br>

<input type = "submit" value="Submit">

<input type = "submit" name="btn_1" value="PDF">

</form>

<?php
// Insert to table
if($name && $address && $email){
$query = mysqli_query($connections, "INSERT INTO sample(Name,Address,Email) 
VALUES('$name','$address','$email')");

echo "<script language='javascript'>alert('New Record has been inserted!')
</script>";
echo"<script>window.location.href='index.php';</script>";
}
//view table
$view_query = mysqli_query($connections, "SELECT * FROM sample");
echo"<table border = '1' width ='50%'>";
echo "<tr>
<td>Name</td>
<td>Address</td>
<td>Email</td>
</tr>";
while ($row = mysqli_fetch_assoc($view_query)) {

$db_name = $row["Name"];
$db_address = $row["Address"];
$db_email = $row["Email"];
echo "<tr>
<td>$db_name</td>
<td>$db_address</td>
<td>$db_email</td>
</tr>";
    }
echo "</table>";
mysqli_close($connections);
?>

展开全部

  • 写回答

1条回答 默认 最新

  • dongyou8701 2018-02-17 10:16
    关注

    This line

    $pdf->SetFont('','',12);
    

    sets your font to current font.

    But you didn't set any font earlier, so fpdf doesn't know, which font to use.

    So, first, you need to set font as described in SetFont manual page.

    Next, is Cell function. It's definition is

    Cell(float w [, float h [, string txt [, mixed border [, int ln [, string align [, boolean fill [, mixed link]]]]]]])
    

    See? Text which you want to write to pdf comes as third parameter.

    In you call

    $pdf->Cell(0,10,'', $db_name,1); 
    

    third parameter is what? Empty string, I suppose.

    So, second, you need to fix your Cell calls.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
编辑
预览

报告相同问题?

悬赏问题

  • ¥15 Codesys配置ethercat错误
  • ¥15 mstsc远程桌面轮流掉线
  • ¥15 求一下oivio数据集
  • ¥15 android开发百度网盘文件浏览功能,是什么做的?用的什么技术实现?
  • ¥20 地震波形数据向量化的问题
  • ¥15 脊柱MRI图片分割与自动识别
  • ¥50 使用ADC0809 与 51 单片机设计电路以实现显示电压模拟值
  • ¥15 QGC打开没有地图显示,离线地图也不显示,如何解决?
  • ¥20 Android Studio 的 webview 与访问网络存在的限制
  • ¥15 某帖子的数据集不清楚来源,求帮助