Databases
StackOverflow2013
Postsdbo
PODatabase and query to store and retrieve friend list
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PODatabase and query to store and retrieve friend list
    primarykey
    data
    text
    <p>I am developing a module in website to save and retrieve friend list. I am using Zend Framework and for DB handling I am using Doctrine(ORM). </p> <p>There are two models:</p> <p>1) <strong>users</strong> that stores all the users<br> 2) <strong>my_friends</strong> that stores the friend list (that is reference table with M:M relation of user)</p> <h2>the structure of <strong>my_friends</strong> is following</h2> <hr> <p>...id..........user_id............friend_id........approved....<br> ...10.........20 ..................25...................1..........<br> ...10.........21 ..................25...................1..........<br> ...10.........22 ..................30...................1..........<br> ...10.........25 ..................30...................1.......... </p> <hr> <p>The Doctrine <strong>query</strong> to retrieve friend list id following </p> <pre><code>$friends = Doctrine_Query::create()-&gt;from('my_friends as mf') -&gt;leftJoin('mf.users as friend') -&gt;where("mf.user_id = 25") -&gt;andWhere("mf.approved = 1"); </code></pre> <p>Suppose I am viewing the <strong>user no.- 25</strong>.<br> With this query I am only getting the <strong>user no.- 30</strong>.<br> where as <strong>user no.- 25</strong> is also approved friend of <strong>user no.- 20 and 21</strong>.<br> Please guide me, what should be the query to find all friend and is there any need to change the DB structure. </p> <p><strong>YAML</strong><br> Member:<br> columns: </p> <pre><code>id: primary: true type: integer notnull: true autoincrement: true userName: unique: true type: string(255) Address_id: type: integer(4) MemberPhoto_id: type: integer relations: address: class: Address local: Address_id foreign: id memberPhotos: class: MemberThumbnail foreignAlias: member local: MemberPhoto_id foreign: id refPeeps: columns: id: primary: true unique: true type: integer autoincrement: true Member_id: type: integer notnull: true Peep_id: type: integer notnull: true relations: Member: local: Member_id foreign: id Member: local: Peep_id foreign: id </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCœur
    1. USAmritpal singh
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTDuplicate
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. PODatabase and query to store and retrieve friend list
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PODatabase and query to store and retrieve friend list
      1. USSurinderpal
      1. VTFavorite
    3. VO
      singulars
      1. PODatabase and query to store and retrieve friend list
      1. This table or related slice is empty.
      1. VTUpMod
    1. COwhat is the $id value u passing in the query
      singulars
      1. PODatabase and query to store and retrieve friend list
      1. USGhostman
    2. CO$id value is 25. Sorry for not reffering that
      singulars
      1. PODatabase and query to store and retrieve friend list
      1. USAmritpal singh
    3. COIm not familiar with doctrine,but have you tried using `where("rp.user_id = 25 && rp.friend_id = 25")` or such method to get from both columns?
      singulars
      1. PODatabase and query to store and retrieve friend list
      1. USLawrence Cherone
 

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