Display two table data in a single table using sql inner join query

In this post i am explain about to display the two mysql table data in single table using mysql inner join query . The two tables are personalinfo, salaryinfo in that two tables i am using common id is called as a empid using this i am selected two different table datas  in single view.

 I am displaying the data name, contactnumber from personallinfo table and then esi, pf, salary from salaryinfo table and then i am displaying in a single table using empid as a common id.

display the table using inner join query

Create Database:

create database emp;

Create Table: personalinfo
CREATE TABLE  `emp`.`personalinfo` (
`empid` int(6) not null,
`name` VARCHAR( 150 ) NOT NULL ,
`contactnumber` INT( 200 ) NOT NULL ,
`mail` VARCHAR( 200 ) NOT NULL

Create Table: salaryinfo

CREATE TABLE `emp`.`salaryinfo` (
`empid` int(6) not null,
`salary` varchar(5) not null,
`esi` varchar(4) not null,
`pf` varchar(4) not null


<title>Display more then one table data in single table using joinquery</title>
<body bgcolor="#85B80E">
// Check connection
if (mysqli_connect_errno())
  echo "Failed to connect to MySQL: " . mysqli_connect_error();

$result = mysqli_query($con,"SELECT personalinfo.name, personalinfo.contactnumber, salaryinfo.esi, salaryinfo.pf, salaryinfo.salary FROM personalinfo INNER JOIN salaryinfo ON personalinfo.empid=salaryinfo.empid");
echo " <center><h1>JOIN QUERY </h1></center>";
echo "<table border='1' align='center' cellpadding='15' bgcolor='#FFFFFF'>

while($row = mysqli_fetch_array($result))
  echo "<tr>";
  echo "<td>" . $row['name'] . "</td>";
  echo "<td>" . $row['contactnumber'] . "</td>";
  echo "<td>" . $row['esi'] . "</td>";
  echo "<td>" . $row['pf'] . "</td>";
  echo "<td>" . $row['salary'] . "</td>";
  echo "</tr>";
echo "</table>";

<table bgcolor="#FFFFFF"

Download Code

Post a comment