我正在尝试使用 PDO
更新 mysql 中的一行,我不知道为什么它不执行。一切似乎都是正确的,但它不会执行,也不会产生任何错误。
首先,我通过$.ajax
获取发送的值
$idRequest = $_POST['idRequest'];
$dateStarted = $_POST['dateStarted'];
$requester = $_POST['requester'];
$quantity = $_POST['quantity'];
$qaauthorization = $_POST['qaauthorization'];
$qengineer = $_POST['qengineer'];
$performer = $_POST['performer'];
$voltage = $_POST['voltage'];
$goal = $_POST['goal'];
$measurementunit = $_POST['measurementunit'];
$account = $_POST['account'];
$centercost = $_POST['centercost'];
$ela = $_POST['ela'];
$it = $_POST['it'];
$testtype = $_POST['testtype'];
$brand = $_POST['brand'];
$model = $_POST['model'];
$part = $_POST['part'];
$objective = $_POST['objective'];
$production = $_POST['production'];
$reason = $_POST['reason'];
$specifications = $_POST['specifications'];
然后我创建查询
$queryRQ = "UPDATE
request
SET
`idRequester` = ? , `idQEngineer` = ? , `RequestDate` = ? , `idModelNumber` = ?,`idPartDescription` = ? ,`idTestType` = ? , `ReasonForTesting` = ? ,
`Quantity` =?,`Goal` = ?,`idMeasurementUnit` = ?, `Voltage` = ?, `AccountNumber` = ?, `CenterCost` = ?, `ELA` = ?,`ITNumber` = ?, `idPerformer` = ?, `DateStarted` = NOW(), `DateCompleted` = NULL,
`Specifications` =?, `idObjective` = ?, `idProduction` = ?, `idBrand` = ?, `Available` = 1 , `Pending` = 0)
WHERE
idRequest = ?";
最后,当我prepare
并execute
$stmt
时,似乎什么都没发生,而且不会产生任何错误
$reqVals = array($requester,$qengineer,$dateStarted,$model,$part,$testtype,$reason,
$quantity,$goal,$measurementunit,$voltage,$account,$centercost,$ela,$it,$performer,
$specifications,$objective,$production,$brand, /* WHERE */ $idRequest);
$stmtRQ = $pdo->prepare($queryRQ);
$stmtRQ->execute($reqVals);
我通过用try - catch
将所有内容括起来来报告错误:
try{
// EVERYTHING
} catch(PDOException $e){
echo(json_encode($e->getMessage());
}
你有一个额外的 NULL 关键字,看起来不合适......
`DateStarted` = NOW(), NULL,
^^^^^
还有一个看起来无效的右派...
`Pending` = 0)
^
为了发现这些事情,以特定的方式格式化 SQL 语句(即使它更多行)有很大帮助......下面是一个格式错误的 SQL 语句,它等效于您的语句,它具有无关的 NULL 关键字和不匹配的结束(右)括号:
UPDATE request
SET `idRequester` = ?
, `idQEngineer` = ?
, `RequestDate` = ?
, `idModelNumber` = ?
, `idPartDescription` = ?
, `idTestType` = ?
, `ReasonForTesting` = ?
, `Quantity` = ?
, `Goal` = ?
, `idMeasurementUnit` = ?
, `Voltage` = ?
, `AccountNumber` = ?
, `CenterCost` = ?
, `ELA` = ?
, `ITNumber` = ?
, `idPerformer` = ?
, `DateStarted` = NOW()
, NULL
, `Specifications` = ?
, `idObjective` = ?
, `idProduction` = ?
, `idBrand` = ?
, `Available` = 1
, `Pending` = 0
)
WHERE idRequest = ?
如果将此 SQL 语句发送到数据库,则数据库肯定会引发异常。更根本的问题是,您的代码要么没有准备此语句,要么没有以预期的方式公开 SQL 异常。