Solved thread

This post is marked as solved. If you think the information contained on this thread must be part of the official documentation, please contribute submitting a pull request to its repository.

Autocomplete forms using ORM and Phalcon Forms

Hello everyone!

Let's say I have two relational tables with the following settings:

users (id, email, pwd) users_info (id, uid, name, phone)

If I do this in my UsersController:

$user = Users::findFirstByXid($id);
$this->view->form = new UsersForm($user, array('edit' => true));

I only see email field autocompleted. That's because to access it I can do $user->email but for get the name, I must do somethign like $user->UsersInfo[0]->name

is there some "magic" wat in Phalcon to achieve this or must I make a manual mapping of the object?

Thanks and please forgive this bad english.


1 model = 1 database table

UsersInfo is a relation between 2 models, it should be the way its done, cuz if someone else reads your code they will get confused.

edited Dec '17

As @Izo said, 1 model = 1 database table. Some time ago I had almost identical situation like you. Here is how I solved the problem back then. If someone else has better solution please share! :)

// Controller code
$form = new \Frontend\Forms\ProfileEdit($obj->getEditInfo());

// Model code (or whatever)
public function getEditInfo()
    return $this->modelsManager->createBuilder()
        ->from(['profile' => 'Models\Profiles'])
        ->leftJoin('Models\ProfileDetails', 'details.profile_id =', 'details')
        ->where(' = :id:', ['id' => $this->id])

Basically you have to use the Query Builder to create a single object and pass it as form entity in order to populate all the fields :)

UPDATE: Just in case someone asks: But how do I update the two models (database tables) after form is submitted and valited?

// Controller code
$form = new \Frontend\Forms\ProfileEdit($obj->getEditInfo());
if ($this->request->isPost() AND $this->security->checkToken() AND $form->isValid($this->request->getPost())) {
    $obj->updateProfile($id, $this->request);

// Model code (or whatever)
function updateProfile($id, $request)
    // Profiles table
    $profile = Profiles::findFirst($id);
    $profile->name = $request->getPost('names', 'striptags');
    $profile->email = $request->getPost('email', 'email');

    // Profile details table
    $details = ProfileDetails::findFirstByProfileId($id);
    $details->phone = $request->getPost('phone');;

    // Try to save and return model errors if any
    if ($profile->save() AND $details->save()) {
        return [];
    } else {
        return array_merge((array) $profile->getMessages(), (array) $details->getMessages());