Re: How can I get the user firstname displayed, instead of the User_id
*How many tables do you have? *1 table for users, another for profile,
another for proposal, another for comment, making 4 in total
*And if a first name is a property of a user, why would you put it in the
profiles table and not in the users? *
Users table is tied to profile table, a profile belongs to a user. There is
a relationship between the user and profile tables
*Which version of Cake are you using?*
Cake2.8
*If I understand you correctly, you are saying you have a user that has a
profile and a user has many proposals., *
I am yet to create the association between profile and proposal, I only
have relationship between user and profile.
Thanks
If that is the case, I suggest you design the Db first, then bake the 3
models using the bake console, and then adjust the profile relationship
making sure that it is a HasOne relationship as specified in the
documentation.
If you are using Cake 3 edit each of the table files and pick an
appropriate column as the display:
$this->displayField('username');
This is the field that will be shown in select boxes when using find('list')
In your controller where you use the tables you can contain the other
relationships (if they are set up in the table.php) like as follows:
in the Users controller, the Users Table is loaded automatically so you can
reference it through $this->Users
The call you will need to make to search for more than 1 user will be the
find('all'):
$users = $this->Users->find('all', ['contain'=>['Profiles', 'Proposals']]);
For a single user, call the get method with the id of the user:
$user = $this->Users->get($id, ['contain'=>['Profiles', 'Proposals']]);
Once you have contained the other tables you can reference the fields as
follows:
$user->first_name;
$user->profile->id;
$user->proposal->id;
Hope that helps a little...
Regards,
--Kevin
On Tue, Apr 5, 2016 at 12:38 PM, heavyKevy wrote:
> How many tables do you have?
> And if a first name is a property of a user, why would you put it in the
> profiles table and not in the users?
> Which version of Cake are you using?
>
> If I understand you correctly, you are saying you have a user that has a
> profile and a user has many proposals.
> If that is the case, I suggest you design the Db first, then bake the 3
> models using the bake console, and then adjust the profile relationship
> making sure that it is a HasOne relationship as specified in the
> documentation.
>
> If you are using Cake 3 edit each of the table files and pick an
> appropriate column as the display:
> $this->displayField('username');
>
> This is the field that will be shown in select boxes when using
> find('list')
>
> In your controller where you use the tables you can contain the other
> relationships (if they are set up in the table.php) like as follows:
> in the Users controller, the Users Table is loaded automatically so you
> can reference it through $this->Users
> The call you will need to make to search for more than 1 user will be the
> find('all'):
> $users = $this->Users->find('all', ['contain'=>['Profiles', 'Proposals']]);
> For a single user, call the get method with the id of the user:
> $user = $this->Users->get($id, ['contain'=>['Profiles', 'Proposals']]);
>
> Once you have contained the other tables you can reference the fields as
> follows:
> $user->first_name;
> $user->profile->id;
> $user->proposal->id;
>
> Hope that helps a little...
> Regards,
> --Kevin
>
> --
> Sign up for our Newsletter for updates.
> http://cakephp.org/newsletter/signup
>
> We will soon be closing this Google Group. But don't worry, we have
> something better coming. Stay tuned for an updated from the CakePHP Team
> soon.
>
> Like Us on FaceBook https://www.facebook.com/CakePHP
> Follow us on Twitter http://twitter.com/CakePHP
> ---
> You received this message because you are subscribed to a topic in the
> Google Groups "CakePHP" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/cake-php/EAZoK3CB30Y/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> cake-php+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>
--
http://www.clementcrownrise.name/images/nameing.gif
--
Sign up for our Newsletter for updates.
http://cakephp.org/newsletter/signup
We will soon be closing this Google Group. But don't worry, we have something
better coming. Stay tuned for an updated from the CakePHP Team soon.
Like Us on FaceBook https://www.facebook.com/CakePHP
Follow us on Twitter http://twitter.com/CakePHP
---
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to cake-php+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Re: How can I get the user firstname displayed, instead of the User_id
How many tables do you have?
And if a first name is a property of a user, why would you put it in the
profiles table and not in the users?
Which version of Cake are you using?
If I understand you correctly, you are saying you have a user that has a
profile and a user has many proposals.
If that is the case, I suggest you design the Db first, then bake the 3
models using the bake console, and then adjust the profile relationship
making sure that it is a HasOne relationship as specified in the
documentation.
If you are using Cake 3 edit each of the table files and pick an
appropriate column as the display:
$this->displayField('username');
This is the field that will be shown in select boxes when using find('list')
In your controller where you use the tables you can contain the other
relationships (if they are set up in the table.php) like as follows:
in the Users controller, the Users Table is loaded automatically so you can
reference it through $this->Users
The call you will need to make to search for more than 1 user will be the
find('all'):
$users = $this->Users->find('all', ['contain'=>['Profiles', 'Proposals']]);
For a single user, call the get method with the id of the user:
$user = $this->Users->get($id, ['contain'=>['Profiles', 'Proposals']]);
Once you have contained the other tables you can reference the fields as
follows:
$user->first_name;
$user->profile->id;
$user->proposal->id;
Hope that helps a little...
Regards,
--Kevin
--
Sign up for our Newsletter for updates.
http://cakephp.org/newsletter/signup
We will soon be closing this Google Group. But don't worry, we have something
better coming. Stay tuned for an updated from the CakePHP Team soon.
Like Us on FaceBook https://www.facebook.com/CakePHP
Follow us on Twitter http://twitter.com/CakePHP
---
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to cake-php+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Re: How can I get the user firstname displayed, instead of the User_id
Thanks for your response, do you mean i should create a relationship between the proposal and the user table? will creating a proposal "belongs to user AND a User has many Proposal", fix this problem? As for containable behavior, please what do you mean ? Your quick response would be appreciated. Thanks On Mon, Apr 4, 2016 at 5:54 PM, Anja Liebermann wrote: > In your controller you have to fetch the user together with you proposal. > To achieve this check the following: > > Check in Models your connection between proposal to user. Is it set in > both directions? > > Check your find statement in the Controller Probably ProposalsController. > To which depth do you fetch the data? Do you use Containable Behaviour? If > yes you have to do some tweeks there. > > Without your code I can give you no better advise, but at least you know > now where to check and whch code snippets to post to get qualified answers. > > Anja > > > > Am 04.04.2016 um 16:01 schrieb Clement Crownrise: > >> Note that this is my DB relationship, a user has one profile, and the >> proposal table has a User_id colomn, however the profile table is the one >> that contains the user's firstname. >> >> Can someone help me please? >> >> > -- > Sign up for our Newsletter for updates. > http://cakephp.org/newsletter/signup > > We will soon be closing this Google Group. But don't worry, we have > something better coming. Stay tuned for an updated from the CakePHP Team > soon. > > Like Us on FaceBook https://www.facebook.com/CakePHP > Follow us on Twitter http://twitter.com/CakePHP > --- You received this message because you are subscribed to a topic in the > Google Groups "CakePHP" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/cake-php/EAZoK3CB30Y/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > cake-php+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- http://www.clementcrownrise.name/images/nameing.gif -- Sign up for our Newsletter for updates. http://cakephp.org/newsletter/signup We will soon be closing this Google Group. But don't worry, we have something better coming. Stay tuned for an updated from the CakePHP Team soon. Like Us on FaceBook https://www.facebook.com/CakePHP Follow us on Twitter http://twitter.com/CakePHP --- You received this message because you are subscribed to the Google Groups "CakePHP" group. To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
CakePHP 3 - ConnectionManager::config and persisting connection configuration.
Hi, I have a need to, in addition to the default DB connection (from app.php) , add another DB connection specific to the client. Ie every client ends up with 2 connections and depending on where data needs to be retrieved from, the app sets the defaultConnectionName() in the relevant Table object. I am currently loading the 2nd connection info based on the logged in user, on the fly, using ConnectionManager::config(). This works well. However what I've noticed is that the app loads the connection info every time the user makes a request. Would there be a way to persist this connection information between requests, short of storing connection info in Session? Having said that I did also notice that bootstrap gets called for every request - loading the 'default' connection information anyway. Cheerio, Luuk -- Sign up for our Newsletter for updates. http://cakephp.org/newsletter/signup We will soon be closing this Google Group. But don't worry, we have something better coming. Stay tuned for an updated from the CakePHP Team soon. Like Us on FaceBook https://www.facebook.com/CakePHP Follow us on Twitter http://twitter.com/CakePHP --- You received this message because you are subscribed to the Google Groups "CakePHP" group. To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
