вот запрос:
| Код |
$stmt = $conn_string->prepare("INSERT INTO `backup` (`logmarker`, `source`, `firstName`, `lastName`, `password`, `email`, `phoneCode`, `phone`, `country`, `ip`, `affiliate_id`)
VALUES (:logmarker, :source, :firstName, :lastName, :password, :email, :phoneCode, : phone, :country, :ip, :affiliate_id)");
$stmt->bindParam(':logmarker', $logmarker);
$stmt->bindParam(':source', $source);
$stmt->bindParam(':firstName', $firstName);
$stmt->bindParam(':lastName', $lastName);
$stmt->bindParam(':password', $password);
$stmt->bindParam(':email', $email);
$stmt->bindParam(':phoneCode', $phoneCode);
$stmt->bindParam(':phone', $phone);
$stmt->bindParam(':country', $country);
$stmt->bindParam(':ip', $ip);
$stmt->bindParam(':affiliate_id', $affiliate_id);
$logmarker = "one";
$source = 9;
$firstName = "Anonim";
$lastName = "Anonimus";
$password = "pass12345";
$email = "[email protected]";
$phoneCode = "+49";
$phone = "15777964141";
$country = "DE";
$ip = "185.583.001.006";
$affiliate_id = "5467889";
$stmt->execute();
|
Получаю ощибку:
| Цитата |
PDOStatement::execute(): SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens in
|
Несколько раз пересчитал - вроде везде всё поровну! В чём причина может быть?? |