help Warning: PDOStatement :: execute (): SQLSTATE [HY093]: Invalid parameter number

2
<?php 

class Insertar{
    public $mensaje;
    public $nombre;
    public $email;
    public $password;
    public $genero;

    public function insert()
    {
        $model = new Conexion();
        $conexion = $model->conectar();
        $sql = "INSERT INTO 'usuarios'('nombre', 'email', 'password', 'genero') VALUES(:nombre, :email, :password, genero)";
        $consulta = $conexion->prepare($sql);
        $consulta->bindParam(':nombre', $this->nombre);
        $consulta->bindParam(':email', $this->email);
        $consulta->bindParam(':password', $this->password);
        $consulta->bindParam(':genero', $this->genero);

        if (!$consulta)
        {
            $this->mensaje = $conexion->errorInfo();
        }
        else
        {
            $consulta->execute();
            $this->mensaje = "genial, has registrado un usuario";
        }

    }
}
    
asked by Jean 17.08.2018 в 23:31
source

0 answers