在该页面中获得了
$packageno的值:var_dump($packageno);放在if($action == 'add')的括号外面有结果。结果:string(12) "CVT110822002"
if($action == 'add')
{
var_dump($packageno);//无结果
$sql = "INSERT INTO `".$t."` (`username`,`packageno`,`lotno`,`description`,`barcode`,`date`)";
$sql .= "VALUES ('".$_SESSION['barcode_Account']."','".$packageno."','".$lotno."','CVT','".$_POST['barcode']."','".$date."') where `packageno`='".$packageno."'";
echo $sql;
}
现在的结果:
INSERT INTO `barcode_2d` (`username`,`packageno`,`lotno`,`description`,`barcode`,`date`)VALUES ('00868','','10906','CVT','KAETC56-600NC1161656600N31036 KA62A0002','2011-09-06 16:19:14') where `packageno`='' 请问如何能把值带进这个括号呢?
$packageno的值:var_dump($packageno);放在if($action == 'add')的括号外面有结果。结果:string(12) "CVT110822002"
if($action == 'add')
{
var_dump($packageno);//无结果
$sql = "INSERT INTO `".$t."` (`username`,`packageno`,`lotno`,`description`,`barcode`,`date`)";
$sql .= "VALUES ('".$_SESSION['barcode_Account']."','".$packageno."','".$lotno."','CVT','".$_POST['barcode']."','".$date."') where `packageno`='".$packageno."'";
echo $sql;
}
现在的结果:
INSERT INTO `barcode_2d` (`username`,`packageno`,`lotno`,`description`,`barcode`,`date`)VALUES ('00868','','10906','CVT','KAETC56-600NC1161656600N31036 KA62A0002','2011-09-06 16:19:14') where `packageno`='' 请问如何能把值带进这个括号呢?
//if ()
include('checklogin.php');
include('conn.php');
require('inc.php');
$action = $_GET['action'];
// var_dump($action);
$t = 'barcode_2d';
$packageno = $_GET['packageno'];
date_default_timezone_set(PRC);
?>
<?php if($action == '')
{
echo '<div id="panelTitle">新增补数据</div><br />';
echo '<form name="formEditItem" method="post" action="fillin.php?action=add">
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#B0C5FF">
<tr>
<th bgColor=#cedcff height=20 align="left"> Item</th>
<th bgColor=#cedcff height=20 align="left"> Value</th>
</tr>';
$sql = "SELECT `packageno`,`barcode` FROM `".$t."` where `packageno`= '".$packageno."'";
// echo $sql;
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
for ($i=1; $i < mysql_num_fields($result); $i++)
{
echo '<tr class="cells" onmouseover="this.className=\'cells2\'" onmouseout="this.className=\'cells\'">';
// echo '<td align="left">'.mysql_field_name($result, $i).'</td>';
if($i==1)
echo '<td width=200 align="left">'."Barcode二维码".'</td>';
echo '<td align="left"> <input type="text" value="" name="'.mysql_field_name($result, $i).'" size="80" onMouseOver="this.focus()" /></td>';
echo '</tr>';
}
echo '</table><br />
<input name="btnEditOK" type="submit" title="Submit" class="btnbig" value="提交" onclick="javascript:submit();" onmouseover="this.className=\'btnbig_over\'" onMouseOut="this.className=\'btnbig\'" onMouseDown="this.className=\'btnbig_down\'" onMouseUp="this.className=\'btnbig\'" />
<input name="btnEditReset" type="reset" title="Drop and Reset" class="btnbig" value="重置" onmouseover="this.className=\'btnbig_over\'" onMouseOut="this.className=\'btnbig\'" onMouseDown="this.className=\'btnbig_down\'" onMouseUp="this.className=\'btnbig\'" /></form>';
}
// var_dump($packageno);
// echo "a".$action."b";
if($action == 'add')
{
$date = date('Y-m-d H:i:s');
$lotno = preg_replace("/(\d{1})(\d{2})(\d{2})/e", "'$1'.($2<'10'?'$2':chr($2+78)).'$3'",substr(date('ymd'), 1));
$sql = "INSERT INTO `".$t."` (`username`,`packageno`,`lotno`,`description`,`barcode`,`date`)";
$sql .= "VALUES ('".$_SESSION['barcode_Account']."','".$packageno."','".$lotno."','CVT','".$_POST['barcode']."','".$date."') where
`packageno`='".$packageno."'";
echo $sql;
if($_POST['barcode'] == "")
{
echo "<Script language='JavaScript'> alert('请确保数据不为空!');</Script>";
echo "<script>location.href='fillin.php?packageno='".$row['packageno']."'</script>";
}
else
{
// $result = mysql_query($sql);
// echo "<Script language='JavaScript'> alert('已完成!');</Script>";
// echo "<script>location.href='fillin.php?packageno=".$_POST['packageno']."</script>"; mysql_free_result($result);
mysql_close($con);
}
}
?>
echo '<font size=2><b>可能需要补货的产品:</b></font>';
$sql = "select `packageno`,count(*) from `".$t."` group by `packageno` having count(*)<16";
//echo $sql;
$result = mysql_query($sql);
while($row = mysql_fetch_array($result,MYSQL_ASSOC))
{
$packageno = $row['packageno'];//获得$packageno
// var_dump($packageno);
echo '<a href="fillin.php?packageno='.$row['packageno'].'"><font size=3><strong>'.$row['packageno'].'</strong></font></a> ';
}
?>
<hr />
<?php
$sql2 = "select * from `".$t."` where `packageno`='".$packageno."'";//带进来的值不对了echo $sql2;
$result =mysql_query($sql2);
?>我找到问题所在了。这样只显示一个$packageno的数据,其他的不显示。如何能在$sql2让它显示出来。请问这样如何修改?
http://127.0.0.1:9090/new/fillin.php?packageno=CVT110822002但是$sql2结果:
select * from `barcode_2d` where `packageno`='CVT110906001'修改哪里能变成
select * from `barcode_2d` where `packageno`='CVT110822002'
include('checklogin.php');
include('conn.php');
require('inc.php');
$action = $_GET['action'];
$t = 'barcode_2d';
date_default_timezone_set(PRC);
?><!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=gb2312" />
<link rel="stylesheet" href="css/default.css" type="text/css" media="all" />
<link rel="stylesheet" href="css/table.css" type="text/css" media="all" />
<link rel="stylesheet" href="css/btn.css" type="text/css" media="all" /><title>aaa</title></head>
<body>
<div id="tabs">
<ul>
<li><a href="scq.php" ><span class="cur">生产区</span></a></li>
<li><a href="zcq.php" ><span>暂存区(品证)</span></a></li>
<li><a href="total.php" ><span>按日统计</span></a></li>
<li><a href="weektotal.php" ><span>按周统计</span></a></li>
<li><a href="monthtotal.php" ><span>按月统计</span></a></li>
<li><a href="user-admin.php" ><span>用户设置</span></a></li>
<li><a href="logout.php" ><span>退出</span></a></li>
</ul>
</div>
<br />
<br />
<hr >
<img src="img/bg_logo.jpg" align="left" width=130 height=52 border="0" />
<br />
<th><font size="5" color="#333399"><center><b>产品补货区</b></center></font></th>
<br /><hr /><br />
<table border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#B0C5FF">
<?php
echo '<font size=2><b>可能需要补货的产品:</b></font>';
$sql = "select `packageno`,count(*) from `".$t."` group by `packageno` having count(*)<16";
//echo $sql;
$result = mysql_query($sql);
while($row = mysql_fetch_array($result,MYSQL_ASSOC))
{
$_GET['packageno'] = $row['packageno']; echo '<a href="fillin.php?packageno='.$row['packageno'].'"><font size=3><strong>'.$row['packageno'].'</strong></font></a> ';
}
var_dump($packageno);
?>
<hr />
<?php
$sql2 = "select * from `".$t."` where `packageno`='".$packageno."'";
echo $sql2;
$result =mysql_query($sql2);?>
<tr>
<th><font color=blue>扫描员工号</font></th>
<th><font color=blue>生产箱号</font></th>
<th><font color=blue>LotNo</font></th>
<th><font color=blue>品名</font></th>
<th><font color=blue>二维BarCode条形码</font></th>
<th><font color=blue>生产日期</font></th>
</tr>
<?php
$totalRows = mysql_num_rows($result);
$totalFields = mysql_num_fields($result);for ( $i = 0; $i < $totalRows; ++$i )
{
$results[$i] = mysql_fetch_array($result);
//print_r($results[$i]);
for ( $k = 1; $k < 7; ++$k)
$is_re[$i][$k] = 1;
}
for ( $i = 0; $i < $totalRows; ++$i )
{
for ( $k = 0; $k < 1; ++$k)
{
if($is_re[$i][$k] == 0)
continue;
for ( $j = $i + 1; $j <= $totalRows; ++$j )
{
$is_re_tmp = TRUE; // 比当前列靠前的列都要相同,才认为此列是相同的
for( $m = 1; $m <= $k; ++$m)
{
if ((strtolower(trim($results[$i][$m])) != strtolower(trim($results[$j][$m]))))
$is_re_tmp = FALSE;
}
if ($is_re_tmp)
{
++$is_re[$i][$k];
$is_re[$j][$k] = 0;
}
else
{
break;
}
}
}
}
for ( $i = 0; $i < $totalRows; ++$i )
{
$row = $results[$i];
//print_r($row);
echo '<tr class="cells" onmouseover="this.className=\'cells2\'" onmouseout="this.className=\'cells\'">';
// echo '<td><center><font size=2>'.$row['0'].'</font></center></td>'; for ( $k = 0; $k < 7; ++$k)
{
if ($is_re[$i][$k] > 0)
{
if($k < 7)
echo '<td rowspan="'.$is_re[$i][$k].'"><center><font size=2>'.$row[$k].'</font></center></td>';
if($k == 0)
{
if($row[$k] == '0')
echo '<td rowspan="'.$is_re[$i][$k].'"><center><font size=2> N/A </font></center></td>';
else
echo '<td rowspan="'.$is_re[$i][$k].'"><center><font size=2>'.$row[$k].'</font></center></td>';
}
}
}
// echo '<td><a title="修改此项" href="expend_edit.php?id='.$row['id'].'"><img src="img/b_edit.png" border="0" /></a></td>';
//echo '<td><a title="Del this item" href="#" onclick="javascript:goDelete('.$row['ID'].');"><img src="img/b_drop.png" border="0" /></a></td>';
echo "</tr>";
}
?>
</table><br />
<hr />
<?php if($action == '')
{
echo '<div id="panelTitle">新增补数据</div><br />';
echo '<form name="formEditItem" method="post" action="fillin.php?action=add">
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#B0C5FF">
<tr>
<th bgColor=#cedcff height=20 align="left"> Item</th>
<th bgColor=#cedcff height=20 align="left"> Value</th>
</tr>';
$sql = "SELECT `packageno`,`barcode` FROM `".$t."` where `packageno`= '".$packageno."'";
echo $sql;
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
for ($i=1; $i < mysql_num_fields($result); $i++)
{
echo '<tr class="cells" onmouseover="this.className=\'cells2\'" onmouseout="this.className=\'cells\'">';
// echo '<td align="left">'.mysql_field_name($result, $i).'</td>';
if($i==1)
echo '<td width=200 align="left">'."Barcode二维码".'</td>';
echo '<td align="left"> <input type="text" value="" name="'.mysql_field_name($result, $i).'" size="80" onMouseOver="this.focus()" /></td>';
echo '</tr>';
}
echo '</table><br />
<input name="btnEditOK" type="submit" title="Submit" class="btnbig" value="提交" onclick="javascript:submit();" onmouseover="this.className=\'btnbig_over\'" onMouseOut="this.className=\'btnbig\'" onMouseDown="this.className=\'btnbig_down\'" onMouseUp="this.className=\'btnbig\'" />
<input name="btnEditReset" type="reset" title="Drop and Reset" class="btnbig" value="重置" onmouseover="this.className=\'btnbig_over\'" onMouseOut="this.className=\'btnbig\'" onMouseDown="this.className=\'btnbig_down\'" onMouseUp="this.className=\'btnbig\'" /></form>';
}
// echo "a ".$action." b";
if($action == 'add')
{
$date = date('Y-m-d H:i:s');
$lotno = preg_replace("/(\d{1})(\d{2})(\d{2})/e", "'$1'.($2<'10'?'$2':chr($2+78)).'$3'",substr(date('ymd'), 1));
$sql = "INSERT INTO `".$t."` (`username`,`packageno`,`lotno`,`description`,`barcode`,`date`)";
$sql .= "VALUES ('".$_SESSION['barcode_Account']."','".$_GET['packageno']."','".$lotno."','CVT','".$_POST['barcode']."','".$date."') where
`packageno`='".$_GET['packageno']."'";
echo $sql;
if($_POST['barcode'] == "")
{
echo "<Script language='JavaScript'> alert('请确保数据不为空!');</Script>";
echo "<script>location.href='fillin.php?packageno='".$row['packageno']."'</script>";
}
else
{
// $result = mysql_query($sql);
// echo "<Script language='JavaScript'> alert('已完成!');</Script>";
// echo "<script>location.href='fillin.php?packageno=".$_POST['packageno']."</script>"; mysql_free_result($result);
mysql_close($con);
}
}
?>
</body>
</html>