PHP PDO Multiple Table join
wobsoriano
I have multiple tables and I want to access the fields in a specific table. Here are the table schemas:
Each tbl_acct has one tbl_unit. A tbl_unit has many tbl_groups and a tbl_groupcontact consist of the contacts and the related group. Every time I log in, I set a session where $_SESSION['unitid'] = $row['unitid'];.
What I wanted to do is to access the fields in the tbl_contacts. For now my code is here:
$data = $conn->prepare("SELECT * FROM tbl_groups LEFT JOIN tbl_groupcontact ON tbl_groups.id=tbl_groupcontact.group_id WHERE tbl_groups.unitid = ?");
$data->execute(array($_SESSION['unitid']));
foreach ($data as $row) {
echo $row['fname'] . " " . $row['lname']. "<br />";
}
As you can see, I can related the tbl_groups and tbl_groupcontact in my code however, I can't get the fields in the tbl_contacts. Am I missing something here? Any help would be much appreciated.
shudder
You need to join another table.
SELECT tbl_contacts.*
FROM tbl_groups
INNER JOIN tbl_groupcontact ON tbl_groupcontact.group_id = tbl_groups.id
INNER JOIN tbl_contacts ON tbl_contacts.id = tbl_groupcontact.contact_id
WHERE tbl_groups.unitid = ?
No need for (slower) LEFT JOIN btw - use it when you want to retrieve records from (left-side) table even when there's no match found in joined (right-side) table (it's columns will be filled with nulls in this case).
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
Related
Related Related
- 1
php mysql join query on same table using pdo
- 2
PHP query to Join multiple Table rows
- 3
php pdo select multiple rows and insert to other table with LIMIT
- 4
php pdo not updating table
- 5
PHP PDO select with INNER JOIN
- 6
PHP PDO select with INNER JOIN
- 7
PHP MySQL Join Users Table to Multiple Columns & Rows
- 8
PHP MySQL Join Users Table to Multiple Columns & Rows
- 9
Join 1 Row to Multiple Rows in PDO
- 10
Join 1 Row to Multiple Rows in PDO
- 11
SQLite: Multiple Table Join
- 12
SQL - Join multiple table
- 13
join multiple table
- 14
Inner Join Multiple table
- 15
Multiple join on same table
- 16
PHP Mysql PDO and unlock table
- 17
PHP pdo echo results into table
- 18
PHP PDO Multiple image INSERT
- 19
PHP PDO Multiple Prepare Statement
- 20
Update with LEFT JOIN pdo php mysql
- 21
IN statment on a MySQL INNER JOIN php pdo
- 22
PHP PDO mysql prepared statment and join
- 23
SQL inner join error with PHP PDO
- 24
Left Join VS Inner Join lesser rowcount mysql pdo php
- 25
SQL Server multiple table JOIN
- 26
Multiple Left Join on same table
- 27
Join Table With Multiple Condition Laravel
- 28
join same table multiple times
- 29
SQL Server multiple table JOIN
Comments