Merge string in attributes

Question

Merge string in attributes

Maxim Borzov May '13

Created May '13	Last Reply May '13	Replies 1	Views 698	Votes 1

Maxim Borzov 6.9k

May '13

If i need create a SELECT with authors ('id' as value and 'lastname' and 'firstname' as name) i use: {{ select('author', author, 'using': ['id', 'lastname']) }}

How i can merge lastname and firstname here? Construction with tilda didn't work: {{ select('author', author, 'using': ['id', 'lastname'~'firstname']) }}

Thanks!

1

Phalcon · Answer 1 · 2013-05-12T11:21:39-07:00

Create the query joining the lastname with the firstname:

$this->view->authors = 
       $this->modelsManager->createQuery()
           ->columns('id, CONCAT(lastname, " ", firstname) AS realname')
           ->from('Authors')

Then in the View:

{{ select('author', author, 'using': ['id', 'realname']) }}

Maxim Borzov · Answer 2 · 2013-05-12T13:24:48-07:00

Thanks!

This is solution that i use:

$this->view->authors = $this->modelsManager->createBuilder()
                ->columns(array("id", "CONCAT(lastname, ' ', firstname) AS fullname"))
                ->from('Application\Models\Users')
                ->getQuery()
                ->execute();