Home Tutorial Php Sql PHP SQL Inner Join

 
 

PHP SQL Inner Join
Posted on: December 10, 2010 at 12:00 AM
Advertisement
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

Advertisement

Related Tags for PHP SQL Inner Join:


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: December 10, 2010

Recommend the tutorial

Advertisements Advertisements
 

 

 

DMCA.com