<?php
session_start();
include("connection.php");
$user_profile=$_SESSION['user_name'];
// if($user_profile==true){

// }else{
//     header('location:index.php');
// }
?>
              <?php 
include("includes/header.php");
include("includes/sidebar.php");
?>  
                <div class="app-main__outer">
                    <div class="app-main__inner">
                        <div class="app-page-title">
                            <div class="page-title-wrapper">
                                <div class="page-title-heading">
                                    <div class="page-title-icon">
                                    <i class="fas fa-tachometer-alt"></i>

                                    </div>
                                    <div>Admin Dashboard
                                        
                                    </div>
                                </div>
                                <div class="page-title-actions">
                                    <button type="button" data-toggle="tooltip" title="Example Tooltip" data-placement="bottom" class="btn-shadow mr-3 btn btn-dark">
                                        <i class="fa fa-star"></i>
                                    </button>
                                    
                                </div>   
                             </div>
                         </div>
                                      
                         <div class="row">
    <div class="col-md-12">
        <div class="main-card mb-3 card">
            <div class="card-header">Product-Details
            <div class="btn-actions-pane-right">
                    <div role="group" class="btn-group-sm btn-group">
                        <a href="create_product_details.php">
                            <button class="active btn btn-focus">Add</button>
                        </a>
                    </div>
                </div>
            </div>
            <div class="table-responsive">
                <table id="main-category-table"
                    class="align-middle mb-0 table table-borderless table-striped table-hover">
                    <thead>
        <tr>
        <th class="text-center">#</th>
            <th class="text-center">Category</th>
            <th class="text-center">Product</th>
            <th class="text-center">Product_details</th>
            <!-- <th class="text-center">Attribute</th>
            <th class="text-center">Value</th> -->
            <th class="text-center">Actions</th>
        </tr>
    </thead>
    <tbody>
        <?php
            $i = 1;
            include("connection.php");
            $sql = "SELECT pd.*, p.title AS product_name ,p.category AS product_cat
            FROM product_details pd
            LEFT JOIN productpage p ON pd.product_id = p.id";
            $result = mysqli_query($conn, $sql);
            if ($result) {
                while ($row = mysqli_fetch_assoc($result)) {
                    $id = $row['id'];
                $category = $row['product_cat'];
                $product_name = $row['product_name'];
                $product_details = $row['product_details'];
                // $attribute = $row['attribute'];
                // $value = $row['value'];
                    echo '
                        <tr>
                            <td class="text-center text-muted">' . $i . '</td>
                            <td class="text-center">' . ucfirst($category) . '</td>
                    <td class="text-center">' . $product_name . '</td>
                      <td class="text-center">' . $product_details . '</td>
                   
                            <td class="text-center">
                                <a href="update_product_details.php?update_id=' . $id . '" class="btn btn-primary btn-sm">Update</a>
                                <a href="delete_product_details.php?delete_id=' . $id . '" class="btn btn-danger btn-sm">Delete</a>
                            </td>
                        </tr>';
                    $i++;
                }
            }
        ?>
    </tbody>
</table>
            </div>
        </div>
    </div>
</div>

<script>
    $(document).ready(function () {
        $('#main-category-table').DataTable();
    });
</script>

                        </div>

<?php
include("includes/footer.php");
?>
