How to get data from two tables in mysql database using php?

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31

<?php
// Connect to the database
$host = 'localhost';
$username = 'username';
$password = 'password';
$database = 'database_name';

$connection = mysqli_connect($host, $username, $password, $database);

if (!$connection) {
    die("Connection failed: " . mysqli_connect_error());
}

// SQL query to get data from two tables
$sql = "SELECT table1.column1, table1.column2, table2.column1
        FROM table1
        JOIN table2 ON table1.common_column = table2.common_column";

$result = mysqli_query($connection, $sql);

if (mysqli_num_rows($result) > 0) {
    // output data of each row
    while($row = mysqli_fetch_assoc($result)) {
        echo "Column1: " . $row["column1"]. " - Column2: " . $row["column2"]. " - Column3: " . $row["column3"]. "<br>";
    }
} else {
    echo "0 results";
}

mysqli_close($connection);
?>