Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>To relate the user to the product you want to associate the two entities: <a href="http://symfony.com/doc/current/book/doctrine.html#entity-relationships-associations" rel="nofollow">http://symfony.com/doc/current/book/doctrine.html#entity-relationships-associations</a></p> <pre><code>/** * @ORM\ManyToOne(targetEntity="User", inversedBy="products") * @ORM\JoinColumn(name="user_id", referencedColumnName="id") * You may need to use the full namespace above instead of just User if the * User entity is not in the same bundle e.g FOS\UserBundle\Entity\User * the example is just a guess of the top of my head for the fos namespace though */ protected $user; </code></pre> <p>and for the automatic update field you may be after lifecyclecallbacks: <a href="http://symfony.com/doc/current/book/doctrine.html#lifecycle-callbacks" rel="nofollow">http://symfony.com/doc/current/book/doctrine.html#lifecycle-callbacks</a></p> <pre><code>/** * @ORM\Entity() * @ORM\HasLifecycleCallbacks() */ class Product { /** * @ORM\PreUpdate */ public function setCreatedValue() { $this-&gt;created = new \DateTime(); } } </code></pre> <h2>EDIT</h2> <p>This discussion talks about getting the container in the entity in which case you could then get the security.context and find the user id from that if you mean to associate the current user to the product they edited: <a href="https://groups.google.com/forum/?fromgroups#!topic/symfony2/6scSB0Kgds0" rel="nofollow">https://groups.google.com/forum/?fromgroups#!topic/symfony2/6scSB0Kgds0</a></p> <pre><code>//once you have the container you can get the session $user= $this-&gt;container-&gt;get('security.context')-&gt;getToken()-&gt;getUser(); $updated_at = $user-&gt;getId(); </code></pre> <p>Maybe that is what you are after, not sure it is a good idea to have the container in the entity though, could you not just set the user on the product in the update action in your product controller:</p> <pre><code>public function updateAction(){ //.... $user= $this-&gt;get('security.context')-&gt;getToken()-&gt;getUser(); $product-&gt;setUser($user) } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POAutomatically updating created_by in the model
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USLuke
    1. USLuke
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI would like to know how to get the user id from functions such as setCreatedBy(). Can I do it through the model?
      singulars
      1. PO
      1. USKahWee Teng
    2. COI guess you could `return $this->getUser()->getId()` inside the function. Could you give and example of use in your question and how you want it to work?
      singulars
      1. PO
      1. USLuke
    3. COI edited my question to make it clearer. I want to get the logged in user's id from the model. Is that possible?
      singulars
      1. PO
      1. USKahWee Teng
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload