更新查询就像这样,我在更新记录中获得成功,但是当记录中更新了整个文本框的值被填充到文本框中时,它无法在页面中重定向。我要在当前页面上重定向用户,但不希望使用上次更新的值重定向到空白页。
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");
}
}
}
}
我做了一些修改,请看一下。请记住,当您在标头之前使用echo时,会引起问题,因此在打印页面中的内容时最好使用诸如window.location.href之类的javascript重定向。
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");
}
}
}
}
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句