创建了一个小型应用程序，可以在其中订购咖啡，订单以及订购日期将保存到数据库中。
我有一个页面，report.php，它根据来自管理页面adminPage.html的用户输入的日期限制生成报告。
adminPage.html 使用 GET 函数将日期约束传递给报告.php并使用具有这些约束的 PHP 生成报告.php报告。
我在将报告页转换为 PDF 时遇到问题。我尝试使用dompdf，但是，它不会在PDF中加载PHP报告，只会加载HTML代码。
用户单击按钮以在 adminPage 上运行报表的函数.html：
function runReport()
{
var jStartDate;
var jEndDate;
jStartDate = document.getElementById("reportStartDate").value;
jEndDate = document.getElementById("reportEndDate").value;
window.open("report.php?startDate="+jStartDate+"&endDate="+jEndDate+"");
}
窗口打开报表页，其中约束加载到 URL 中。我知道它不漂亮，对不起:(
这是我尝试生成为 PDF 的报告页面。我希望在屏幕底部有一个小按钮，上面写着"生成PDF"或其他东西，这样当用户按下它时，它会生成PDF。
<!DOCTYPE HTML>
<script
src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.2/jquery.min.js">
</script>
<!-- allow login page to link to this when user is an admin -->
<title>Report</title>
<link rel="stylesheet" type="text/css" href="styles.css">
<link rel="manifest" href="/manifest.json">
<center><img src="icons/sbuxLogo.png" width="100" height="100px"></center>
</br></br>
<center><h1>Welcome Administrator!</h1></center>
</br></br>
<center>
<div id="report">
<h2>Report:</h2>
</br>
</center>
<?php
require "phpScripts/connect.php";
$startDate = $_GET['startDate'];
$endDate = $_GET['endDate'];
$sql = "SELECT * FROM orderlist WHERE NOT (dateOrdered < '$startDate' OR dateOrdered > '$endDate');";
$result = $conn->query($sql);
echo "<center>";
echo "<ul>";
if($result->num_rows >0)
{
$i = 0;
while($row = $result->fetch_assoc()) // this loads selected drinks via date
into ul
{
echo "<li style=
'margin-left: 0;
list-style-type: none;
color: #727272;
height: 40px;
font-size: 15px;
font-family: Open Sans;
border-style: none;
width: 50%;
list-style-type: none;
margin:0;
padding-bottom:0px;
padding:0;
overflow: hidden;'>
Drink: ".$row["drinkName"]. ", Date Ordered: " .$row["dateOrdered"] . ",
Cost: " .$row["drinkCost"] . "</li>";
$i = $i+1;
}
}else {
echo "<p> No orders found. </p>";
}
echo "</ul>";
echo "</center>";
?>
</div>
这是一个基本示例，说明如果您使用 TCPDF 会是什么样
子。<?php
$pdf = new TCPDF(PDF_PAGE_ORIENTATION_L, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);
//TCPDF_INIT_CODE_GOES_HERE
// ...
$html = '<!DOCTYPE HTML>
<script
src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.2/jquery.min.js">
</script>
<!-- allow login page to link to this when user is an admin -->
<title>Report</title>
<link rel="stylesheet" type="text/css" href="styles.css">
<link rel="manifest" href="/manifest.json">
<center><img src="icons/sbuxLogo.png" width="100" height="100px"></center>
</br></br>
<center><h1>Welcome Administrator!</h1></center>
</br></br>
<center>
<div id="report">
<h2>Report:</h2>
</br>
</center>';
require "phpScripts/connect.php";
$startDate = $_GET['startDate'];
$endDate = $_GET['endDate'];
$sql = "SELECT * FROM orderlist WHERE NOT (dateOrdered < '$startDate' OR dateOrdered > '$endDate');";
$result = $conn->query($sql);
$html .= "<center>";
$html .= "<ul>";
if($result->num_rows >0)
{
$i = 0;
while($row = $result->fetch_assoc()) // this loads selected drinks via date
into ul
{
$html .= "<li style=
'margin-left: 0;
list-style-type: none;
color: #727272;
height: 40px;
font-size: 15px;
font-family: Open Sans;
border-style: none;
width: 50%;
list-style-type: none;
margin:0;
padding-bottom:0px;
padding:0;
overflow: hidden;'>
Drink: ".$row["drinkName"]. ", Date Ordered: " .$row["dateOrdered"] . ",
Cost: " .$row["drinkCost"] . "</li>";
$i = $i+1;
}
}else {
$html .= "<p> No orders found. </p>";
}
$html .= "</ul>";
$html .= "</center>";
$html .= '</div>';
$pdf->writeHTML($html);
$pdf->Output('TITLE_OF_PDF_FILE.pdf', 'I'); // I flag means it will display the PDF in a browser