Update查询是这样的,我在更新记录中获得了成功,但是当记录更新后的整个文本框值填写在文本框中时,它不会在页面中重定向,我希望在当前页面上重定向用户,但不使用最后更新的值在空白页上重定向。
if(isset($_REQUEST['submit']) && $vepariId > 0)
{
$update = "UPDATE vepari
SET partyId = ".$_REQUEST['partyId'].",
vDate = '".$vDate."',
veTransType = '".$_REQUEST['veTransType']."',
vParti = '".$_REQUEST['vParti']."',
vRate = ".$_REQUEST['vRate'].",
vDiff = '".$_REQUEST['vDiff']."',
vDiffAmt = ".$_REQUEST['vDiffAmt'].",
vTotal = ".$_REQUEST['vTotal'].",
vTax = ".$_REQUEST['vTax'].",
vkg = ".$_REQUEST['vkg'].",
vTotalAmt = ".$_REQUEST['vTotalAmt']."
WHERE vepariId = ".$vepariId;
$updateRes= mysql_query($update);
if($updateRes)
{
if($veTransType == 'A')
{
$update = "UPDATE mcx
SET
partyId = ".$partyId.",
transDate = '".$vDate."',
transType = 'J',
rate = '".$_REQUEST['vRate']."',
kg = '".$_REQUEST['vkg']."',
totalAmt = '".$_REQUEST['vTotalAmt']."'
WHERE vepariId = ".$vepariId;
$updateRes = mysql_query($update);
if(!$updateRes)
{
echo "Mcx Update Fail";
}
}
else
{
$update = "UPDATE mcx
SET
partyId = ".$partyId.",
transDate = '".$vDate."',
transType = 'A',
rate = '".$_REQUEST['vRate']."',
kg = '".$_REQUEST['vkg']."',
totalAmt = '".$_REQUEST['vTotalAmt']."'
WHERE vepariId = ".$vepariId;
$updateRes = mysql_query($update);
if(!$updateRes)
{
echo "Mcx Aavak Update Fail";
}
else
{
header("Location:vepari.php");
}
}
}
}发布于 2015-06-16 06:39:05
我做了一些修改,请看一下。请记住,当您在页眉前使用回显时,当您在页面中打印某些内容时,最好使用javascript重定向,比如window.location.href。
if(isset($_REQUEST['submit']) && $vepariId > 0)
{
$update = "UPDATE vepari
SET partyId = ".$_REQUEST['partyId'].",
vDate = '".$vDate."',
veTransType = '".$_REQUEST['veTransType']."',
vParti = '".$_REQUEST['vParti']."',
vRate = ".$_REQUEST['vRate'].",
vDiff = '".$_REQUEST['vDiff']."',
vDiffAmt = ".$_REQUEST['vDiffAmt'].",
vTotal = ".$_REQUEST['vTotal'].",
vTax = ".$_REQUEST['vTax'].",
vkg = ".$_REQUEST['vkg'].",
vTotalAmt = ".$_REQUEST['vTotalAmt']."
WHERE vepariId = ".$vepariId;
$updateRes= mysql_query($update);
if($updateRes)
{
if($veTransType == 'A')
{
$update = "UPDATE mcx
SET
partyId = ".$partyId.",
transDate = '".$vDate."',
transType = 'J',
rate = '".$_REQUEST['vRate']."',
kg = '".$_REQUEST['vkg']."',
totalAmt = '".$_REQUEST['vTotalAmt']."'
WHERE vepariId = ".$vepariId;
$updateRes = mysql_query($update);
if(!$updateRes)
{
echo "Mcx Update Fail";
exit;
}
}
else
{
$update = "UPDATE mcx
SET
partyId = ".$partyId.",
transDate = '".$vDate."',
transType = 'A',
rate = '".$_REQUEST['vRate']."',
kg = '".$_REQUEST['vkg']."',
totalAmt = '".$_REQUEST['vTotalAmt']."'
WHERE vepariId = ".$vepariId;
$updateRes = mysql_query($update);
if(!$updateRes)
{
echo "Mcx Aavak Update Fail";
exit;
}
else
{
header("Location:vepari.php");
}
}
}
}
https://stackoverflow.com/questions/30859998
复制相似问题