<?php
$table_name = 'groups';
$redirection_page = "index.php?action=$page_name";
$action_name = "action=$page_name";
$type = $_REQUEST['type'];
$edit_id = $_REQUEST['edit_id'];
$delete_id = $_REQUEST['delete_id'];
// For Submitting The Form
if(isset($_POST['submit'])){
$field1 = $_POST['field1'];
$field2 = $_POST['field2'];
if ($type == 'Edit') {
$insert_bookings = "UPDATE `$table_name` SET
user_grp_name = '".addslashes($field1)."',
user_grp_role = '".addslashes($field2)."'
where id='".$edit_id."'";
$sql_insert = $dbconn->prepare($insert_bookings);
$sql_insert->execute();
$message="Details successfully updated.";
$status="success";
header("Location: $redirection_page&id=$edit_id");
} else{
$insert_bookings = "INSERT `$table_name` SET
user_grp_name = '".addslashes($field1)."',
user_grp_role = '".addslashes($field2)."',
status = 'Active'";
$sql_insert = $dbconn->prepare($insert_bookings);
$sql_insert->execute();
$myid = $dbconn->lastInsertId();
$message="Details successfully updated.";
$status="success";
header("Location: $redirection_page&id=$myid");
}
}
// For Displaying the table
if (isset($_GET['pageno'])) {
$pageno = $_GET['pageno'];
} else {
$pageno = 1;
}
$no_of_records_per_page = 7;
$offset = ($pageno-1) * $no_of_records_per_page;
$select_enquiry="SELECT * FROM $table_name where status = 'Active' order by id desc";
$sql=$dbconn->prepare($select_enquiry);
$sql->execute();
$total_rows = $sql->fetchColumn();
$total_pages = ceil($total_rows / $no_of_records_per_page);
$select_enquiry = "SELECT * FROM $table_name where status = 'Active' order by id desc LIMIT $offset, $no_of_records_per_page";
$sql=$dbconn->prepare($select_enquiry);
$sql->execute();
$wlvd=$sql->fetchAll(PDO::FETCH_OBJ);
$select_bookings= "SELECT * FROM `$table_name` WHERE id = '$edit_id'";
$sql1=$dbconn->prepare($select_bookings);
$sql1->execute();
$wlvd1=$sql1->fetchAll(PDO::FETCH_OBJ);
foreach($wlvd1 as $rows1);
?>
<div class="container-fluid">
<div class="content-wrapper">
<div class="container-fluid">
<!-- Breadcrumb-->
<div class="row pt-2 pb-2">
<div class="col-sm-9">
<h4 class="page-title"><?php echo $page_name; ?></h4>
<ol class="breadcrumb">
<li class="breadcrumb-item"><a href="index.php?action=Welcome">Dashboard</a></li>
<li class="breadcrumb-item active" aria-current="page"><a href="index.php?action=<?php echo $page_name; ?>"><?php echo $page_name; ?></a></li>
</ol>
</div>
<div class="col-sm-3">
<?php include ('plugins/alert.php') ;?>
<!-- Button trigger modal -->
</div>
</div>
<!-- End Breadcrumb-->
<?php if ($type == 'Delete'){
$delete_statement = "UPDATE `$table_name` SET
status = 'Inactive'
where id='".$delete_id."'";
$sql_insert = $dbconn->prepare($delete_statement);
$sql_insert->execute();
$message="Details successfully updated.";
$status="success";
header("Location: $redirection_page&id=$delete_id");
}else {
?>
<div class="row">
<div class="col-lg-4">
<div class="card">
<div class="card-header"><i class="fa fa-user"></i>
<?php
if ($type == 'Edit') {
echo("You Are Editing A Record");
}else {
echo "You Are Adding A New Record";
}
;?>
</div>
<div class="card-body">
<div class="table-responsive">
<form id="formID" class="m-t-30" method="POST" action="">
<div class="row">
<div class="col-md-12">
<div class="form-group">
<label for="inv_phone">Group Name</label>
<input name="field1" type="text" class="form-control" id="field1" value="<?php echo $rows1->user_grp_name;?>" >
<small id="emailHelp" class="form-text text-muted"></small>
</div>
</div>
</div>
<div class="row">
<div class="col-md-12">
<div class="form-group">
<label for="inv_phone">Group Role</label>
<input name="field2" type="text" class="form-control" id="field2" value="<?php echo $rows1->user_grp_role;?>" >
<small id="emailHelp" class="form-text text-muted"></small>
</div>
</div>
</div>
<button type="submit" name="submit" value="Submit" class="btn btn-primary btn-lg btn-block waves-effect waves-light m-1">Submit</button>
</form>
</div>
</div>
</div>
</div>
<div class="col-lg-8">
<div class="card">
<div class="card-header"><i class="fa fa-user"></i> All Projects</div>
<div class="card-body">
<div class="table-responsive">
<table class="table table-hover" id="sample-table-1">
<thead class="thead-dark">
<tr>
<th class="center"> ID</th>
<th class="center"> Name</th>
<th class="center"> Role</th>
<th class="center"> Action</th>
</tr>
</thead>
<tbody>
<?php
//while($rows = mysql_fetch_array($aResult,MYSQL_ASSOC))
//{
if($sql->rowCount() > 0){
foreach($wlvd as $rows){
$field1 = $rows->id;
$field2 = $rows->user_grp_name;
$field3 = $rows->user_grp_role;
?>
<tr>
<td class="center"><?php echo $field1;?></td>
<td class="center"><?php echo $field2;?></td>
<td class="center"><?php echo $field3;?></td>
<td class="center">
<a href="<?php echo $redirection_page;?>&edit_id=<?php echo $field1;?>&type=Edit"target="_self" ><i class="fa fa-edit"></i> </a>
<a href="<?php echo $redirection_page;?>&delete_id=<?php echo $field1;?>&type=Delete"target="_self" ><i class="fa fa-trash"></i> </a>
</td>
</tr>
<?php }} ?>
</tbody>
</table>
<?php include ('plugins/pagination.php') ;?>
</div>
</div>
</div>
</div>
</div>
<?php
};
?>
</div><!-- End Row-->
</div><!--End content-wrapper-->
<!--Start Back To Top Button-->
<a href="javaScript:void();" class="back-to-top"><i class="fa fa-angle-double-up"></i> </a>
<!--End Back To Top Button-->