запрос
| Код |
$conn = connect_to_db();
$stmt = $conn->prepare("INSERT INTO brandaccounts (UserID, BrandID, LoginEmail, LoginID, LoginPassword, initialBalance, actualBalance, IsAutoTrade, MaxBet, MaxStopLoss, MaxTakeProfit, IsTestAccount, VIPGroup)
VALUES (:UserID, :BrandID, :LoginEmail, :LoginID, :LoginPassword, :initialBalance, :actualBalance, :IsAutoTrade, :MaxBet, :MaxStopLoss, :MaxTakeProfit, :IsTestAccount, :VIPGroup)");
$stmt->bindParam(':UserID', $rq->UserID);
$stmt->bindParam(':BrandID', $rq->BrandID);
$stmt->bindParam(':LoginEmail', $rq->LoginEmail);
$stmt->bindParam(':LoginID', $rq->LoginID);
$stmt->bindParam(':LoginPassword', $rq->LoginPassword);
$stmt->bindParam(':initialBalance', $rq->initialBalance);
$stmt->bindParam(':actualBalance', $rq->actualBalance);
$stmt->bindParam(':IsAutoTrade', $rq->IsAutoTrade);
$stmt->bindParam(':MaxBet', $rq->MaxBet);
$stmt->bindParam(':MaxStopLoss', $rq->MaxStopLoss);
$stmt->bindParam(':MaxTakeProfit', $rq->MaxTakeProfit);
$stmt->bindParam(':IsTestAccount', $rq->IsTestAccount);
$stmt->bindParam(':VIPGroup', $rq->VIPGroup);
$stmt->execute();
|
Получаю ошибку [23-Jul-2015 11:39:40 UTC] PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens' in
В чем тут дело? количество аргументов соответствует, все переменные в норме в таблице все эти поля есть!? |