How to fetch data using JOIN clause in php?

Question

I want to match contact from both tables and fetch details of mother in mysql using JOIN clause in php.

Table students

name	mother	mcontact
Larry	Wanda	12345678

Table parents

name	parent_of	relation	contact	other
Wanda	Larry	mother	12345678	any other details

And this is my code

$user_query = 'SELECT students.mcontact FROM `students` JOIN `parents` ON students.mcontact=parents.contact';
$user_result = mysqli_query($db_conn, $user_query);

while ($users = mysqli_fetch_object($user_result)){

  echo $users->name}

It is showing me an error Undefined property $name

If there is any other way to do it please enlighten me.

you need to include `students.name` in the select, your only returning `students.mcontact` — Lawrence Cherone, May 25 '22 at 16:27

bmckay · Answer 1 · 2022-05-25T16:34:28.500

0

Also, as Lawrence mentioned abouve, adding the students.name to the sql query like so.

$user_query = 'SELECT students.mcontact, students.name FROM `students` JOIN `parents` ON students.mcontact=parents.contact';

edited May 25 '22 at 16:34

answered May 25 '22 at 16:28

bmckay

19
1
4

`mysqli_fetch_object()` just fetches one row, not an array of rows. You can't use `foreach` there. – Barmar May 25 '22 at 16:32
You're confusing it with `mysqli_fetch_all($user_result, MYSQLI_OBJECT)` – Barmar May 25 '22 at 16:33
Ah. That's right. Will edit to not confuse. Thanks – bmckay May 25 '22 at 16:34

score 0 · Answer 2 · answered May 25 '22 at 16:41

0

$user_query = 'SELECT students.mcontact,students.name,parents.name as parentName FROM `students` JOIN `parents` ON students.mcontact=parents.contact';
$user_result = mysqli_query($db_conn, $user_query);

answered May 25 '22 at 16:41

hare2016

1

How to fetch data using JOIN clause in php?

2 Answers2