因此，我試圖從一個(gè) id、2 個(gè)日期、一個(gè)字符串和一個(gè)小數(shù)形式的表單中插入數(shù)據(jù)。但它給出了上面的錯(cuò)誤。列為：ID:int、startdate:Date、enddate:Date、number:int、string、Decimal。我已經(jīng)嘗試添加所有這些date()功能和strtodate()類似的東西，但沒有任何效果。if (isset($_POST['submitReservation'])) { $startDate = $_POST['startDate']; $endDate = $_POST['endDate']; $linens = mysqli_real_escape_string($conn, $_POST['linens']); $peopleAmount = mysqli_real_escape_string($conn, $_POST['persons']); $number = 50; $userID = $_SESSION["UserID"]; $sql = $conn->prepare("INSERT INTO reservation (TenantId, StartDate, EndDate, Number_Of_Persons, Linens, Cost) VALUES (?, ?, ?, ?, ?, ?)"); $sql->bind_param("iiiisd", $userID, $startDate, $endDate, $peopleAmount, $linens, $number); $sql->execute() or die(mysqli_error($conn));}
2 回答
MMMHUHU
TA貢獻(xiàn)1834條經(jīng)驗(yàn) 獲得超8個(gè)贊
您正在將日期轉(zhuǎn)換為 int $sql->bind_param("iiiisd"
編輯：MySQL需要一個(gè)字符串，所以試試$sql->bind_param("issisd"
素胚勾勒不出你
TA貢獻(xiàn)1827條經(jīng)驗(yàn) 獲得超9個(gè)贊
如果您使用的是標(biāo)準(zhǔn) PDO 庫，則可以使用 bindParam() 或 bindValue() 并指定類型，例如
if (isset($_POST['submitReservation'])) {
$startDate = $_POST['startDate'];
$endDate = $_POST['endDate'];
$linens = $_POST['linens']);
$peopleAmount = $_POST['persons']);
$number = 50;
$userID = $_SESSION["UserID"];
$sql = $conn->prepare("INSERT INTO reservation (TenantId, StartDate, EndDate, Number_Of_Persons, Linens, Cost) VALUES (?, ?, ?, ?, ?, ?)");
$sql->bindParam(1, $userID, PDO::PARAM_STR);
$sql->bindParam(2, $startDate, PDO::PARAM_STR);
$sql->bindParam(3, $endDate, PDO::PARAM_STR);
$sql->bindParam(4, $peopleAmount, PDO::PARAM_INT);
$sql->bindParam(5, $linens, PDO::PARAM_STR);
$sql->bindParam(6, $number, PDO::PARAM_INT);
$sql->execute();
}
- 2 回答
- 0 關(guān)注
- 190 瀏覽
添加回答
舉報(bào)
0/150
提交
取消