PHP SQL Inner Join


 

PHP SQL Inner Join

This Example illustrates how to use the inner join clause in the sql query. The inner join return rows when there is at least one match in both tables.

This Example illustrates how to use the inner join clause in the sql query. The inner join return rows when there is at least one match in both tables.

PHP SQL Inner Join

 This Example illustrates how to use the inner join clause in the sql query. The inner join return rows when there is at least one match in both tables.

This is the good example to understand inner join clause because in this example we use a join clause between only two table and display it as the table format on the browser. We use "emp" table and "message" table and find the emp.name from emp table and find the message.messages from message table where emp.emp_id and message.emp_id both are equal. The fetched result display on teh browser as below and the complete source code is available below for download or copy the code as per your need.

The "INNER JOIN" keyword is used for join the data.

Table: emp

Table: message

Source Code of innerJoin.php

<?php
  $con = mysql_connect("localhost","root","root");
  if (!$con) {
    die('Could not connect: ' . mysql_error());
  }

  mysql_select_db("test", $con);
  $result = mysql_query("SELECT emp.name, message.messages 
   FROM emp INNER JOIN message ON emp.emp_id = message.emp_id"
);
  echo "<table border='1'>
    <tr>
      <th>Name</th>
      <th>Message</th>
    </tr>";
    while ($row = mysql_fetch_array($result)) {
      echo "<tr>";
      echo "<td>" . $row['name'] "</td>";
      echo "<td>" . $row['messages'] "</td>";
      echo "</tr>";
    }
  echo "</table>";
  
  mysql_close($con);
?>

 

Output:

 

Download Source Code

Ads