<?php
$connect = mysqli_connect("localhost", "root", "", "zzz");
$sql = "SELECT * FROM brand INNER JOIN product ON brand.brand_id = product.brand_id";
$result = mysqli_query($connect, $sql);
?>
<!DOCTYPE html>
<html>
<head>
<title>Webslesson Tutorial | Fetch Data from Two or more Table Join using PHP and MySql</title>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.2.0/jquery.min.js"></script>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" />
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js"></script>
</head>
<body>
<br />
<div class="container" style="width:500px;">
<h3 align="">Fetch Data from Two or more Table Join using PHP and MySql</h3><br />
<div class="table-responsive">
<table class="table table-striped">
<tr>
<th>Brand Name</th>
<th>Product Name</th>
</tr>
<?php
if(mysqli_num_rows($result) > 0)
{
while($row = mysqli_fetch_array($result))
{
?>
<tr>
<td><?php echo $row["brand_name"];?></td>
<td><?php echo $row["product_name"]; ?></td>
</tr>
<?php
}
}
?>
</table>
</div>
</div>
<br />
</body>
</html>SELECT tbl_a.column1 , tbl_a.column2
tbl_b.column1 , tbl_b.column2
FROM tbl_a INNER JOIN tbl_b
ON tbl_a.commonfield=tbl_b.commonfield| Code Example |
|---|
| Php :: laravel add many to many |
| Php :: laravel collection pop |
| Php :: where to add browscap php |
| Php :: square root |
| Php :: Laravel get all parent categories for each category |
| Php :: php class instance |
| Php :: wp_delete_attachment unlink |
| Php :: set config key dynamic laravel |
| Php :: @yield laravel |
| Php :: PHP exif_read_data() |
| Php :: $wpdb foreach |
| Php :: php get error |
| Php :: foreach loop in php stack overflow |
| Php :: laravel remove controller |
| Php :: php Convert multidimensional array into single array |
| Php :: how to use or where in laravel |
| Php :: wordpress shortcode api |
| Php :: array_diff php |
| Php :: server.php not found |
| Php :: PHP OOP - Inheritance |
| Php :: laravel 8 php version requirements |
| Php :: closure in php |
| Php :: add column migration laravel 8 |
| Php :: laravel blade @if 3 varabile |
| Php :: php get variable name as a string |
| Php :: php session |
| Php :: laravel package console command |
| Php :: laravel with select |
| Php :: download html table to excel |
| Php :: notification in laravel 8 |