selecting data from two tables in database php

113
<?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

Comments

Submit
0 Comments

More Questions

php array has valuephp string to int php string replace
php string contains substringphp append to array laravel run seed
php parse jsonphp check if string contains word php split string
php artisan make migrationcomposer ignore requirements in_array in php
Your requirements could not be resolved to an installable set of packages.magento 2 composer install laravel-ui v3.0.0 requires php ^7.3 - your php version (8.0.2) does not satisfy that requirement.
schema defaultstringlength(191)laravel form validation laravel table in model
use wordpress functions in external php filecomposer ignore platform reqs phpmailer send attachment
item count in cart quantitiy woocommerceLaravel seed timestamps columns php convert degrees to radians
php numbers from 1 to 100 arrayphp file read php use variable as object key
php in array keylaravel controller code for editing a column in a table htaccess post max size
laravel timestamps on pivot tablephp array join convert string to array laravel
wordpress get post by idcomposer cache clean laravel new project command
jetstream seed user with teamphpunit stop on failure get record of last 24 hours in laravel
wordpress get fiture imageadmin bar hide wordpress laravel when
how to create shortcodelaravel decrement check if all values in array are equal php
redirect previous pagehow to allow cors through header in php events.js:174 error discord.js
C
CSS
Objective-C
PHP
Java
C++
Javascript
Html
Python
SQL
Swift
Ruby
Go
R
TypeScript
Kotlin
Assembly
VBA
Scala
Rust
Elixir
Dart
Haskell
Perl
Fortran
Matlab
Scheme
Julia
Lua
Delphi
Pascal
Solidity
BASIC
ActionScript
Csharp