Databases
StackOverflow2013
Postsdbo
POCheck If Some User ID's Are Friends With The Logged In User In A Single Query
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POCheck If Some User ID's Are Friends With The Logged In User In A Single Query
    primarykey
    data
    text
    <p>I have a simple friends system on my site. Now I'm trying to create a multi-user group messaging system but only between friends. The "To" values of my messaging system are comma values, I want to check if they all are friend with the person sending the message.</p> <p>For example, I can get all of a user's friends by the following query:</p> <pre><code>SELECT relation_setter user_id FROM users_relationships WHERE relation_getter = {$logged_in_user} AND active = 1 UNION SELECT relation_getter user_id FROM users_relationships WHERE relation_setter = {$logged_in_user} AND active = 1 </code></pre> <p>and I have <code>natasha, reeta</code> as a $_POST['to'] value from my message form which I then convert to user ids and get something like <code>126152, 112238</code></p> <p>Now how do I check if these ids are both friends with the logged in user, in a single query. I don't want to run my is_friend function in a loop, which check if a single userid is friends with the logged in user.</p> <p><strong>Relationships Schema:</strong></p> <p><strong>users_relationships</strong></p> <pre><code>id PK relation_setter FK user_id relation_getter FK user_id active smallint(1) </code></pre> <p>The <code>relation_setter</code> is the one who sent the friend request. To get all my friends I get all the IDs where my ID is either the <code>relation_setter</code> or <code>relation_getter</code>.</p> <p><strong>users</strong></p> <pre><code>user_id PK name username password etc etc... </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USAayush
    1. USAayush
    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. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POCheck If Some User ID's Are Friends With The Logged In User In A Single Query
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POCheck If Some User ID's Are Friends With The Logged In User In A Single Query
      1. This table or related slice is empty.
      1. VTUpMod
    1. COWhy don´t you get all friends of the sender and then iterate through the "To"-list to check if these persons are within the friends array/list?
      singulars
      1. POCheck If Some User ID's Are Friends With The Logged In User In A Single Query
      1. USTobias
    2. COis it only important to know if all are friends or not; or to know which among the list are friends?
      singulars
      1. POCheck If Some User ID's Are Friends With The Logged In User In A Single Query
      1. USMikeb
    3. COwhat is your schema like?
      singulars
      1. POCheck If Some User ID's Are Friends With The Logged In User In A Single Query
      1. USdidierc
 

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