代码之家 › 专栏 › 技术社区 › Andre F

与令牌数量不匹配[重复]

database sql html php

-1

Andre F · 技术社区 · 7 年前

我有一个页面,用户可以在其中发送反馈,但当我点击“发送”时,会出现错误,显示如下:

这是我的插入消息。php:

<?php
require_once ('database.php');

if (isset($_POST['send'])) {

$employee_id = $_POST['employee_id'];
$full_name = $_POST['full_name'];
$email = $_POST['email'];
$website = ($_POST['website']);
$message = ($_POST['message']);

{
$database->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$insert_query = "INSERT INTO tbl_feedback (employee_id, full_name, email, website, message)
VALUES (?, ?, ?, ?)";

$insert = $database->prepare($insert_query);
$insert->execute(array($employee_id, $full_name, $email, $website, $message));

echo "<script>alert('Successfully sent!'); window.location='feedback.php'</script>";
}
}
?>

<div class="row">
	<div class="col-xs-6">
		<form method="post" action="insert-message.php">
			<div class="form-group">
				<label for="exampleInputPassword1">Employee ID<span style="color:#d0d0d0;"> (required)</span></label>
				<input type="text" readonly="readonly" class="form-control" name="employee_id" value="<?php echo $user_id; ?>" autofocus="autofocus" required />
			</div>
			<div class="form-group">
				<label for="exampleInputPassword1">Name<span style="color:#d0d0d0;"> (required)</span></label>
				<input type="text" readonly="readonly" class="form-control" name="full_name" value="<?php echo $fullname; ?>" autofocus="autofocus" required />
			</div>
			<div class="form-group">
				<label for="exampleInputEmail1">Email Address <span style="color:#d0d0d0;">(required)</span></label>
				<input type="email" class="form-control" name="email" required />
			</div>
			<div class="form-group">
				<label for="exampleInputEmail1">Website</label>
				<input type="text" class="form-control" name="website">
			</div>
			<div class="form-group">
				<label for="exampleInputEmail1">Your Message <span style="color:#d0d0d0;">(required)</span></label>
				<textarea class="form-control" name="message" style="height:200px;" required ></textarea>
			</div>
			
			<a href="home"><button type="button" class="btn btn-primary"><i class="glyphicon glyphicon-arrow-left"></i> Back</button></a>
			<button type="submit" name="send" class="btn btn-primary"><i class="glyphicon glyphicon-send"></i> Send</button>
			
		</form>
	</div>
</div>

表单工作正常,只是我点击发送时出错。此外,我的数据库中有两个表:feedback和employee。“employee\u id”用作引用employee表中“id”的外键。

我不确定你们是否需要这些信息,但我不妨补充一下。

1 回复 | 直到 7 年前

Jens 7 年前

您的查询中只有4个占位符 VALUES (?, ?, ?, ?)"; 但您绑定了5个值。在查询中还指定了5列。我想你还漏掉了一个问号。