вот запрос: Код | $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
|
Несколько раз пересчитал - вроде везде всё поровну! В чём причина может быть??
|