数据库表单php老是提交失败,HTML表单没有通过php向我的数据库提交数据

我需要帮助让我的HTML表单提交数据到我的数据库(mysql)。数据库可以很好地连接，但它似乎无法将数据连接到数据库。我使用Notepad ++作为我的文本编辑器和测试器。这是提前在课堂上进行的项目，我需要了解如何为此做到这一点。

HTML

Add Record Form

TechID:

First Name:

Last Name:

Phone:

Email:

State:

Address:

Zipcode:

Date:

Course:

Request:

PHP

$link = mysqli_connect("localhost", "root", "", "student_request");

if($link === false){

die("ERROR: Could not connect. " . mysqli_connect_error());

}

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

$techid = $_POST['techid'];

$firstname = $_POST['firstname'];

$lastname = $_POST['lastname'];

$phone = $_POST['phone'];

$email = $_POST['email'];

$state = $_POST['state'];

$address = $_POST['address'];

$zipcode = $_POST['zipcode'];

$date = $_POST['date'];

$course = $_POST['course'];

$request = $_POST['request'];

$sql = "INSERT INTO student (TECH_ID, FIRST_NAME, LAST_NAME, PHONE_NUM, EMAIL, STATE, ADDRESS, ZIPCODE, DATE, COURSE, REQUEST_TYPE) VALUES ('$techid','$firstname','$lastname','$phone','$email','$state','$address','$zipcode','$date','$course','$request')";

if(mysqli_query($link, $sql)) {

echo "Records inserted successfully.";

} else {

echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);

}

}

mysqli_close($link);

?>student表的表格结构： -

CREATE TABLE `student` (

`REQUEST_ID` int(255) NOT NULL,

`TECH_ID` int(11) NOT NULL,

`FIRST_NAME` varchar(255) NOT NULL,

`LAST_NAME` varchar(255) NOT NULL,

`PHONE_NUM` varchar(255) NOT NULL,

`EMAIL` varchar(255) NOT NULL,

`STATE` varchar(255) NOT NULL,

`ADDRESS` varchar(255) NOT NULL,

`ZIPCODE` varchar(255) NOT NULL,

`DATE` date NOT NULL,

`COURSE` varchar(255) NOT NULL,

`REQUEST_TYPE` text NOT NULL

)