Имеется запрос:
| Код |
$conn = connect_to_db();
$stmt = $conn->prepare("INSERT INTO `brands` (PartnerID, AffiliateID, UserName, Password, BrandName, BrandURL, BrandAPI, PlatformID, BrandImageURL, Stars, Priority, Countries, IsVisible)
VALUES(:PartnerID, :AffiliateID, :UserName, :Password, :BrandName, :BrandURL, :BrandAPI, :PlatformID, :BrandImageURL, :Stars, :Priority, :Countries :IsVisible)");
$stmt->execute(array(
"PartnerID" => $partner,
"AffiliateID" => $_POST["affiliate"],
"UserName" => $_POST["UserName"],
"Password" => $_POST["Password"],
"BrandName" => $_POST["brandName"],
"BrandURL" => $_POST["brandURL"],
"BrandAPI" => $_POST["api"],
"PlatformID" => $_POST["platform"],
"BrandImageURL" => $_POST["Logotype"],
"Stars" => $_POST["stars"],
"Priority" => $_POST["priority"],
"Countries" => $_POST["countries"],
"IsVisible" => $visible
));
|
Получаю ошибку
| Цитата |
PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''1')' at line 1'
|
все переменные проверил в другом месте приложения подобный запрос работает норм.
В чем межет быть проблема??? |