我的后面代码如下:
//连接数据库
include("common/conn.php");
$id = $_GET['id'];
//计算合同到期天数
$sql = "SELECT contractdata from employeelist";
$result = mysqli_query($conn,$sql);
//$row = mysqli_fetch_assoc($result);
$diff_days = array();
$i = 0;
while ($rowl = mysqli_fetch_assoc($result)){
$diff_days = "";
$contractdata=$rowl['contractdata'];
$time1=strtotime($contractdata);
$now = time();
$diff_seconds = $time1-$now;
$diff_days[$i] = floor($diff_seconds/86400);
//$diffsql = "update employeelist set diffday='$diff_days' where id = '$id';";
//$result = mysqli_query($conn,$diffsql);
//echo $diff_days[$i];
}
页面输出代码如下:
<table>
<tr>
<th style="width: 60px;">状态</th>
<th style="width: 120px;">姓名</th>
<th style="width: 60px;">性别</th>
<th style="width: 60px;">年龄</th>
<th>合同签订时间</th>
<th>合同到期时间</th>
<th>合同到期天数</th>
</tr>
<?php while ($row = mysqli_fetch_assoc($rs_result)) {?>
<tr>
<td class='s-show'>
<?php echo $row['state'];?>
</td>
<td>
<?php echo $row['name'];?>
</td>
<td>
<?php echo $row['gender'];?>
</td>
<td>
<?php echo $row['age'];?>
</td>
<td>
</td>
<td>
<?php echo $row['hiredate'];?>
</td>
<td>
<?php echo $row['contractdata'];?>
<td>
<?php echo $diff_days[$i];?>
</td>
<td class='s-act'>
<a href="javascript:edit(<?php echo $row['id']?>)" class="jq-edit">编辑</a><a href=" javascript:del(<?php echo $row[ 'id']?>)" class="jq-del ">删除</a><a href="javascript:check(<?php echo $row[ 'id']?>)">查看详情</a>
</td>
</tr>
<?php }; ?>
最后显示结果:
求大神帮忙看看......