极客观点
项目管理
HarmonyOS
不多说，直接贴代码
<!DOCTYPE html>
<html>
<body>
<meta charset="utf-8">
Booking #1<br>
<form name="booking" action="insert1.php" method="post">
开始时间：<input type="date" name="startD1"><!--<input type="time" name="startT1">--><br>
结束时间：<input type="date" name="endD1"><!--<input type="time" name="endT1">-->
<input type="submit" />
</form>
</body>
</html>
<?php
$servername = "localhost";
$username = "test";
$password = "test";
$dbname = "test";
$a = $_POST [ 'startD1' ];
$b = $_POST [ 'endD1' ];
// 创建连接
$conn = mysqli_connect($servername, $username, $password, $dbname);
// 检测连接
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
$sql = "INSERT INTO booking (startD1,endD1)
VALUES ('$a','$b')";
if (mysqli_query($conn, $sql)) {
echo "新记录插入成功";
} else {
echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}
mysqli_close($conn);
?>然后就出错了
请问问题出在哪里？我该怎么解决？
html5
mysql
我本地测试没问题，贴一下你的表结构