我使用php将数据从一个表插入到另一个具有附加列的表中,然后从第一个表中删除行。但是,我似乎无法让它工作:
public function insertReq($dID, $bphone)
{
$stmt = $this->conn->prepare("INSERT INTO RequestedDevices(dID, deviceName, Medical, Description, Educational, DevicePicture, bphone) VALUES((SELECT id, deviceName, Medical, Description, Educational, DevicePicture WHERE id = ?), ?)");
$stmt->bind_param("ss", $dID, $bphone);
$flag = $stmt->execute();
$stmt1 = $this->conn->prepare("DELETE FROM DEVICE WHERE id= ? ");
$stmt1->bind_param("s", $dID);
$flag1 = $stmt1->execute();
if ($flag & flag1) {
return ADDED;
} else {
return NOT_ADDED;
}
}
1条答案
按热度按时间xwbd5t1u1#
您需要在select中包含附加列作为常量,并且在select周围不需要value()