我正在尝试传递事件 id 的值,因此当用户按下编辑按钮时,它会传递事件 ID 并编辑他们按下编辑的特定事件。
数据库布局:用户
ID、事件名称、地点、日期、名称、事件 ID尝试使用以下方法编辑数据库中的事件:
WHERE eventid='12' ";
通过 ID 号调用它,然后附加到事件 ID 等于该编号的数据库
文件: 编辑事件.php:
<?php
include 'dbh.php';
include_once 'header.php';
session_start();
if(!isset($_SESSION['u_uid'])){
header("Location:signup.php");
}
?>
<section class="main-container">
<h1>test</h1>
<?php
$eventname = mysqli_real_escape_string($conn, $_POST['eventname']);
$venue = mysqli_real_escape_string($conn, $_POST['venue']); //last
$date = mysqli_real_escape_string($conn, $_POST['date']); //email
$name = mysqli_real_escape_string($conn, $_POST['name']); //uid
echo "<form method='POST' action='includes/editevents.inc.php'>
<input type ='text' name='eventname' placeholder='event name'>
<input type ='text' name='venue' placeholder='event name'>
<input type ='date' name='date' placeholder='event date'>
<button type='submit' name='eventsubmit'>Submit</button>
</form>";
?>
</section>
文件: 编辑事件.inc.php:
<?php
include 'dbh.inc.php';
session_start();
if (isset($_POST['eventsubmit'])) {
$eventname = $_POST['eventname'];
$venue = $_POST['venue'];
$date = $_POST['date'];
$name = $_POST['name'];
$eventname = mysqli_real_escape_string($conn, $_POST['eventname']);
$venue = mysqli_real_escape_string($conn, $_POST['venue']);
$date = mysqli_real_escape_string($conn, $_POST['date']);
$name = mysqli_real_escape_string($conn, $_POST['name']);
$sql = "UPDATE events SET eventname='$eventname' WHERE eventid='12' ";
mysqli_query($conn, $sql);
header("Location: ../members.php?event=success");
exit();
} else {
header("Location: ../signup.php");
exit();
}
您还需要将 eventid 添加到您的 html 表单中
<input type ='text' name='eventname' placeholder='event name'>
<input type ='text' name='venue' placeholder='event name'>
<input type ='date' name='date' placeholder='event date'>
<!-----Include event id of the event you want to update ---->
<input type ='hidden' name='eventid' value="$eventid">
<button type='submit' name='eventsubmit'>Submit</button>
所以这也被提交,你得到它像这样
<?php
if (isset($_POST['eventsubmit'])) {
$eventname = $_POST['eventname'];
$venue = $_POST['venue'];
$date = $_POST['date'];
$name = $_POST['name'];
$eventname = mysqli_real_escape_string($conn, $_POST['eventname']);
$venue = mysqli_real_escape_string($conn, $_POST['venue']);
$date = mysqli_real_escape_string($conn, $_POST['date']);
$name = mysqli_real_escape_string($conn, $_POST['name']);
$eventid =mysqli_real_escape_string($conn, $_POST['eventid']);
$sql = "UPDATE events SET eventname='$eventname' WHERE eventid='$eventid' ";