php - 在要邮寄的表格上显示前导零
问题描述
我创建了一个将值插入数据库的表单,这些值也通过电子邮件发送。
这是问题所在:
首先,这是我的数据库架构:
如您所见,我有一个名为的列trackingcode
,其属性为unsigned zerofill
001、002、003trackingcode
等值也是如此......
问题是当它通过电子邮件发送时,它只读取整数,如 1、2、3 等等......
是否也可以在电子邮件上显示零?
这是发送到电子邮件的代码:
<?php
//insert.php
$connect = mysqli_connect("localhost", "root", "", "pcrequest");
if(isset($_POST["reqname"]))
{
$req_date = $_POST["req_date"];
$reqname = $_POST["reqname"];
$date = $_POST["date"];
$empname = $_POST["empname"];
$position = $_POST["position"];
$account = $_POST["account"];
$platform = $_POST["platform"];
$processor = $_POST["processor"];
$ram = $_POST["ram"];
$monitor = $_POST["monitor"];
$phone = $_POST["phone"];
$phonetype = $_POST["phonetype"];
$headset = $_POST["headset"];
$req_table = $_POST["req_table"];
$req_chair = $_POST["req_chair"];
$approval = $_POST["approval"];
$status = $_POST["status"];
$query = '';
for($count = 0; $count<count($reqname); $count++)
{
$req_date_clean = mysqli_real_escape_string($connect, $req_date[$count]);
$reqname_clean = mysqli_real_escape_string($connect, $reqname[$count]);
$date_clean = mysqli_real_escape_string($connect, $date[$count]);
$empname_clean = mysqli_real_escape_string($connect, $empname[$count]);
$position_clean = mysqli_real_escape_string($connect, $position[$count]);
$account_clean = mysqli_real_escape_string($connect, $account[$count]);
$platform_clean = mysqli_real_escape_string($connect, $platform[$count]);
$processor_clean = mysqli_real_escape_string($connect, $processor[$count]);
$ram_clean = mysqli_real_escape_string($connect, $ram[$count]);
$monitor_clean = mysqli_real_escape_string($connect, $monitor[$count]);
$phone_clean = mysqli_real_escape_string($connect, $phone[$count]);
$phonetype_clean = mysqli_real_escape_string($connect, $phonetype[$count]);
$headset_clean = mysqli_real_escape_string($connect, $headset[$count]);
$req_table_clean = mysqli_real_escape_string($connect, $req_table[$count]);
$req_chair_clean = mysqli_real_escape_string($connect, $req_chair[$count]);
$approval_clean = mysqli_real_escape_string($connect, $approval[$count]);
$status_clean = mysqli_real_escape_string($connect, $status[$count]);
if($req_date_clean != '' && $reqname_clean != '' && $date_clean != '' && $empname_clean != '' && $position_clean != '' && $account_clean != '' && $platform_clean != '' && $processor_clean != '' && $ram_clean != '' && $monitor_clean != '' && $phone_clean != '' && $phonetype_clean != '' && $headset_clean != '' && $req_table_clean != '' && $req_chair_clean != '' && $approval_clean != '' && $status_clean != '')
{
$trackingQuery = mysqli_query($connect,"SELECT Max(trackingcode) as maxtrack FROM `request`");
if( mysqli_num_rows($trackingQuery) > 0)
{
$newtracking = mysqli_fetch_assoc($trackingQuery)['maxtrack'] + 1 ;
}
else{
$newtracking = 1;
}
$query .= '
INSERT INTO request(trackingcode, req_date, reqname, date, empname, position, account, platform, processor, ram, monitor, phone, phonetype, headset, req_table, req_chair, approval, status)
VALUES("'.$newtracking.'", "'.$req_date_clean.'", "'.$reqname_clean.'", "'.$date_clean.'", "'.$empname_clean.'", "'.$position_clean.'", "'.$account_clean.'", "'.$platform_clean.'", "'.$processor_clean.'", "'.$ram_clean.'", "'.$monitor_clean.'", "'.$phone_clean.'", "'.$phonetype_clean.'", "'.$headset_clean.'", "'.$req_table_clean.'", "'.$req_chair_clean.'", "'.$approval_clean.'", "'.$status_clean.'");
';
}
$email_from = "PC Request";//<== update the email address
$email_subject = "PC Request for $account_clean";
$message = '<html><body>';
$message .= '<h1>Hello, World!</h1>';
$message .= '</body></html>';
$message = '<html><body>';
$message .= "<tr><td>Good morning,</td></tr>";
$message .= "<br>";
$message .= "<br>";
$message .= "<tr><td>Here are the specifications:</td></tr>";
$message .= "<br>";
$message .= "<br>";
$message .= '<table rules="all" style="border-color: #666;" cellpadding="5">';
$message .= "<tr style='background: #FFFFFF;'><td><strong>Tracking Code</strong> </td><td style='color:blue;'> TS" . $newtracking . "</td></tr>";
$message .= "<tr style='background: #CDD9FF;'><td><strong>Requested by</strong> </td><td>" . $req_date_clean = mysqli_real_escape_string($connect, $req_date[$count]) . "</td></tr>";
$message .= "<tr style='background: #FFFFFF;'><td><strong>Requested by</strong> </td><td>" . $reqname_clean = mysqli_real_escape_string($connect, $reqname[$count]) . "</td></tr>";
$message .= "<tr style='background: #CDD9FF;'><td><strong>Start Date</strong> </td><td>" . $date_clean = mysqli_real_escape_string($connect, $date[$count]) . "</td></tr>";
$message .= "<tr style='background: #FFFFFF;'><td><strong>Employee Name</strong> </td><td>" . $empname_clean = mysqli_real_escape_string($connect, $empname[$count]) . "</td></tr>";
$message .= "<tr style='background: #CDD9FF;'><td><strong>Position</strong> </td><td>" . $position_clean = mysqli_real_escape_string($connect, $position[$count]) . "</td></tr>";
$message .= "<tr style='background: #FFFFFF;'><td><strong>Account</strong> </td><td>" . $account_clean = mysqli_real_escape_string($connect, $account[$count]) . "</td></tr>";
$message .= "<tr style='background: #CDD9FF;'><td><strong>Platform</strong> </td><td>" . $platform_clean = mysqli_real_escape_string($connect, $platform[$count]) . "</td></tr>";
$message .= "<tr style='background: #FFFFFF;'><td><strong>Processor</strong> </td><td>" . $processor_clean = mysqli_real_escape_string($connect, $processor[$count]) . "</td></tr>";
$message .= "<tr style='background: #CDD9FF;'><td><strong>RAM</strong> </td><td>" . $ram_clean = mysqli_real_escape_string($connect, $ram[$count]) . "</td></tr>";
$message .= "<tr style='background: #FFFFFF;'><td><strong>Monitor</strong> </td><td>" . $monitor_clean = mysqli_real_escape_string($connect, $monitor[$count]) . "</td></tr>";
$message .= "<tr style='background: #CDD9FF;'><td><strong>Phone</strong> </td><td>" . $phone_clean = mysqli_real_escape_string($connect, $phone[$count]) . "</td></tr>";
$message .= "<tr style='background: #FFFFFF;'><td><strong>Phone Type</strong> </td><td>" . $phonetype_clean = mysqli_real_escape_string($connect, $phonetype[$count]) . "</td></tr>";
$message .= "<tr style='background: #CDD9FF;'><td><strong>Headset</strong> </td><td>" . $headset_clean = mysqli_real_escape_string($connect, $headset[$count]) . "</td></tr>";
$message .= "<tr style='background: #FFFFFF;'><td><strong>Table</strong> </td><td>" . $req_table_clean = mysqli_real_escape_string($connect, $req_table[$count]) . "</td></tr>";
$message .= "<tr style='background: #CDD9FF;'><td><strong>Chair</strong> </td><td>" . $req_chair_clean = mysqli_real_escape_string($connect, $req_chair[$count]) . "</td></tr>";
$message .= "<tr style='background: #FFFFFF;'><td><strong>For Approval</strong> </td><td><a href='teamspan.com/core/pcrequest/messages-admin.php'>Click Here!</a></td></tr>";
$message .= "</table>";
$message .= "</body></html>";
$to = "renzostack@gmail.com";//<== update the email address
$headers = "From: $email_from \r\n";
$headers .= "MIME-Version: 1.0\r\n";
$headers .= "Content-Type: text/html; charset=ISO-8859-1\r\n";
//$headers .= "Reply-To: $visitor_email \r\n";
//Send the email!
mail($to,$email_subject,$message, $headers);
}
if($query != '')
{
if(mysqli_multi_query($connect, $query))
{
echo 'Successfuly Sent!';
}
else
{
echo 'Error';
}
}
else
{
echo 'All fields are required!';
}
}
?>
解决方案
也许你应该看看 sprintf [1]
$number = 2;
echo sprintf("%03d", $number); // 002
推荐阅读
- javascript - 如何将 HTML 代码转换为 JSON 对象?
- google-cloud-firestore - Firestore 安全规则和自定义声明 - 可以使用覆盖它们吗?
- c++ - 回溯功能 - 仅显示以字母 a 开头和结尾的单词
- python - 子类化小部件以覆盖方法,同时保留原始方法功能
- django - 当我单击 bms_homepage.html 中的登录按钮时,为什么“找不到页面”?
- laravel - Laravel 500 | UBUNTU 16.04 上的服务器错误
- mysql - 包含相同列的两个表..想要从一个表中检索信息
- python - tensorflow 2.0 中是否有 cudnnLSTM 或 cudNNGRU 替代方案
- typo3 - Typo3 Fluid 在前端呈现 html 而不是将 html 包含到主页中
- javascript - 使用 React 进行表单验证