<?php
 $actual_link = "http://$_SERVER[HTTP_HOST]$_SERVER[REQUEST_URI]";
include("include/connection.php");

 $fr=$_SERVER['REQUEST_URI'];
if($_POST['Save']!='')
 {
    $m_title=addslashes(trim($_POST['m_title'])); //exit; 
    $desc=addslashes(trim($_POST['m_des']));
    $m_key=addslashes(trim($_POST['m_key']));
    $url=addslashes(trim($_POST['m_page']));
	 
   
    
//print_r(mysqli_num_rows($result));exit;
			$ins = "insert into metatag set URL='$url',title='$m_title',keyword='$m_key',description='$desc'"; 
			$rsc = mysqli_query($con,$ins);
			if($rsc)
			{
			    header("location: add_meta.php?msg=Category Saved Successfully.");
			}
	
		
 }
 
 
$qry_all="SELECT * FROM metatag WHERE 1=1 order by id ";
	 $rsc_all=mysqli_query($con,$qry_all);
	 $qry_all1="SELECT * FROM pages WHERE 1=1 order by id ";
	 $res=mysqli_query($con,$qry_all1);
?>
<!DOCTYPE html>
<html lang="en">
<head>
   <?php include("element/css_js.php"); ?>
</head>
<body class="hold-transition dark-mode sidebar-mini layout-fixed layout-navbar-fixed layout-footer-fixed">
<div class="wrapper">

  <!-- Preloader -->
   <?php include("element/header.php"); ?>

  <!-- Main Sidebar Container -->
 
<?php include("element/menu.php"); ?>
  <!-- Content Wrapper. Contains page content -->
  <div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">
      <div class="container-fluid">
        <div class="row mb-2">
          <div class="col-sm-6">
            <h1>Manage Meta Tag</h1>
          </div>
          <div class="col-sm-6">
            <ol class="breadcrumb float-sm-right">
              <li class="breadcrumb-item"><a href="#">Home</a></li>
              <li class="breadcrumb-item active"> Menu</li>
            </ol>
          </div>
        </div>
      </div><!-- /.container-fluid -->
    </section>

    <!-- Main content -->
    <section class="content">
      <div class="container-fluid">
        <div class="row">
          <!-- left column -->
          <div class="col-md-12">
            <!-- general form elements -->
            <div class="card card-primary">
              <div class="card-header">
                <h3 class="card-title"> Category</h3>
              </div>
              <!-- /.card-header -->
              <!-- form start -->
              <form method="post">
                <div class="card-body">
                    <div class="row">
                     <div class="col-md-3">
                          <div class="form-group">
                            <label for="exampleInputEmail1">Select Category</label>
                            <select name="m_page" id="meta" class="form-control">
                                <?php while($show=mysqli_fetch_array($res)){ ?>
                                <option value="<?php echo $show['URL']; ?>"><?php echo $show['page_name']; ?></option>
                                <?php } ?>
                            </select>
                          </div>
                          
                     </div>
                     <div class="col-md-3">
                          <div class="form-group">
                            <label for="m_title">Meta Title</label>
                            <textarea class="form-control" id="desc" name="m_title" placeholder="Meta title"></textarea>
                          </div>
                          
                     </div>
                     <div class="col-md-3">
                          <div class="form-group">
                            <label for="m_desc">Meta Description</label>
                          <textarea class="form-control" id="desc" name="m_des" placeholder="Description"></textarea>
                          </div>
                          
                     </div>
                      <div class="col-md-3">
                          <div class="form-group">
                            <label for="m_key">Meta Keyword</label>
                            <textarea class="form-control" id="desc" name="m_key" placeholder="Keywords"></textarea>
                          </div>
                          
                     </div>
                     
                     <div class="col-md-3">
                          <div class="form-group">
                              
                              <br>
                     <button type="submit" name="Save" value="Save" class="mt-2 btn btn-primary">Save</button>
                     </div></div>
                <!-- /.card-body -->

                
                    </div>
                    </div>
              </form>
              <?php if(mysqli_num_rows($rsc_all)>0) { ?>
              <form method="post">
                <div class="card-body">
                    View meta
                    <table class="table">
                        <tr>
                            <th>Sr. No. </th>
                            <th>URL </th>
                            <th>Description </th>
                            <th>Edit </th>
                        </tr>
                    
                    <?php $i=1;
                    while($record = mysqli_fetch_array($rsc_all)) { ?>
                    <tr>
                            <th><?php echo $i++; ?> </th>
                            <th><?php echo $record['URL']; ?></th>
                            <th><?php echo $record['description']; ?></th>
                            <th><a href="meta-edit.php?id=<?php echo  $record['id']; ?>" name=delete ><i class="fa fa-edit"></i></a> </th>
                            <th><a href="del_meta.php?id=<?php echo  $record['id']; ?>" name=delete ><i class="fa fa-trash"></i></a> </th>
                        </tr>
                    <?php } ?>
                    </table>
                    <!--<button type="submit" name="Update" value="update" class="mt-2 btn btn-primary">Update</button>-->
                    </div>
                    
              </form>
              <?php } ?>
            </div></div></div></div></section></div>
  <!-- /.content-wrapper -->
  <footer class="main-footer">
    <strong>Copyright &copy; 2021-2022 <a href="#">koscove Admin</a>.</strong>
    All rights reserved.
    <div class="float-right d-none d-sm-inline-block">
     <!-- <b>Version</b> 3.1.0-->
    </div>
  </footer>

  <!-- Control Sidebar -->
  <aside class="control-sidebar control-sidebar-dark">
    <!-- Control sidebar content goes here -->
  </aside>
  <!-- /.control-sidebar -->
</div>
<!-- ./wrapper -->

<!-- jQuery -->
<script src="plugins/jquery/jquery.min.js"></script>
<!-- jQuery UI 1.11.4 -->
<script src="plugins/jquery-ui/jquery-ui.min.js"></script>
<!-- Resolve conflict in jQuery UI tooltip with Bootstrap tooltip -->
<script>
  $.widget.bridge('uibutton', $.ui.button)
</script>
<!-- Bootstrap 4 -->
<script src="plugins/bootstrap/js/bootstrap.bundle.min.js"></script>
<!-- ChartJS -->
<script src="plugins/chart.js/Chart.min.js"></script>
<!-- Sparkline -->
<script src="plugins/sparklines/sparkline.js"></script>
<!-- JQVMap -->
<script src="plugins/jqvmap/jquery.vmap.min.js"></script>
<script src="plugins/jqvmap/maps/jquery.vmap.usa.js"></script>
<!-- jQuery Knob Chart -->
<script src="plugins/jquery-knob/jquery.knob.min.js"></script>
<!-- daterangepicker -->
<script src="plugins/moment/moment.min.js"></script>
<script src="plugins/daterangepicker/daterangepicker.js"></script>
<!-- Tempusdominus Bootstrap 4 -->
<script src="plugins/tempusdominus-bootstrap-4/js/tempusdominus-bootstrap-4.min.js"></script>
<!-- Summernote -->
<script src="plugins/summernote/summernote-bs4.min.js"></script>
<!-- overlayScrollbars -->
<script src="plugins/overlayScrollbars/js/jquery.overlayScrollbars.min.js"></script>
<!-- AdminLTE App -->
<script src="dist/js/adminlte.js"></script>
<!-- AdminLTE for demo purposes -->
<script src="dist/js/demo.js"></script>
<!-- AdminLTE dashboard demo (This is only for demo purposes) -->
<script src="dist/js/pages/dashboard.js"></script>
</body>
</html>
