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

<style>
    #form .form-group label.error {
    color: #FB3A3A;
    display: inline-block;
    margin: 0px 0 0px 0px;
    padding: 0;

    }
    .form-horizontal .control-label{
      text-align:left !important;
    }
</style>

<main id="main-container">
  <div class="content content-narrow">
    <div class="row">
      <div class="col-lg-12">
        <h2 class="content-heading">Add tag Cloud</h2>
          <?php
            $curDate = date('Y-m-d H:i:s');
            if(isset($_REQUEST['Add'])){
              $tag_name = $_REQUEST['tag_name'];
              $tag_link = $_REQUEST['tag_link'];
              $status = $_REQUEST['status'];
              $addTag="INSERT INTO sp_tag_cloud SET tag_name='$tag_name',tag_link='$tag_link',status='$status', add_date='$curDate'";
              $sql=$db->prepare($addTag);
              if($sql->execute()){
                $message = '<h5 style="color:green;">Data submit successfully</h5>';
              } else {
                $message = '<h5 style="color:red;">Data Not Added</h5>';
              }
            }

            $getDataQuery = "SELECT * FROM sp_tag_cloud";
            $getData=$db->prepare($getDataQuery);
            $getData->execute();
          ?>

        <div class="block">
          <div class="block-header">
            <ul class="block-options">
              <li>
                <button type="button"><i class="si si-settings"></i></button>
              </li>
            </ul>
            <?php echo $message; ?>
            <h3 class="block-title"></h3>
          </div>          
          <div class="block-content block-content-narrow">
            <form class="js-validation-bootstrap form-horizontal" method="post" id="form">
              <div class="form-group">
                <label class="col-md-4 control-label" for="val-select2">Tag Name</label> 
                <div class="col-md-8" class="new_class">
                  <span>
                  <input type="text" name="tag_name" id="tag_name" class="js-select2 form-control text">
                </span>
                </div>
              </div>

              <div class="form-group">
                <label class="col-md-4 control-label">Tag Link</label> 
                <div class="col-md-8" class="new_class">
                  <span>
                  <input type="text" name="tag_link" id="tag_link" class="js-select2 form-control text">
                </span>
                </div>
              </div>
              <div class="form-group">
                <label class="col-md-4 control-label">Status</label> 
                <div class="col-md-8" class="new_class">
                  <select name="status" class="js-select2 form-control">
                    <option value="Y" selected>Active</option>
                    <option value="N" >Deactive</option>
                  </select>
                </div>
              </div>
              <div class="form-group">
                <div class="col-md-4"></div>
                <div class="col-md-4">
                  <button class="btn btn-lg btn-primary" type="submit" name="Add">Add</button>
                </div>
                <div class="col-md-4"></div>
              </div>
            </form>
          </div>
        </div>
      </div>
    </div>
  </div>
  <script type="text/javascript" charset="utf8" src="https://code.jquery.com/jquery-3.3.1.js"></script>
  <script>
    jQuery.noConflict();
    jQuery(function($) {
      jQuery('#tag_table').dataTable({
          "bPaginate": true,
          "bFilter":true,
          "iDisplayLength": 10
      });
    });
  </script>
  <div class="content content-narrow">
    <div class="row">
      <table id="tag_table" class="display table" style="width: 100%; cellspacing: 0;">
        <thead>
            <tr>
                <th>S.No.</th>
                <th>Tag Name</th>
                <th>Tag Link</th>
                <th>Add Date</th>
                <th>Status</th>
            </tr>
        </thead>
        <tbody>
          <?php 
            $k=1;
            while ($querydata = $getData->fetch()) {
              if($querydata['status']=='Y'){
                $status = "Active";
              } else if($querydata['status']=='N'){
                $status = "Deactive";
              }
          ?>
            <tr>
              <td><?php echo $k; ?></td>
              <td><?php echo $querydata['tag_name']; ?></td>
              <td><?php echo $querydata['tag_link']; ?></td>
              <td><?php echo $querydata['add_date']; ?></td>
              <td><?php echo $status; ?></td>
            </tr>
            <?php $k++; } ?>
        </tbody>
      </table> 
    </div>
  </div>
</main>

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