PDO não esta gravando no BD
olá pessoal estou tentando gravar os dados no BD, porém esta me retornando esse erro
Warning: PDOStatement::execute(): SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens in C:\wamp\www\.....\admin\adm\anuncio_config_promocao_alterando.php on line 160
array (size=3)
0 => string 'HY093' (length=5)
1 => null
2 => null
Essa é a pagina
$sql = "UPDATE $tabela23 SET PONTOS1 = :PONTOS1,
PONTOS2 = :PONTOS2,
PONTOS3 = :PONTOS3,
PONTOS4 = :PONTOS4,
PONTOS5 = :PONTOS5,
PONTOS6 = :PONTOS6,
PONTOS7 = :PONTOS7,
PONTOS8 = :PONTOS8,
PONTOS9 = :PONTOS9,
PONTOS10 = :PONTOS10,
QTS_ADPACKS1 = :QTS_ADPACKS1,
QTS_ADPACKS2 = :QTS_ADPACKS2,
QTS_ADPACKS3 = :QTS_ADPACKS3,
QTS_ADPACKS4 = :QTS_ADPACKS4,
QTS_ADPACKS5 = :QTS_ADPACKS5,
QTS_ADPACKS6 = :QTS_ADPACKS6,
QTS_ADPACKS7 = :QTS_ADPACKS7,
QTS_ADPACKS8 = :QTS_ADPACKS8,
QTS_ADPACKS9 = :QTS_ADPACKS9,
QTS_ADPACKS10 = :QTS_ADPACKS10,
BONUS_COMPRA_ADPACKS1 = :BONUS_COMPRA_ADPACKS1,
BONUS_COMPRA_ADPACKS2 = :BONUS_COMPRA_ADPACKS2,
BONUS_COMPRA_ADPACKS3 = :BONUS_COMPRA_ADPACKS3,
BONUS_COMPRA_ADPACKS4 = :BONUS_COMPRA_ADPACKS4,
BONUS_COMPRA_ADPACKS5 = :BONUS_COMPRA_ADPACKS5,
BONUS_COMPRA_ADPACKS6 = :BONUS_COMPRA_ADPACKS6,
BONUS_COMPRA_ADPACKS7 = :BONUS_COMPRA_ADPACKS7,
BONUS_COMPRA_ADPACKS8 = :BONUS_COMPRA_ADPACKS8,
BONUS_COMPRA_ADPACKS9 = :BONUS_COMPRA_ADPACKS9,
BONUS_COMPRA_ADPACKS10 = :BONUS_COMPRA_ADPACKS10,
BONUS_BRINDE_ADPACKS1 = :BONUS_BRINDE_ADPACKS1,
BONUS_BRINDE_ADPACKS2 = :BONUS_BRINDE_ADPACKS2,
BONUS_BRINDE_ADPACKS3 = :BONUS_BRINDE_ADPACKS3,
BONUS_BRINDE_ADPACKS4 = :BONUS_BRINDE_ADPACKS4,
BONUS_BRINDE_ADPACKS5 = :BONUS_BRINDE_ADPACKS5,
BONUS_BRINDE_ADPACKS6 = :BONUS_BRINDE_ADPACKS6,
BONUS_BRINDE_ADPACKS7 = :BONUS_BRINDE_ADPACKS7,
BONUS_BRINDE_ADPACKS8 = :BONUS_BRINDE_ADPACKS8,
BONUS_BRINDE_ADPACKS9 = :BONUS_BRINDE_ADPACKS9,
BONUS_BRINDE_ADPACKS10 = :BONUS_BRINDE_ADPACKS10,
LIBERADO_PONTOS = :LIBERADO_PONTOS,
LIBERADO_BRINDES = :LIBERADO_BRINDES
WHERE ID = :ID";
$stmt = $con->prepare($sql);
$stmt->bindParam(':PONTOS1', $qts_pontos1);
$stmt->bindParam(':PONTOS2', $qts_pontos2);
$stmt->bindParam(':PONTOS3', $qts_pontos3);
$stmt->bindParam(':PONTOS4', $qts_pontos4);
$stmt->bindParam(':PONTOS5', $qts_pontos5);
$stmt->bindParam(':PONTOS6', $qts_pontos6);
$stmt->bindParam(':PONTOS7', $qts_pontos7);
$stmt->bindParam(':PONTOS8', $qts_pontos8);
$stmt->bindParam(':PONTOS9', $qts_pontos9);
$stmt->bindParam(':PONTOS10', $qts_pontos10);
$stmt->bindParam(':QTS_ADPACKS1', $qts_adpacks1);
$stmt->bindParam(':QTS_ADPACKS2', $qts_adpacks2);
$stmt->bindParam(':QTS_ADPACKS3', $qts_adpacks3);
$stmt->bindParam(':QTS_ADPACKS4', $qts_adpacks4);
$stmt->bindParam(':QTS_ADPACKS5', $qts_adpacks5);
$stmt->bindParam(':QTS_ADPACKS6', $qts_adpacks6);
$stmt->bindParam(':QTS_ADPACKS7', $qts_adpacks7);
$stmt->bindParam(':QTS_ADPACKS8', $qts_adpacks8);
$stmt->bindParam(':QTS_ADPACKS9', $qts_adpacks9);
$stmt->bindParam(':QTS_ADPACKS10', $qts_adpacks10);
$stmt->bindParam(':BONUS_COMPRA_ADPACKS1', $qts_adpacks_comprar1);
$stmt->bindParam(':BONUS_COMPRA_ADPACKS2', $qts_adpacks_comprar2);
$stmt->bindParam(':BONUS_COMPRA_ADPACKS3', $qts_adpacks_comprar3);
$stmt->bindParam(':BONUS_COMPRA_ADPACKS4', $qts_adpacks_comprar4);
$stmt->bindParam(':BONUS_COMPRA_ADPACKS5', $qts_adpacks_comprar5);
$stmt->bindParam(':BONUS_COMPRA_ADPACKS6', $qts_adpacks_comprar6);
$stmt->bindParam(':BONUS_COMPRA_ADPACKS7', $qts_adpacks_comprar7);
$stmt->bindParam(':BONUS_COMPRA_ADPACKS8', $qts_adpacks_comprar8);
$stmt->bindParam(':BONUS_COMPRA_ADPACKS9', $qts_adpacks_comprar9);
$stmt->bindParam(':BONUS_COMPRA_ADPACKS10', $qts_adpacks_comprar10);
$stmt->bindParam(':BONUS_BRINDE_ADPACKS1', $qts_adpacks_brinde1);
$stmt->bindParam(':BONUS_BRINDE_ADPACKS2', $qts_adpacks_brinde2);
$stmt->bindParam(':BONUS_BRINDE_ADPACKS3', $qts_adpacks_brinde3);
$stmt->bindParam(':BONUS_BRINDE_ADPACKS4', $qts_adpacks_brinde4);
$stmt->bindParam(':BONUS_BRINDE_ADPACKS5', $qts_adpacks_brinde5);
$stmt->bindParam(':BONUS_BRINDE_ADPACKS6', $qts_adpacks_brinde6);
$stmt->bindParam(':BONUS_BRINDE_ADPACKS7', $qts_adpacks_brinde7);
$stmt->bindParam(':BONUS_BRINDE_ADPACKS8', $qts_adpacks_brinde8);
$stmt->bindParam(':BONUS_BRINDE_ADPACKS9', $qts_adpacks_brinde9);
$stmt->bindParam(':BONUS_BRINDE_ADPACKS10', $qts_adpacks_brinde10);
$stmt->bindParam(':LIBERADO_PONTOS', $liberado_pontos);
$stmt->bindParam(':LIBERADO_BRINDES', $liberado_brindes);
$result = $stmt->execute();
if ( ! $result )
{
var_dump( $stmt->errorInfo() );
exit;
}
já tentei varias formas, mas nenhuma esta dando certo
Discussão (2)
Carregando comentários...