I try write some base model, but it's very difficult, ex: \Phalcon\Mvc\Model\Row dont have ->dump() method, to display all data and so on. So my question is: how i can rewrite the code below with phalcon?
$user = Users::first(array( 'with' => 'UsersEmails', 'conditions' => array( 'user_email' => '[email protected]', 'Users.user_id' => 1, ) )); $user->UsersEmails->confirmed = 1; $uesr->save();
Maybe some allready wrote some parent model class, to use phalcon as lithium or yii?
Give something like this a try:
<?php
$user = Users::findFirst(array(
'conditions' =>
'user_email = ?1 and '.
'user_id = ?2',
'bind' => array(
1 => '[email protected]',
2 => 1
)
));
foreach ($user->getUsersEmails() as $user_email) {
$user_email->confirmed = 1;
$user_email->save();
}Unless user_email is part of UsersEmails model, then try:
<?php
$user = Users::findFirst(array(
'conditions' =>
'user_id = ?1',
'bind' => array(
1 => 1
)
));
foreach ($user->getUsersEmails("user_email = '[email protected]'") as $user_email) {
$user_email->confirmed = 1;
$user_email->save();
}Or a really condensed version:
<?php
$user = Users::findFirst(1);
foreach ($user->getUsersEmails("user_email = '[email protected]'") as $user_email) {
$user_email->confirmed = 1;
$user_email->save();
}Or the most condensed version:
<?php
foreach (Users::findFirst(1)->getUsersEmails("user_email = '[email protected]'") as $user_email) {
$user_email->confirmed = 1;
$user_email->save();
}This assumes, of course, that you've set up a hasMany relationship in your Users and a belongsTo relationship in your UsersEmails models.
I haven't tested it because I don't have your exact use case, but, this should either work or be a huge step in the right direction.
Brian, thanks for you atantion. But if i hasnt user_id, i have only user_email from UsersEmails table, and i want find user, can i do this with one query? Not use ..->getUsers()
Is there a reason you object to:
UsersEmails::findByUserEmail('[email protected]')->getUsers();which is the preferred way to do what you are asking? You could also use PHQL (select * from UsersEmails left join Users) or raw sql in the way you probably already know how.