elite_dev/view_products.php at main · fikrynuhuman183/elite_dev · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
<?php include './layouts/header.php'; ?>
<?php include './layouts/sidebar.php'; ?>


      <!-- Right side column. Contains the navbar and content of the page -->
      <div class="content-wrapper">
        <!-- Content Header (Page header) -->
        <section class="content-header">
          <h1>
            Add Product

          </h1>
          <ol class="breadcrumb">
            <li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
            <li><a href="#">Products</a></li>
            <li class="active">Add Product</li>
          </ol>
        </section>

        <!-- Main content -->
        <section class="content">
          <div class="row">
            <div class="col-xs-12">
              <div class="box">
                <div class="box-header">
                  <h3 class="box-title">Products</h3>
                  <div class="box-tools">
                    <div class="input-group">
                      <input type="text" name="table_search" class="form-control input-sm pull-right" style="width: 150px;" placeholder="Search"/>
                      <div class="input-group-btn">
                        <button class="btn btn-sm btn-default"><i class="fa fa-search"></i></button>
                      </div>
                    </div>
                  </div>
                </div><!-- /.box-header -->
                <div class="box-body table-responsive no-padding">
                  <table class="table table-hover">

                    <tr>
                      <th>Product Code</th>
                      <th>Product Name</th>
                      <th>Quantity</th>
                      <th>Cost</th>
                      <th>Selling Price</th>
                      <th>Actions</th>
                    </tr>
                    <?php
  					          $sql = "SELECT * FROM `tbl_products`";
  					          $rs= $conn->query($sql);
  					          if($rs->num_rows > 0){
  					            while($row = $rs->fetch_assoc()){
  					        ?>

                    <tr>
                      <td><?= $row['product_code'] ?></td>
                      <td><?= $row['product_name'] ?></td>
                      <td><?= $row['product_quantity'] ?></td>
                      <td><?= $row['product_cost'] ?></td>
                      <td><?= $row['product_selling_price'] ?></td>
                    </tr>

                    <?php
                      }}
                     ?>
                  </table>
                </div><!-- /.box-body -->
              </div><!-- /.box -->
            </div>
          </div>  <!-- /.row -->
        </section><!-- /.content -->
      </div>
    </div><!-- /.content-wrapper -->
<?php include './layouts/footer.php'; ?>