如何在mysql数据库中插入表单条目时解决"Notice: Undefined index: name"？

Question

下面是将表单条目插入数据库的代码。include.php文件用于数据库连接

<?php
require "../includes/include.php";
$name=$_POST['name'];
if($name="")
echo "Name field can't be empty !!!<br>";
$faculty=$_POST['faculty'];
if($faculty="")
echo "Please select your faculty !!!<br>";
$rating=$_POST['rating'];
if($rating="")
echo "Please select the respective rating !!!<br>";
$response=$_POST['response'];
$name=mysqli_real_escape_string($con, $name);
$faculty=mysqli_real_escape_string($con, $faculty);
$rating=mysqli_real_escape_string($con, $rating);
$response=mysqli_real_escape_string($con, $response);
$insert_query="insert into feedback(name, faculty, rating, response) values ('$name', '$faculty', '$rating', '$response')";
$query_result=mysqli_query($con, $insert_query);
?>

它在插入值时显示错误

注意：未定义的索引：名称在/var/www/html/Mini_Project/php/feedback_script.php 第 12 行 .

有人可以帮忙解决到底出了什么问题吗？

Answer 1

你对$name、$faculty、$rating和$response的分配期望你的$_POST数组中包含某些键。如果您不能保证您的$_POST具有所有这些，最好使用 null 合并运算符(即双问号??(来定义赋值的回退值：

$name=$_POST['name'] ?? "";
if($name="")
echo "Name field can't be empty !!!<br>";
$faculty=$_POST['faculty'] ?? "";
if($faculty="")
echo "Please select your faculty !!!<br>";
$rating=$_POST['rating'] ?? "";
if($rating="")
echo "Please select the respective rating !!!<br>";
$response=$_POST['response'] ?? "";