我不知道问题出在哪里。在我点击按钮后,它只将数据放入数据库,但不会进入下一个php页面。帮我找出问题所在。非常感谢。
if(isset($_POST['btnSubmit'])){
$AddMCQ = "INSERT INTO tblmc(Name,FromDate,ToDate,Reason) VALUES('".strtoupper($_POST['txtName'])."','".$_POST['txtFrom']."','".$_POST['txtTo']."','".strtoupper($_POST['txtReason'])."')";
$AddMCResult = mysql_query($AddMCQ,$link);
header('Location: mcreport.php');
if($AddMCResult)
echo "<script>alert('Record Added.');</script>";
}
//button
<input type="submit" name="btnSubmit" id="btnSubmit" value="Submit"/>
试试这个
<?php
if(isset($_POST['btnSubmit']))
{
$txtName=$_POST['txtName'];
$txtFrom=$_POST['txtFrom'];
$txtTo=$_POST['txtTo'];
$txtReason=$_POST['txtReason'];
$AddMCQ = "INSERT INTO tblmc(Name,FromDate,ToDate,Reason) VALUES('$txtName','$txtFrom','$txtTo','$txtReason')";
$AddMCResult = mysql_query($AddMCQ,$link);
if($AddMCResult)
{
echo "<script language='"JavaScript'">'n";
echo "alert('Record Added.');'n";
echo "window.location='mcreport.php'";
echo "</script>";
}
}
?>
您的"问题"是$AddMCResult中的结果
在您使用标头之后('Location:mcreport.php')
您的脚本重定向到给定的url,$AddMCResult中的结果不再提供
因此,一个快速而肮脏的解决方案可能是
if(isset($_POST['btnSubmit'])){
$AddMCQ = "INSERT INTO tblmc(Name,FromDate,ToDate,Reason) VALUES('".strtoupper($_POST['txtName'])."','".$_POST['txtFrom']."','".$_POST['txtTo']."','".strtoupper($_POST['txtReason'])."')";
$AddMCResult = mysql_query($AddMCQ,$link);
$_SESSION['AddMCResult'] = $AddMCResult;
header('Location: mcreport.php');
}
在mcreport.php 上执行AND
if(isset($_SESSION[AddMCResult'])&$AddMCResult)
echo "<script>alert('Record Added.');</script>";
但是检查一下,session_start()在两个文件上都被调用了。。。
仔细检查表名和传递参数-从一个页面到另一个页面-请参阅获取和发布方法-
<?php
include 'config.php';
$submit="submit";
$page = $_SERVER['PHP_SELF'];
$sl_no=$_POST['sl-no'];
$f_name=$_POST['f_name'];
$l_name=$_POST['l_name'];
if($submit)
{
$sql = "INSERT INTO table_name(sl_no,f_name,l_name) values('$sl_no','$f_name','$l_name')";
$result = mysql_query($sql);
echo "Thank you! Information entered.'n";
}
else
{
echo "There Is Something Going Wrong While Insertion";
header('Location: error.php');
}
在您的header
将die()
放入之后
header('Location: mcreport.php');
die();
最好使用绝对URL。也可以使用exit()
而不是die()
。