<?php include 'header.php'; ?> 
<div class="content-wrapper">
  <!-- START PAGE CONTENT-->
  <div class="page-heading">
    <h1 class="page-title">CONTACT</h1>
    <ol class="breadcrumb">
      <li class="breadcrumb-item">
        <a href="index.html">
          <i class="la la-home font-20"></i>
        </a>
      </li>
    </ol>
  </div>
  <div class="page-content fade-in-up">
    <div class="row">
      <div class="col-md-12">
        <div class="ibox">
          <div class="ibox-head">
            <div class="ibox-title">Table</div>
          </div>
          <div class="ibox-body">
            <ul class="nav nav-tabs tabs-line">
              <li class="nav-item">
                <a class="nav-link active" href="#tab-7-1" data-toggle="tab">
                  <i class="fa fa-line-chart"></i>View</a>
              </li>
              <li class="nav-item">
                <a class="nav-link" href="#tab-7-2" data-toggle="tab">
                  <i class="fa fa-heartbeat"></i>Add</a>
              </li>
            </ul>
            <div class="tab-content">
              <div class="tab-pane fade show active" id="tab-7-1">
                                <div class="ibox">
                  <div class="ibox-head">
                    <div class="ibox-title">Responsive Table</div>
                  </div>
                  <div class="ibox-body">
                    <div class="table-responsive">
                      <table class="table">
                        <thead>
                          <tr>
                            <th width="50px"></th>
                            <th>Title</th>
                            <th>Decripation</th>
                            <th>Contact No</th>
                            <th>Address</th>
                            <th>Time</th>
                            <th>Actions</th>
                          </tr>
                        </thead>
                        <tbody>
                        <?php

                          $sel = "SELECT * FROM contact"; 
                          $res = mysqli_query($con,$sel);
                          $i=1;
                          while($r = mysqli_fetch_array($res))
                            {
                               echo "
                                  <tr>
                                    <td>$i</td>
                                    <td>$r[1]</td>
                                    <td>$r[2]</td>
                                    <td>$r[3]</td>
                                    <td>$r[4]</td>
                                    <td>$r[5]</td>
                                    <td>
                                      <a href='update_contact.php?update_contact=$r[0]'>
                                        <button class= 'btn-default btn-xs m-r-5' data-toggle='tooltip' data-original-title='Edit'>
                                          <i class='fa fa-pencil font-14'></i>
                                        </button>
                                      </a>
                                      <a href='delete.php?contact=$r[0]'>
                                        <button class='btn btn-default btn-xs' data-toggle='tooltip' data-original-title='Delete'>
                                          <i class='fa fa-trash font-14'></i>
                                        </button>
                                      </a>
                                    </td>
                                  </tr>
             ";
             $i++;
           }
           ?> </tbody>
                      </table>
                    </div>
                  </div>
                </div>
              </div>
              <div class="tab-pane" id="tab-7-2">
                <div class="col-md-12">
                  <div class="ibox">
                    <div class="ibox-head">
                      <div class="ibox-title">Horizontal Form</div>
                      <div class="ibox-tools">
                        <a class="ibox-collapse">
                          <i class="fa fa-minus"></i>
                        </a>
                        <a class="fullscreen-link">
                          <i class="fa fa-expand"></i>
                        </a>
                      </div>
                    </div>
                    <div class="ibox-body">
                      <form class="form-horizontal" method="POST" action="insert.php" enctype="multipart/form-data">
                        <div class="form-group row">
                          <label class="col-sm-2 col-form-label">Title</label>
                          <div class="col-sm-10">
                            <input class="form-control" type="text" placeholder="Title" name="title">
                          </div>
                        </div>
                        <div class="form-group row">
                          <label class="col-sm-2 col-form-label">Decripation</label>
                          <div class="col-sm-10">
                            <input class="form-control" type="text" placeholder="Decripation" name="details">
                          </div>
                        </div>
                        <div class="form-group row">
                          <label class="col-sm-2 col-form-label">Contact No</label>
                          <div class="col-sm-10">
                            <input class="form-control" type="text" placeholder="Contact No" name="number">
                          </div>
                        </div>
                        <div class="form-group row">
                          <label class="col-sm-2 col-form-label">Address</label>
                          <div class="col-sm-10">
                            <input class="form-control" type="text" placeholder="Address" name="address">
                          </div>
                        </div>
                        <div class="form-group row">
                          <label class="col-sm-2 col-form-label">Time</label>
                          <div class="col-sm-10">
                            <input class="form-control" type="text" placeholder="Time" name="time">
                          </div>
                        </div>
                        <div class="form-group row">
                          <div class="col-sm-10 ml-sm-auto">
                            <button class="btn btn-success" type="submit" name="contact" value="contact">ADD</button>
                          </div>
                        </div>
                      </form>
                    </div>
                  </div>
                </div>
              </div>
            </div>
          </div>
        </div>
      </div>
    </div>
  </div>
</div> <?php include 'footer.php'; ?>