Forum PHP.pl

Warning: PDOStatement::execute(): SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens in XXXX on line XX
PDO::errorCode(): HY093

function addTo($table,$col,$value)
    {
        
        
        
        
        if($query = $this->connection->prepare("INSERT INTO :table (:col)
        VALUES (':value')")){
                
            echo gettype($table);
            echo gettype($col);
            echo gettype($value);
            $query->bindParam(':table',$table);
            $query->bindParam(':col',$col);
            $query->bindParam(':value',$value);
            $query->execute();
            echo "\nPDO::errorCode(): ", $query->errorCode();
        }
        
    }

function addTo($col,$value)
    {
        
        
        
        
        if($query = $this->connection->prepare("INSERT INTO users (:col)
VALUES (':value')")){
                


            echo gettype($row);
            echo gettype($value);

            $query->bindValue(':col',$col);
            $query->bindValue(':value',$value);
            $query->execute();
            echo "\nPDO::errorCode(): ", $query->errorCode();
        }
        
    }