gpt4 book ai didi

php - PDO MYSQL 插入语句不工作(没有给出错误)

转载 作者:行者123 更新时间:2023-11-29 05:11:36 24 4
gpt4 key购买 nike

<分区>

我有下面的 MySQL 插入语句,代码运行,PDO 不报告任何错误消息,但是第一个语句没有将数据保存到数据库(地址表中没有新行),而第二个语句正常.

$sql=$dbh->prepare("INSERT INTO `Address` (`ID`, `Street`, `Street2`, `Town`, `County`, `Postcode`) VALUES (NULL, ?,?,?,?,?)");

$sql->execute(array($_POST['street'], $_POST['street2'], $_POST['town'], $_POST['county'], $_POST['postcode']));

$addressID = $dbh->lastInsertId();

$firmSQL = $dbh->prepare("INSERT INTO TaxiFirm (Name, LogoURL, AddressID, Phone, Email, LicenseExpiry, ContractDate, Active) VALUES (?, ?, ?, ?, ?, ?, ?, 1)");
$firmSQL->execute(array($_POST['name'], $_POST['url'], $addressID, $_POST['phone'], $_POST['email'], $_POST['license'], $_POST['contract']));

Address 表的 SQL:

CREATE TABLE `Address` (
`ID` int(11) NOT NULL,
`Street` varchar(100) NOT NULL,
`Street2` varchar(100) NOT NULL,
`Town` varchar(100) NOT NULL,
`County` varchar(100) NOT NULL,
`Postcode` varchar(20) NOT NULL
)

ALTER TABLE `Address` MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
ALTER TABLE `Address`
ADD PRIMARY KEY (`ID`);

DESCRIBE Address;的结果

ID  int(11) NO  PRI     auto_increment  
Street varchar(100) NO
Street2 varchar(100) NO
Town varchar(100) NO
County varchar(100) NO
Postcode varchar(20) NO

我看不出代码有什么问题吗?

24 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com