-1

I'm trying to connect database with mysql query and show the product and its price but the code only returns the what i wrote. It only shows the code i wrote on the page and not the css code or images. I have an image below of what i am trying to say. Please help


<?php

include ('connect.php');
include ('Header.php');
?>
<!DOCTYPE html>
<html>
<head>
    
    <title>Information</title>  
</head>
<body>

    <div class="container-fluid" > 
    <!--start banner-->

    <div>

    <h4 align='center'><span>Latest Gym Equipments</span></h4>
    </div>
    <div>
    <div>
        <table class="table mt-5">
            
        <tbody>
        <?php 
        {
            $select="Select * From Product Order by ProductID DESC LIMIT 4";
            $ret   =mysqli_query($connect,$select);
            $count=mysqli_num_rows($ret);
            for ($rows=0; $rows < $count ; $rows+=3)
            {
                echo"<tr>";
                $select2="Select * From Product Order by ProductID DESC LIMIT $rows,3";
                $query2=mysqli_query($connect,$select2);
                $subcount=mysqli_num_rows($query2);
                for ($cols=0 ; $cols < $subcount ; $cols++){
                $data=mysqli_fetch_array($query2);
                $productid=$data['ProductID'];
                echo "<th>";
                echo "<img src='".$data['ProductImage']."' width='300px' height='300px'>";
                echo "<p>".$data['ProductName']."</p>";
                echo"<p>Price  :".$data['Price']."</p>";                
                echo"<a href='Detail.php?PID=$productid'>Detail</a>";
                echo"</th>";
                }

                echo"</tr>";
            }
        }
        ?>
        </tbody>
        </table>
    </div>
    </div>

picture of output

Ruskkz
  • 11
  • 3

0 Answers0