老师。我想取出数据库中的时间戳，但为什么取不出来。求解
代码
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>裁床</title>
<link rel="stylesheet" href="css/cccss.css" />
<?php
header('content-type:text/html;charset=utf-8');
date_default_timezone_set('PRC');
//post不为空就执行php代码
if(!empty($_POST)){
//获取变量
$jj =$_POST['jj'];
$nee =$_POST['nee'];
$kh =$_POST['kh'];
$csz =$_POST['csz'];
$q1=define(1,2,3);
$q2=define(4,5,6);
$q3=define(7,8,9);
$q4=define(10.11,12);
//给变量$jj赋值
if($jj==="Q1"){
$jj=$q1;
}else if($jj==="Q2"){
$jj=$q2;
}else if($jj==="Q3"){
$jj=$q3;
}else if($jj==="Q2"){
$jj=$q4;
}
//数据库链接
$conn=mysqli_connect('127.0.0.1', 'root', 'root','hr_shuj');
mysqli_query($conn, 'set names utf8');
//读取数据库的数据
$sql="SELECT * FROM `hr_shuju`;";
$result= mysqli_query($conn, $sql);
$data= mysqli_fetch_all($result, MYSQLI_ASSOC);
while($data){
$rows[]=$data;
}
foreach( $rows as $MiningTime ){
echo $MiningTime;
}
}
?>
</head>
<body>
<div class="box">
<img src="img/logo.jpg" />
<div class="box-a">
<div class="d">
<ul >
<li>登录</li>
<li>注册</li>
</ul>
</div>
<div class="sous">
<input type="text" autocomplete="off" id="kw" class="i" name="word" placeholder="信息" />
<input type="submit" log-click="p=5.41&" class="sb" value="搜索"/>
</div>
</div>
<div class="maii">
<ul>
<li>
<a href="/cg.html">采购订单</a>
</li>
<li >
<a href="/ml.html">面料管理</a>
</li>
<li >
<a href="/mf.html">面辅料收货管理</a>
</li>
<li id="u2" class="u2">
<a href="/ccbb.html">生产计划进度报表</a>
<ul>
<li><a href="/cc.html">裁床</a></li>
<li><a href="/ccbb.html">生产</a></li>
<li><a href="/ccbb.html">后道</a></li>
</ul>
</li>
</ul>
</div>
<div class="v">
<p style="margin-top:15px;">生产计划进度报表</p>
<div class="g">
<p>查询条件</p>
</div>
<div>
<form action="cc.php" method="post">
<table>
<tr>
<td class="xz">年份：</td>
<td>
<select class="sl" name="nee">
<option>2018</option>
<option>2019</option>
<option>2020</option>
<option>2021</option>
</select>
</td>
</tr>
<tr>
<td class="xz">季节：</td>
<td>
<select class="sl" name="jj">
<option>Q1</option>
<option>Q2</option>
<option>Q3</option>
<option>Q4</option>
</select>
</td>
</tr>
<tr>
<td class="xz">款号：</td>
<td><input type="text"" placeholder="请输入采购款号" name="kh" /></td>
</tr>
<tr>
<td class="xz">生产组：</td>
<td><input type="text" placeholder="请输入生产组" name="csz"/></td>
</tr>
<div class="hj">
<div class="chax"><button>查询</button></div>
<div class="xiaz"><button>下载</button></div>
</div>
</table>
</form>
</div>
</div>
<div class="bg">
<table class="kf">
<tr class="kk">
<th>款号</th>
<th>开采时间</th>
<th>床号</th>
<th>生产组</th>
<th>面料</th>
<th>色别</th>
<th>规格</th>
<th>层数</th>
<th>裁剪员</th>
<th>编号员</th>
<th>查货员</th>
</tr>
<tr>
<td>1</td>
<td>2</td>
<td>3</td>
<td>4</td>
<td>5</td>
<td>6</td>
<td>7</td>
<td>8</td>
<td>9</td>
<td>10</td>
<td>11</td>
</tr>
</table>
</div>
</div>
<script type="text/javascript" src="js/nav_submenu.js"></script>
</html>
数据库里的数据
array(7) { [0]=> array(11) { ["Money"]=> string(3) "123" ["MiningTime"]=> string(10) "1524814170" ["BedNumber"]=> string(2) "20" ["Mone"]=> string(3) "123" ["Fabric"]=> string(3) "厚" ["ColorDifference"]=> string(3) "红" ["Specifications"]=> string(2) "33" ["NumberofLayers"]=> string(3) "120" ["cut"]=> string(6) "张三" ["Numbered"]=> string(6) "李四" ["Lookup"]=> string(6) "王五" } [1]=> array(11) { ["Money"]=> string(3) "123" ["MiningTime"]=> string(10) "1524814282" ["BedNumber"]=> string(2) "20" ["Mone"]=> string(3) "123" ["Fabric"]=> string(3) "厚" ["ColorDifference"]=> string(3) "红" ["Specifications"]=> string(2) "33" ["NumberofLayers"]=> string(3) "120" ["cut"]=> string(6) "张三" ["Numbered"]=> string(6) "李四" ["Lookup"]=> string(6) "王五" } [2]=> array(11) { ["Money"]=> string(2) "12" ["MiningTime"]=> string(10) "1524879933" ["BedNumber"]=> string(2) "14" ["Mone"]=> string(1) "4" ["Fabric"]=> string(3) "厚" ["ColorDifference"]=> string(3) "红" ["Specifications"]=> string(2) "25" ["NumberofLayers"]=> string(3) "120" ["cut"]=> string(6) "张成" ["Numbered"]=> string(6) "李四" ["Lookup"]=> string(6) "王五" } [3]=> array(11) { ["Money"]=> string(2) "12" ["MiningTime"]=> string(10) "1524879945" ["BedNumber"]=> string(2) "14" ["Mone"]=> string(1) "4" ["Fabric"]=> string(3) "厚" ["ColorDifference"]=> string(3) "红" ["Specifications"]=> string(2) "25" ["NumberofLayers"]=> string(3) "120" ["cut"]=> string(6) "张成" ["Numbered"]=> string(6) "李四" ["Lookup"]=> string(6) "王五" } [4]=> array(11) { ["Money"]=> string(2) "12" ["MiningTime"]=> string(10) "1524881104" ["BedNumber"]=> string(2) "14" ["Mone"]=> string(1) "4" ["Fabric"]=> string(3) "厚" ["ColorDifference"]=> string(3) "红" ["Specifications"]=> string(2) "25" ["NumberofLayers"]=> string(3) "120" ["cut"]=> string(6) "张成" ["Numbered"]=> string(6) "李四" ["Lookup"]=> string(3) "王" } [5]=> array(11) { ["Money"]=> string(1) "0" ["MiningTime"]=> string(10) "1524908550" ["BedNumber"]=> string(1) "0" ["Mone"]=> string(1) "0" ["Fabric"]=> string(0) "" ["ColorDifference"]=> string(0) "" ["Specifications"]=> string(0) "" ["NumberofLayers"]=> string(0) "" ["cut"]=> string(0) "" ["Numbered"]=> string(0) "" ["Lookup"]=> string(0) "" } [6]=> array(11) { ["Money"]=> string(2) "12" ["MiningTime"]=> string(10) "1524908677" ["BedNumber"]=> string(1) "0" ["Mone"]=> string(1) "0" ["Fabric"]=> string(0) "" ["ColorDifference"]=> string(0) "" ["Specifications"]=> string(0) "" ["NumberofLayers"]=> string(0) "" ["cut"]=> string(0) "" ["Numbered"]=> string(0) "" ["Lookup"]=> string(0) "" } }
正在回答
您好，如果您的时间戳在数据库中是存入在字段中的，您可以直接获取字段的数据。祝学习愉快！
相似问题
登录后可查看更多问答，登录/注册
恭喜解决一个难题，获得1积分~
来为老师/同学的回答评分吧
0 星