table{
border-spacing: 0;
border-collapse: collapse;
text-align:center;
}
#nr td,#nr2 td,#nr2 th{border:1px #000000 solid;}
#nr3 td,#nr3 th{border:1px #000000 solid;}
body{background-color:#FFFFFF;}
.mytable{color:#ffffff;}
select,input{font-size:16px;}
#nr,#nr2{font-size:25px;}
#nr3{font-size:20px;}
.kuan{width:150px;height:35px;background-color:#E3E3E3;}
.kuan2{width:230;height:35px ;background-color:#E3E3E3;}
.zjtd1{background-color:#E3E3E3; width:150px;height:35px ;}
.zjtd{background-color:; width:150px;height:35px ;}
.zjtd3{background-color:#E3E3E3;height:35px ;width:150px}
.beizhu{width:150px;height:35px;border:0px}
#nr2 td{width:230px;}
#nr3 td{width:200px;}
date_default_timezone_set('Asia/Shanghai');//Asia/Shanghai
$sj=date("Y-m-d");//取得当前日期
$gq=0;
$bb=0;
if(!empty($_POST['sj'])){
$sj=$_POST['sj'];
//$sj="$sj[6]"."$sj[7]"."$sj[8]"."$sj[9]"."-"."$sj[0]"."$sj[1]"."-"."$sj[3]"."$sj[4]";
}
if(!empty($_POST['gq'])){
$gq=$_POST['gq'];
}
if(!empty($_POST['bb'])){
$bb=$_POST['bb'];
}
//echo"
$sj, $gq, ";
$sql=mysql_query("select * from $bb where gq='$gq' and sj like'$sj%' order by id desc ");
$info=mysql_fetch_array($sql);
if($info==false){
//echo"
$array
";echo "
}
elseif($bb=='zj_fzb'){
$sqlfzb=mysql_query("select * from zj_fzb inner join zj_fzb_lif on(zj_fzb.sj=zj_fzb_lif.sj and zj_fzb.gq = zj_fzb_lif.gq) where zj_fzb.gq='$gq' and zj_fzb.sj like '$sj%' order by zj_fzb.id desc limit 1");
//echo $sqlfzb;
$info=mysql_fetch_array($sqlfzb);
?>
| 查询时间: | 查询工区: | 查询报表: | 填表时间: |
| A系列工区 | 时间 | ||||||
| 槽号 | " class="userData" onclick="laydate()" style="cursor: hand;" onpropertychange="document.getElementById('canshu').submit();"/> | " class="userData" onclick="laydate()" style="cursor: hand;" onpropertychange="document.getElementById('canshu').submit();"/> | " class="userData" onclick="laydate()" style="cursor: hand;" onpropertychange="document.getElementById('canshu').submit();"/> | " class="userData" onclick="laydate()" style="cursor: hand;" onpropertychange="document.getElementById('canshu').submit();"/> | " class="userData" onclick="laydate()" style="cursor: hand;" onpropertychange="document.getElementById('canshu').submit();"/> | " class="userData" onclick="laydate()" style="cursor: hand;" onpropertychange="document.getElementById('canshu').submit();"/> | " class="userData" onclick="laydate()" style="cursor: hand;" onpropertychange="document.getElementById('canshu').submit();"/> |
}
输出来是这个表格,需要大神帮我编个码,需要点击时间查询就出对应槽号的数据,如果没有数据就空着。小弟多谢了!
Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号
时间代码也不知道哪里不对,没有日期选择呢!
,理想中应该都是这样的,但是放到里面就是不出选择日期这个框!大神求助啊!