Right Join in PHP Source Code

Right join shows all rows from the Right table and shows only matching rows from the left table.

In this example,t4tutorials_finance is the left table and user_details is the right table.

What will be displayed?

Left join shows all rows from the left table user_detailsand shows only matching rows from the right table t4tutorials_finance .

Left join Query in MySQLi

select * from t4tutorials_finance right join user_details on user_details.userid=T4Tutorials_finance.t4tutorials_id

<!DOCTYPE html>
<html>
<head>
	<title>Left Join Tables using Left Join PHP and MySQLi</title>
</head>
<body>
	<table border="1">
		<thead>
			<th>Salary</th>
			<th>Firstname</th>
			<th>Lastname</th>
		</thead>
		<tbody>
		<?php
	$conn = mysqli_connect("localhost","root","","t4tutorials_Join");
	// Check connection
	if (mysqli_connect_errno())
 	 {
	  echo "Failed to connect to MySQL: " . mysqli_connect_error();
	  }
		$query=mysqli_query($conn,"select * from `t4tutorials_finance` right join user_details on 	user_details.userid=T4Tutorials_finance.t4tutorials_id");
			while($row=mysqli_fetch_array($query)){
				?>
					<tr>
					<td><?php echo $row['t4tutorials_salary']; ?></td>
					<td><?php echo $row['firstname']; ?></td>
					<td><?php echo $row['lastname']; ?></td>
					</tr>
				<?php
			}
		?>
			
		</tbody>
	</table>
</body>
</html>

<!DOCTYPE html>

<html>

<head>

<title>Left Join Tables using Left Join PHP and MySQLi</title>

</head>

<body>

<thead>

<th>Salary</th>

<th>Firstname</th>

<th

>Lastname</th>

</thead>

<tbody>

<?php

$conn = mysqli_connect("localhost","root","","t4tutorials_Join");

// Check connection

if (mysqli_connect_errno())

{

echo "Failed to connect to MySQL: " . mysqli_connect_error();

}

$query=mysqli_query($conn,"select * from `t4tutorials_finance` right join user_details on user_details.userid=T4Tutorials_finance.t4tutorials_id");

while($row=mysqli_fetch_array($query)){

<tr>

</tr>

<?php

}

</tbody>

</table>

</body>

</html>

Output

Salary	Firstname	Lastname
80000	fazal	rehman
	shamil	khan
	sharjeel	bhutta

Right Join Program Example in PHP, MySQLi

The database for the code is shown below in the figure.

Video Lecture

Database t4tutorials_join

Download the database for right join

Table structure for table t4tutorials_finance

Column	Type	Null	Default
*t4tutorials_id*	int(222)	No
t4tutorials_salary	int(222)	No

Table structure for table user_details

Column	Type	Null	Default
*userid*	int(11)	No
firstname	varchar(30)	No
lastname	varchar(30)	No

Right Join in PHP Source Code
By: Prof. Dr. Fazal Rehman | Last updated: August 14, 2022