.-.-.-.-.-

<?php
$title = "Product Kit Report";
include 'header.php';
?>
<div class="container-fluid">

<div class="row">
        <div class="col-sm-12">
            <div class="page-title-box">
                <h4 class="page-title">Product KIt Order</h4>
                <ol class="breadcrumb">
                    <li class="breadcrumb-item"><a href="index.php">Home</a></li>
                    <li class="breadcrumb-item"><a href="">Support</a></li>
                    <li class="breadcrumb-item active">Product KIt Order</li>
                </ol>

</div>
        </div>
    </div>

<table class="table mb-0  table-bordered table-striped datatable">
                        <thead>
                            <tr>
                                <th>S. No.</th>
                                <th>User</th>
                                <th>Products</th>
                                <th>Date</th>
                                <th>Status</th>
                            </tr>
                        </thead>
                        <tbody>
                            <?php
                            $query = "SELECT u.* FROM `user` u WHERE u.uid IN ( SELECT DISTINCT(uid) FROM product_kit_user ) ORDER BY u.name DESC ";

$rs = mysqli_query($connection, $query);
                            $i = 1;
                            if ($rs) {
                                while ($row = mysqli_fetch_object($rs)) {
                                    $product_kit_result = mysqli_query($connection, "SELECT pk.*, pku.datetime AS datetime FROM product_kit pk INNER JOIN product_kit_user pku ON pk.pid = pku.pid WHERE pku.uid = '$row->uid'");
                                    $product_csv = "";
                                    $datetime = NULL;
                                    while ($row1 = mysqli_fetch_object($product_kit_result)) {
                                        $product_csv .= "$row1->pname ($row1->pcode), ";
                                        $datetime = $row1->datetime;
                                    }
//    while ($bank = mysqli_fetch_object($rs)) {
                                    ?>
                                    <tr>
                                        <td><?php echo $i++; ?></td>
                                        <td><?php echo $row->name . " (" . $row->login_id . ")"; ?></td>
                                        <td><?php echo $product_csv; ?></td>

<td><?php echo date("d M, Y H:i", strtotime($datetime)); ?></td>
                                        <td>Requested</td>
                                    </tr>
                                    <?php
                                }
                            }
                            ?>
                        </tbody>
                    </table>
                    <?php //echo $pager->renderFullNav();    ?>  
                </div>
            </div>
        </div> 
    </div>
    
</div>

<?php include 'footer.php'; ?>

/home2/wtmwscom/public_html/js/.././admin/scripts/../product_kit.php