Read both tables records by INNER JOIN in php

 <?php

$servername = "localhost";
$username = "root";
$password = "";
$database = "studenttwo";

// Create Connection
$conn = new mysqli($servername, $username, $password, $database);

// Check Connection
if ($conn->connect_error) {
    die("Connection failed : " . $conn->connect_error);
}
Above File is mysqli_conn.php File.




Below File is read.php File.
<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0, shrink-to-fit=no">
    <meta http-equiv="X-UA-Compatible" content="ie=edge">
    <title>PHP Table</title>
</head>

<body>
    <table border="1px solid black" cellpadding="5px" cellspacing="2px">
        <tr>
            <th>CID</th>
            <th>CITYNAME</th>
            <th>ID</th>
            <th>NAME</th>
            <th>PERCENTAGE</th>
            <th>AGE</th>
            <th>GENDER</th>
            <th>CITY</th>
        </tr>
        <?php
        include("mysqli_conn.php");

        $sql = "SELECT * FROM city INNER JOIN personal on city.cid = personal.city";
        $result = $conn->query($sql);

        if ($result->num_rows > 0) {
            while ($row = $result->fetch_assoc()) {
                echo "<tr>";
                echo "<td><br>" . $row["cid"] . "</td>" . "<td>" . $row["cityname"] . "</td>" . "<td>" . $row["id"] . "</td>" . "<td>" . $row["name"] . "</td>" . "<td>" . $row["percentage"] . "</td>" . "<td>" . $row["age"] . "</td>" . "<td>" . $row["gender"] . "</td>" . "<td>" . $row["city"] . "</td>" . "<br></td>";
                echo "</tr>";
            }
        } else {
            echo "No Record Found.";
        } ?>
    </table>
</body>

</html>



Comments

Post a Comment

Popular posts from this blog

Ajax Insert Records in Database Tutorial in PHP

Image
  <?php $servername = "localhost" ; $username = "root" ; $password = "" ; $dbname = "test" ; // Create Connection $conn = new mysqli ( $servername , $username , $password , $dbname ); // Check Connection if ( $conn -> connect_error ) {     die ( "Connection Failed : " . $conn -> connect_error ); } Above File is mysqli_conn.php File Below File is show-data.php File <! DOCTYPE html > < html lang = "en" > < head >     < meta charset = "UTF-8" >     < meta name = "viewport" content = "width=device-width, initial-scale=1.0, shrink-to-fit=no" >     < meta http-equiv = "X-UA-Compatible" content = "ie=edge" >     < title > Show Data </ title > </ head > < body >     < table id = "main" border = "0" cellspacing = "0" >         < tr >             < td id =...
Read more

Displaying Database data using Class, Object, Constructor, Destructor in PHP MySql

Image
  <?php class Employee {     private $conn ;     public function __construct ()     {         $this -> conn = new mysqli ( "localhost" , "root" , "" , "database_ci" );         if ( $this -> conn -> connect_error ) {             die ( "Connection Failed : " . $this -> conn -> connect_error );         }     }     public function __destruct ()     {         $this -> conn -> close ();     }     public function getAllEmployees ()     {         $data = [];         $sql = " SELECT * FROM register " ;         $result = $this -> conn -> query ( $sql );         if ( $result -> num_rows > 0 ) {             while ( $row = $result -...
Read more

SubQuery with EXISTS and NOT EXISTS in PHP

 SELECT with SubQuery Syntax : SELECT columns FROM table1 WHERE column = (SELECT columns FROM table2 WHERE condition); In "personal" table, there are 6 columns named id, name, percentage, age, gender, city. In "personal" table, column name "id" is PRIMARY KEY and column name "city" is FOREIGN KEY. In "courses" table, there are 2 columns named course_id and course_name. In "courses" table, column name "course_id" is PRIMARY KEY. In "city" table, there are 2 columns named cid and cityname. In "city" table, column name "cid" is PRIMARY KEY. If we want to select records from "personal" table who belong to Delhi from "city" table using SubQuery then we can use below shown sql query : SELECT name FROM personal WHERE city = (SELECT cid FROM city WHERE cityname = "Delhi"); If we want to select records from "personal" table who belong to Delhi and Agra from...
Read more