空白页后,按下提交按钮,所有字段填满
Blank Page after pressing Submit button with all fields filled up
如标题所示,我有一个页面供用户创建项目,另一个页面用于将其添加到数据库中。但是,当我在表单字段为空的情况下按提交时,它所提交的页面不是空白的。但是当我提交的字段填满,它只是显示是一个空白页没有任何错误,我已经通过两页的代码,但似乎找不到任何错误。也许有人能帮我一下?谢谢。
//数据提交页面的代码。
if ($_POST['projectTitle'] != "" && $_POST['projectStatus'] != "" && $_POST['projectDesc'] != "" && $_POST['projectDeliv'] != "" && $_POST['year'] != "" && $_POST['month'] != "" && $_POST['day'] != "" && $_POST['projectSS'] != "") {
$host = "localhost";
$user = "root";
$pass = "";
$db = "fyp1";
$pt = $_POST['projectTitle'];
$ps = $_POST['projectStatus'];
$pdes = $_POST['projectDesc'];
$pdel = $_POST['projectDeliv'];
$date = $_POST['year'] . "-" . $_POST['month'] . "-" . $_POST['day'];
$pss = $_POST['projectSS'];
date_default_timezone_set('UTC+8');
$cDate = date('Y-m-d');
$uid = $_SESSION['id'];
$link = mysqli_connect($host, $user, $pass, $db) or die(mysqli_error());
$query = "SELECT * FROM project WHERE project_title = $pt AND project_description = $pdes AND project_deliverables = $pdel AND project_skillset = $pss";
$dub = mysqli_query($link, $query) or die(mysqli_connect_error($link));
if (mysqli_num_rows($dub) == 0) {
$insertQ = "INSERT INTO project(project_title,project_description,project_deliverables,project_start,project_end,project_skillset,project_status)
VALUES ('$pt','$pdes','$pdeliv','$cDate','$date','$pss',$ps)";
mysqli_query($link, $insertQ) or die(mysqli_connect_error($link));
$getPID = "SELECT * FROM project WHERE project_title = $pt AND project_description = $pdes AND project_deliverables = $pdel AND project_start = $cDate AND projecct_end = $date AND project_skillset = $pss";
$pid = mysqli_query($link, $getPID) or die(mysqli_connect_error($link));
if (mysqli_num_rows($pid) == 1) {
while ($row = mysqli_fetch_array($pid)) {
$proid = $row['project_id'];
$insertF = "INSERT INTO user_has_project(user_id,project_id) VALUES ('" . $uid . "','" . $proid . "')";
mysqli_query($link,$insertF) or die(mysqli_connect_error($link));
$message = "<p>Project Successfully Added!</p>";
$message .= "<a href='index.php'>Back</a>";
$a = true;
}
} else {
$message = "<p>Project Failed To Be Added!</p>";
$message .= "<a href='createProject.php'>Back</a>";
$a = false;
}
} else {
$message = "<p>Duplicate Project Found!</p>";
$message .= "<a href='createProject.php'>Back</a>";
$a = false;
}
} else {
$message = "<p>Please Fill Up All Fields When Creating A Project!</p>";
$message .= "<a href='createProject.php'>Back</a>";
$a = false;
}
//表单
<div id="content">
<?php if ($a == false) {
?>
<h2 id="registerFont">Create Project</h2>
<form name="createProject" method="post" action="doCreateProject.php" onSubmit="return validateForm(this);">
<fieldset>
<table>
<tr>
<th colspan="4"><h2>New Project</h2></th>
</tr>
<tr>
<th colspan="4"><hr /></th>
</tr>
<tr>
<td><label for="projectTitle">Project Title:</label></td><td><input name="projectTitle" type="text" /></td>
<td><label for="projectStatus">Project Status:</label></td>
<td><select name="projectStatus">
<?php while ($row = mysqli_fetch_array($result1)) {
?>
<option value="<?php echo $row['status_id']; ?>" ><?php echo $row['status_type']; ?></option>
<?php } ?>
</select></td>
</tr>
<tr>
<td><label for="projectDesc">Project Description:</label></td><th colspan="3"><textarea name="projectDesc" rows="5" cols="40" ></textarea></th>
</tr>
<tr>
<td><label for="projectDeliv">Project Deliverables:</label></td><th colspan="3"><textarea name="projectDeliv" rows="5" cols="40" ></textarea></th>
</tr>
<tr>
<td>Start Date:</td><td><?php echo $date; ?></td>
</tr>
<tr>
<td>End Date : </td>
<th colspan="3" align="left">
<select name="year">
<option>---Year---</option>
<?php for ($i = $cYear; $i < ($cYear + 100); $i++) {
?>
<option value="<?php echo $i; ?>"><?php echo $i; ?></option>
<?php } ?>
</select>
<select name="month">
<option>---Month---</option>
<?php while ($rows = mysqli_fetch_array($result)) {
?>
<option value="<?php echo $rows['month_id']; ?>"><?php echo $rows['month']; ?></option>
<?php } ?>
</select>
<select name="day">
<option>---Day---</option>
<?php for ($i = 1; $i < 32; $i++) {
?>
<option value="<?php echo $i ?>"><?php echo $i ?></option>
<?php } ?>
</select>
</th>
</tr>
<tr>
<td><label for="projectSS">Project Skill Set:</label></td><td><input name="projectSS" type="text"/></td><th colspan="2"><small>(Please Separate By Comma)</small></th>
</tr>
</table>
</fieldset>
<br />
<input name="submit" type="submit" value="Create Project" />
</form>
<?php
} else {
echo $message;
}
?>
</div>
我设法解决了这个问题。在查询数据库时,在我的SELECT语句中,我忘记添加变量"。例如SELECT * FROM project WHERE project_title = '$variable';
。谢谢那些帮助我的人。我真的很感激。
相关文章:
- 如何在输入字段中的按钮的帮助下打开日历,该字段的类型为“=”;日期”;
- 互斥单选按钮和相应的输入字段
- 在IE9中的输入字段中输入焦点最近按钮
- 带有验证和隐藏字段值的提交按钮
- 按钮字段确认点击不'不起作用
- 根据字段的值启用按钮
- JS动态添加字段-删除按钮不起作用
- 根据页面加载时的单选按钮选择显示某些字段
- 如果选择单选按钮,则显示字段
- 单击带有按钮的字段的复制值
- HTML提交表单,同时包含空字段检查和按钮隐藏
- 选择单选按钮更新2个输入字段
- WooCommerce输入字段 - 递增/递减字段按钮
- Primefaces:如何更改日历字段按钮上的默认图标
- 清除字段按钮(重定向不起作用)
- Extjs文件字段按钮只与一个图像
- 如何添加多个表单字段(一次)与'添加新字段'按钮
- 每当用户单击“添加另一个选择字段”按钮时,使用JQuery添加一个PHP函数
- AngularJS :如何仅为最后一个按钮制作动态字段按钮
- 创建一个“删除字段”按钮,在动态添加新字段后