我是 php、html、css 的新手,正在开发一个项目(为我自己)。每次我按“保存”按钮时,什么也没有发生。我多次检查我的代码或以不同的方式重写代码,但仍然没有发生任何事情。
我的代码:
<?php
session_start();
if (!isset($_SESSION['userSession']) == "true") {
header("Location: index.php");
exit;
}
include_once("dbconnect.php");
if(isset($_POST['submit'])) {
$category = $_POST['category'];
$task_type = $_POST['task_type'];
$done_by = $_POST['done_by'];
$order_by = $_POST['order_by'];
$start_date = $_POST['start_date'];
$end_date = $_POST['end_date'];
$description = $_POST['description'];
//insert data to database
if ($count == 0) {
$query = "INSERT INTO task
(category,task_type,done_by,order_by,
start_date,end_date,description)
VALUES('$category','$task_type','$done_by','$order_by',
'$start_date','$end_date','$description')";
if ($DBcon->query($query)) {
$msg = "<div class='alert alert-success'>
<span></span> successfully saved !
</div>";
} else {
$msg = "<div class='alert alert-danger'>
<span></span> error while saving !
</div>";
}
}
$DBcon->close();
}
?>
<!DOCTYPE html>
<html>
<header>
<title>Home</title>
<link href="css/bootstrap.min.css" rel="stylesheet" media="screen">
<link href="css/bootstrap-theme.min.css" rel="stylesheet" media="screen">
<link rel="stylesheet" href="css/style.css" type="text/css"/>
<!--get.time-->
<script src="javascript/get.date.js" type="text/javascript"></script>
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js"></script>
<script src="javascript/dropdown.funktion.js" type="text/javascript"></script>
<!--date.diff-->
<script data-require="[email protected]" data-semver="1.5.0"
src="https://ajax.googleapis.com/ajax/libs/angularjs/1.5.0/angular.js"></script>
<script data-require="[email protected]" data-semver="2.10.2"
src="https://cdnjs.cloudflare.com/ajax/libs/moment.js/2.10.2/moment.min.js"></script>
<script src="javascript/date.diff.js" type="text/javascript"></script>
</header>
<body ng-app="dateDiff">
<!--hoyer baground-->
<div class="fullscreen-bg">
<video loop muted autoplay poster="img/videoframe.jpg" class="fullscreen-bg__video">
<source src="https://hoyermotors.com/wp-content/uploads/2017/04/1_Intro.mp4" type="video/mp4">
</video>
</div>
<!--Form-->
<div class="home-page" ng-controller="index as vm"
<form class="form-signin" method="post" id="register-form">
<!--hoyer logo -->
<div class="hoyer_logo">
<image src="https://hoyermotors.com/logo-yellow.png">
<a href="logout.php" class="btn btn-default" style="float:right;">Logout</a>
</div>
<hr/>
<!-- Start Category and task type code-->
Category: <select id="category" name="category" class="form-control" required>
<option value="0">Select Category</option>
<?php
include('dbconnect.php');
$sql = mysqli_query($DBcon, "SELECT * FROM category");
while ($row = mysqli_fetch_array($sql)) {
echo '<option value="' . $row['category_id'] . '">' . $row['category_name'] . '</option>';
} ?>
</select>
Task Type:<select id="task_type" name="task_type" class="form-control" required>
<option>Select Task Type</option>
</select>
<!-- end Category and task type code-->
Done By: <input type="text" class="form-control" name="done_by"
value="<?php echo ucwords($_SESSION['userSession']); ?>" required/>
Order By: <input type="text" class="form-control" name="order_by" value="" required/>
Start:
<div class="input-group ng-isolate-scope ng-valid ng-dirty ng-valid-parse">
<input type="datetime-local" name="start_date" id="start"
class="form-control ng-valid ng-isolate-scope ng-dirty ng-touched" ng-model="vm.startDate" value="">
<div class="input-group-btn">
<button type="button" id="1" class="btn btn-default" onClick="show(this.id)" ng-disabled="disabled">
now
</button>
</div>
</div>
End:
<div class="input-group ng-isolate-scope ng-valid ng-dirty ng-valid-parse">
<input type="datetime-local" name="end_date" id="end"
class="form-control ng-valid ng-isolate-scope ng-dirty ng-touched" ng-model="vm.endDate" value="">
<div class="input-group-btn">
<button type="button" id="2" class="btn btn-default" onClick="show(this.id)" ng-disabled="disabled">
now
</button>
</div>
</div>
Duration:
<div class="input-group ng-isolate-scope ng-valid ng-valid-end-time-valid">
<input id="duration" type="data" class="form-control ng-pristine ng-valid ng-valid-date ng-touched"
value="Days: {{vm.result.days}} Hours: {{vm.result.hours}} Minutes: {{vm.result.minutes}}" disabled>
<div class="input-group-btn">
<button type="button" id="2" class="btn btn-default" ng-click="vm.getDiff()"> =</button>
</div>
</div>
Description: <textarea name="description" class="form-control ng-pristine ng-valid ng-touched"
ng-model="log.note"
mh-max-length="2000" ng-trim="false"></textarea>
<div class="form-group">
<button type="submit" class="btn btn-default" name="submit">
<span></span> Save
</button>
</div>
<?php
if (isset($msg)) {
echo $msg;
}
?>
</form>
</div>
</div>
</body>
</html>
桌子
CREATE TABLE IF NOT EXISTS task (
task_id int(50) NOT NULL AUTO_INCREMENT,
category varchar(50) NOT NULL,
task_type varchar(50) NOT NULL,
done_by varchar(4) NOT NULL,
order_by varchar(4) NOT NULL,
start_date DATE DEFAULT NULL,
end_date DATE DEFAULT NULL,
description varchar(2000) NOT NULL,
PRIMARY KEY (task_id)
);
您可能需要考虑这些;
1、你在dbconnect.php中的数据库连接没有正确设置
2、你通过表单插入数据库的某些值可能有一些无效字符,例如'或`(这就是准备好的语句非常重要的原因)
3 , 还要检查 $count 的值是什么,因为如果它不是 0,则不会执行您的插入代码。
还可以尝试将action=""添加到您的表单标签中……不是那么重要,但它也不会损害您的代码
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句