Home Tutorial Php Sql PHP SQL Left Join

 
 

Share on Google+Share on Google+
PHP SQL Left Join
Posted on: December 10, 2010 at 12:00 AM
Advertisement
This Example illustrates how to use left join clause in the sql query. The left join return all rows from the left table, even if there are no matches in the right table.

PHP SQL Left Join

 This Example illustrates how to use left join clause in the sql query. The left join return all rows from the left table, even if there are no matches in the right table.

In this example left join is used to join the two table data according to the "emp" table id. The fetched data displays in 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 the browser as below and the complete source code is available below for download or copy the code as per your need.

The "LEFT JOIN" keyword is used for join the table data.

Table: emp

Table: Message

Source Code of leftJoin.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 LEFT 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 Left 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