我有一个MSSQL数据库的PHP查询。它看起来像这样:
if (isset($_POST['form6'])) {
$Title=$_POST['Title'];
$Synopsis=$_POST['Synopsis'];
$Article=$_POST['Article'];
$DateUploaded= date("Y-m-d H:i:s");
$Deleted=$_POST['Deleted'];
$myServer = "**********";
$myUser = "**********";
$myPass = "******";
$myDB = "*********";
$dbhandle = mssql_connect($myServer, $myUser, $myPass) or die("Couldn't connect to SQL Server on $myServer");
mssql_select_db($myDB) or die;
$dbTABLE = "Tablename";
$query_sql = sprintf("INSERT INTO %s (Title, Synopsis, Article, DateUploaded, Deleted) VALUES ('%s','%s','%s','%s','%s')",
addslashes($dbTABLE),
addslashes($Title),
addslashes($Synopsis),
addslashes($Article),
addslashes($DateUploaded),
addslashes($Deleted));
if ($result = mssql_query($query_sql, $dbhandle)) {
print "Your information has been successfully added to the database.";
header('Location: News.php');
}
}
?>最初它是在一个单独的.php文件中,并在表单的'动作'上执行。但是为了减少重定向的数量,我将它移动到了与表单相同的页面,并且在顶部包含if语句,以尝试让它在表单的后期执行(名为form6)。
这里是表格行:
然而,这一切似乎只是刷新页面,并没有数据被添加到数据库,它不会触发标题重定向到News.php。我也尝试过,没有采取任何行动,结果相同。我的问题是为什么不这样做,它击中了PHP函数/查询?