Untitled

<!DOCTYPE html>
<html>
<head>
    <title>Baojili</title>
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/3.3.7/css/bootstrap.min.css" />
    <link rel="stylesheet" type="text/css" href="//cdn.datatables.net/1.10.11/css/jquery.dataTables.min.css">
</head>
<body>
<?php include_once ("manajer.php"); ?>
 <div class="container">
    <h1 align="center">Total Stock per Item</h1>
    <br/>
    <table id="dataTables" class="table table-bordered table-striped" cellspacing="0" width="100%">
        <thead>
            <tr>
                <th>NO.</th>
                <th>Kode Barang</th>
                <th>Size</th>
                <th>Total Stok</th>
                <th>Nama Lokasi</th>
                <th>Stok</th>
            </tr>
        </thead>

        <tbody>
            <?php
            $conn = new mysqli("localhost", "root", "BiN4iNforMaTIka33", "baojili");
            if ($conn->connect_errno) {
                echo "Failed to connect to MySQL: " . $conn->connect_error;
            }

            $no = 1;
            $res = $conn->query("SELECT t_item.ItemID, t_item.Code, t_item.Size, SUM( Stock ) AS TotalStock, group_concat(t_location.Name) as Name, group_concat(t_stock.Stock) as Stock
FROM t_stock
LEFT JOIN t_location ON t_stock.LocationID = t_location.LocationID
LEFT JOIN t_item ON t_stock.ItemID = t_item.ItemID
GROUP BY ItemID");
            while($row = $res->fetch_assoc()){
                echo '
                <tr>
                    <td>'.$no.'</td>
                    <td>'.$row['Code'].'</td>
                    <td>'.$row['Size'].'</td>
                    <td>'.$row['TotalStock'].'</td>
                                        <td>'.$row['Name'].'</td>
                                        <td>'.$row['Stock'].'</td>
                </tr>
                ';
                $no++;
            }
            ?>
        </tbody>
    </table>
    </div>
    <script src="http://code.jquery.com/jquery-1.12.0.min.js"></script>
    <script src="//cdn.datatables.net/1.10.11/js/jquery.dataTables.min.js"></script>
    <script>
    $(document).ready(function() {
        $('#dataTables').DataTable();
    } );
    </script>
</body>
</html>