Viewing file:  view_reviews.php (6.94 KB) -rw-rw-r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
session_start();
include('includes/header.php');
if(isset($_POST['submit']))
{
$technology = $_POST["technology"];
$id = $_POST["id"];
if($id==0) {
$query="INSERT INTO technologies(name) VALUES('$technology')";
$result=$con->query($query);
echo "<script>window.location.href='technology.php?s=a';</script>";
}
else {
$query="UPDATE technologies SET name='$technology' WHERE id=$id";
$result=$con->query($query);
echo "<script>window.location.href='technology.php?s=u';</script>";
}
}
?>
<?php
// Storing session data
$_SESSION["role"];
if(!isset($_SESSION["role"]))
{
header("location:admin_login.php");
?>
<script type="text/javascript">
window.location.href = "admin_login.php";
</script>
<?php
}
else
{
?>
<style>
.inner-block {
padding: 1em 1em 1em 1em;
}
.sidebar-menu {
min-height: 1500px;
}
</style>
<div class="page-container">
<div class="left-content">
<div class="mother-grid-inner">
<!--header start here-->
<div class="header-main" style="min-height: 80px;">
<div class="header-left">
<div class="logo-name">
<a href="admin_index.php"> <h3>SICS ADMIN</h3>
</br>
</a>
</div>
<div class="clearfix"> </div>
</div>
<!--notification menu end -->
<div class="profile_details">
<ul>
<li class="dropdown profile_details_drop">
<a href="#" class="dropdown-toggle" data-toggle="dropdown" aria-expanded="false">
<div class="profile_img">
<span class="prfil-img"><img src="images/p1.png" alt=""> </span>
<div class="user-name">
<p>Srishti Innovative</p>
<span><?php echo $_SESSION["name"];?></span>
</div>
<i class="fa fa-angle-down lnr"></i>
<i class="fa fa-angle-up lnr"></i>
<div class="clearfix"></div>
</div>
</a>
<ul class="dropdown-menu drp-mnu">
<!-- <li> <a href="#"><i class="fa fa-cog"></i> Settings</a> </li>
<li> <a href="#"><i class="fa fa-user"></i> Profile</a> </li> -->
<li> <a href="logout.php"><i class="fa fa-sign-out"></i> Logout</a> </li>
</ul>
</li>
</ul>
</div>
</div>
</div>
<!--heder end here-->
<!-- script-for sticky-nav -->
<div class="inner-block" >
<h3 style="text-align: left;color: #337ab7;margin-bottom: 1%;">Reviews</h3>
<?php
$query = "select * from reviews order by id desc";
$result = $con->query($query);
?>
<table id="technologies" class="table table-striped table-bordered table-condensed">
<thead style="background: #7ab9f3;">
<tr>
<th>Sl.No</th>
<th>Name</th>
<th>Technology</th>
<th>Review</th>
<th>Rating</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
<?php
$i=1;
while ($row = $result->fetch_assoc()) {
$result1 = $con->query("SELECT name FROM technologies WHERE id=".$row['technology']." ");
$row1 = mysqli_fetch_assoc($result1);
?>
<tr id="row_<?php echo $row["id"]; ?>">
<td><?php echo $i; ?></td>
<td><?php echo $row["name"]; ?></td>
<td><?php echo $row1["name"]; ?></td>
<td><?php echo $row["review"]; ?></td>
<td><?php echo $row["rating"]; ?></td>
<td>
<button type="button" class="btn btn-success edit" >
<a href="edit_review.php?id=<?php echo $row['id']; ?>" style="color: #fffaf4;">Edit</a>
</button>
<button type="button" data-id="<?php echo $row["id"]; ?>" class="btn btn-danger delete" >Delete </button>
</td>
<?php
$i++;
}
?>
</tr>
</tbody>
</table>
</div>
</div>
</div>
<!--slider menu-->
<?php include('includes/sidebar.php'); ?>
<!--slide bar menu end here-->
<?php include('includes/footer.php'); ?>
<script>
$(document).ready(function () {
$('#technologies').DataTable();
$('.delete').click(function() {
var id= $(this).data('id');
swal({
title: "Are you sure?",
text: "You want to delete this review?",
type: "warning",
showCancelButton: true,
confirmButtonColor: "#DD6B55",
confirmButtonText: "Yes",
cancelButtonText: "No",
closeOnConfirm: false,
closeOnCancel: false
},
function(isConfirm){
if (isConfirm) {
$.ajax({
url: 'delete_review.php',
type: "POST",
data: { id:id },
success: function(response) {
if(response!=0){
swal("Successfully deleted !","success");
$('#row_'+id).hide();
} else{
swal("Something went wrong !", "", "error");
}
}
});
} else {
swal("Cancelled", "", "error");
}
});
});
});
</script>
<?php
if($_REQUEST['s']=='a')
{
?>
<script>
swal("Successfully Added!");
</script>
<?php
} elseif ($_REQUEST['s']=='u') {
?>
<script>
swal("Successfully Updated!");
</script>
<?php
}
?>
<?php
}
?>
|