SQLSTATE[HY093]Invalid parameter number, all parameters match

Question

i have this code

switch ($var1) {
case 'corredor':{
  $query = '  UPDATE corredor   
              SET 
                      cedula = :cedula,
                      nombres = :nombres,
                      apellidos = :apellidos,
                      fechanacimiento = :fechanacimiento,
                      telefono = :telefono,
                      correo = :correo,
                      direccion = :direccion,
                      fecharegistro = :fecharegistro,
                      estatus = :estatus,
                      aseguradora_rif =: aseguradora_rif
               WHERE cedula = :cedula_old
            ';
    $query_params = array(
        ':cedula' => $_POST['cedula'],
        ':nombres' => $_POST['nombres'],
        ':apellidos' => $_POST['apellidos'],
        ':fechanacimiento' => $_POST['fechanacimiento'],
        ':telefono' => $_POST['telefono'],
        ':correo' => $_POST['correo'],
        ':direccion' => $_POST['direccion'],
        ':fecharegistro' => $_POST['fecharegistro'],
        ':estatus' => $_POST['estatus'],
        ':aseguradora_rif' => $_POST['aseguradora_rif']
        ':cedula_old' => $var2
        );
    try {
        $stmt = $db->prepare($query);

        $result = $stmt->execute($query_params);
    } catch (PDOException $ex) {
        $ex->getMessage();
    }
    #header('Location: index.php?do=listacorredor');
    break;
} //fin case

i'm getting

SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens

and i don't know why, all my parameters seems to match, i already looked for extra , at the end of the query and params all the binds match the database names so i'm lost here, the other answers were things like missing , or something like that but really can't see the problem here.

You have an extra comma after `':cedula_old' => $var2,`, and none on the line above. — Qirel, Feb 04 '17 at 14:02
oh yeah i was testing while posting this, if deleted i still getting the same error. — Jose CastilLo Stronghold, Feb 04 '17 at 14:06
`aseguradora_rif =: aseguradora_rif` You have an extra space here — George Pant, Feb 04 '17 at 14:26
`':aseguradora_rif' => $_POST['aseguradora_rif']` and you forgot a comma here — George Pant, Feb 04 '17 at 14:29
@GeorgePant it worked! thank you i cuadruple check only names, thank you. — Jose CastilLo Stronghold, Feb 04 '17 at 14:35

score -1 · Answer 1 · answered Feb 10 '17 at 14:54

-1

you forgot bind params :)

http://php.net/manual/es/pdostatement.bindparam.php

http://php.net/manual/es/pdostatement.bindvalue.php

Before execute(), you need "assign" values to correspond data into array.

Ex:

$stmt = $db->prepare($query);

$stmt->bindParam(':cedula', $_POST['cedula']);

$result = $stmt->execute();

answered Feb 10 '17 at 14:54

elporfirio

306
2
15

Let me suggest you to answer only in the areas you have experience with – Your Common Sense Feb 10 '17 at 15:18

SQLSTATE[HY093]Invalid parameter number, all parameters match

1 Answers1