Viewing file:  view_users.php (52.71 KB) -rw-rw-r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php session_start();
include('includes/header.php');
if(isset($_GET['s']))
{
$s = $_GET['s'];
}
?>
<?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
{
?>
<input type="hidden" id="s" value="<?php echo $s; ?>">
<div class="page-container">
<div class="left-content">
<div class="mother-grid-inner">
<!--header start here-->
<div class="header-main">
<div class="header-left">
<div class="logo-name">
<a href="admin_index.php"> <h3>SICS ADMIN</h3>
</br>
<h4>Registered Users</h4>
<!--<img id="logo" src="" alt="Logo"/>-->
</a>
</div>
<!--search-box-->
<!--
<div class="search-box">
<form>
<input type="text" placeholder="Search..." required="">
<input type="submit" value="">
</form>
</div>//end-search-box
-->
<div class="clearfix"> </div>
</div>
<!--
<div class="header-right">
<div class="profile_details_left">notifications of menu start
<ul class="nofitications-dropdown">
<li class="dropdown head-dpdn">
<a href="#" class="dropdown-toggle" data-toggle="dropdown" aria-expanded="false"><i class="fa fa-envelope"></i><span class="badge">3</span></a>
<ul class="dropdown-menu">
<li>
<div class="notification_header">
<h3>You have 3 new messages</h3>
</div>
</li>
<li><a href="#">
<div class="user_img"><img src="images/p4.png" alt=""></div>
<div class="notification_desc">
<p>Lorem ipsum dolor</p>
<p><span>1 hour ago</span></p>
</div>
<div class="clearfix"></div>
</a></li>
<li class="odd"><a href="#">
<div class="user_img"><img src="images/p2.png" alt=""></div>
<div class="notification_desc">
<p>Lorem ipsum dolor </p>
<p><span>1 hour ago</span></p>
</div>
<div class="clearfix"></div>
</a></li>
<li><a href="#">
<div class="user_img"><img src="images/p3.png" alt=""></div>
<div class="notification_desc">
<p>Lorem ipsum dolor</p>
<p><span>1 hour ago</span></p>
</div>
<div class="clearfix"></div>
</a></li>
<li>
<div class="notification_bottom">
<a href="#">See all messages</a>
</div>
</li>
</ul>
</li>
<li class="dropdown head-dpdn">
<a href="#" class="dropdown-toggle" data-toggle="dropdown" aria-expanded="false"><i class="fa fa-bell"></i><span class="badge blue">3</span></a>
<ul class="dropdown-menu">
<li>
<div class="notification_header">
<h3>You have 3 new notification</h3>
</div>
</li>
<li><a href="#">
<div class="user_img"><img src="images/p5.png" alt=""></div>
<div class="notification_desc">
<p>Lorem ipsum dolor</p>
<p><span>1 hour ago</span></p>
</div>
<div class="clearfix"></div>
</a></li>
<li class="odd"><a href="#">
<div class="user_img"><img src="images/p6.png" alt=""></div>
<div class="notification_desc">
<p>Lorem ipsum dolor</p>
<p><span>1 hour ago</span></p>
</div>
<div class="clearfix"></div>
</a></li>
<li><a href="#">
<div class="user_img"><img src="images/p7.png" alt=""></div>
<div class="notification_desc">
<p>Lorem ipsum dolor</p>
<p><span>1 hour ago</span></p>
</div>
<div class="clearfix"></div>
</a></li>
<li>
<div class="notification_bottom">
<a href="#">See all notifications</a>
</div>
</li>
</ul>
</li>
<li class="dropdown head-dpdn">
<a href="#" class="dropdown-toggle" data-toggle="dropdown" aria-expanded="false"><i class="fa fa-tasks"></i><span class="badge blue1">9</span></a>
<ul class="dropdown-menu">
<li>
<div class="notification_header">
<h3>You have 8 pending task</h3>
</div>
</li>
<li><a href="#">
<div class="task-info">
<span class="task-desc">Database update</span><span class="percentage">40%</span>
<div class="clearfix"></div>
</div>
<div class="progress progress-striped active">
<div class="bar yellow" style="width:40%;"></div>
</div>
</a></li>
<li><a href="#">
<div class="task-info">
<span class="task-desc">Dashboard done</span><span class="percentage">90%</span>
<div class="clearfix"></div>
</div>
<div class="progress progress-striped active">
<div class="bar green" style="width:90%;"></div>
</div>
</a></li>
<li><a href="#">
<div class="task-info">
<span class="task-desc">Mobile App</span><span class="percentage">33%</span>
<div class="clearfix"></div>
</div>
<div class="progress progress-striped active">
<div class="bar red" style="width: 33%;"></div>
</div>
</a></li>
<li><a href="#">
<div class="task-info">
<span class="task-desc">Issues fixed</span><span class="percentage">80%</span>
<div class="clearfix"></div>
</div>
<div class="progress progress-striped active">
<div class="bar blue" style="width: 80%;"></div>
</div>
</a></li>
<li>
<div class="notification_bottom">
<a href="#">See all pending tasks</a>
</div>
</li>
</ul>
</li>
</ul>
<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 class="inner-block">
<?php
$query = "select * from user_details ORDER BY user_id desc";
$result = $con->query($query);
?>
<table id="users" class="table table-striped table-condensed">
<thead>
<tr>
<th>Sl.No</th>
<th>Name</th>
<th>Email</th>
<th>Contact</th>
<th>Campus Student</th>
<th>Course Requested</th>
<th>Date and Time</th>
<th>Action</th>
<!-- <th>Qualification</th>
<th>Technical Background</th> -->
</tr>
</thead>
<tbody>
<?php
$i=1;
while ($row = $result->fetch_assoc()) {
$usrid=$row["user_id"];
$sql="select * from enrolldetails where admin_status!=0 and user_id=$usrid";
$sqlResult=$con->query($sql);
$sqlCount=$sqlResult->num_rows;
if($sqlCount==0){
?>
<tr>
<!-- <td><?php //echo $row["user_id"]; ?></td> -->
<td><?php echo $i; ?></td>
<td><?php echo $row["name"]; ?></td>
<td><?php echo $row["email"]; ?></td>
<td><?php echo $row["phone"]; ?></td>
<td style="text-align: center;">
<?php
$query1 = "select * from enrolldetails where user_id='$usrid' ";
$result1 = $con->query($query1);
while ($row1 = $result1->fetch_assoc()) {
$admin_status= $row1["admin_status"];
if($admin_status==1)
{
echo "Yes";
break;
}
}
?>
</td>
<td>
<?php
$query1 = "select * from enrolldetails where user_id='$usrid' ";
$result1 = $con->query($query1);
while ($row1 = $result1->fetch_assoc()) {
echo $row1["course"]; ?> </br><?php
}
?>
</td>
<td><?php echo $row["created_at"]; ?></td>
<td>
<a href="user_delete.php?id=<?php echo $row['user_id'];?>"><button>Delete</button></a>
<br><br>
<form action="contact_edit.php" method="post">
<input type="hidden" name="id" value="<?php echo $row['user_id'];?>">
<select name="contact_status" style="width: 100px"><?php if($row['contact_status']=='Pending'){
echo '<option>Pending</option><option>Contacted</option>';
}
else if($row['contact_status']=='Contacted') {
echo '<option>Contacted</option><option>Pending</option>';
}
else{
echo '<option>Pending</option><option>Contacted</option>';
}?>
</select>
<br><br>
<input type="submit" name="submit" value="Update">
</form>
</td>
<!-- <td><?php //echo $row["qualification"]; ?></td>
<td><?php //echo $row["technical"]; ?></td> -->
<?php
$i++;
}}
?>
</tr>
</tbody>
</table>
</div>
<div class="clearfix"> </div>
</div>
<div class="clearfix"> </div>
</div>
<!--heder end here-->
<!-- script-for sticky-nav -->
<!-- /script-for sticky-nav -->
<!--inner block start here-->
<div class="inner-block">
<!--market updates updates-->
<!-- <div class="market-updates">
<div class="col-md-4 market-update-gd">
<div class="market-update-block clr-block-1">
<div class="col-md-8 market-update-left">
<h3>83</h3>
<h4>Registered User</h4>
<p>Other hand, we denounce</p>
</div>
<div class="col-md-4 market-update-right">
<i class="fa fa-file-text-o"> </i>
</div>
<div class="clearfix"> </div>
</div>
</div>
<div class="col-md-4 market-update-gd">
<div class="market-update-block clr-block-2">
<div class="col-md-8 market-update-left">
<h3>135</h3>
<h4>Daily Visitors</h4>
<p>Other hand, we denounce</p>
</div>
<div class="col-md-4 market-update-right">
<i class="fa fa-eye"> </i>
</div>
<div class="clearfix"> </div>
</div>
</div>
<div class="col-md-4 market-update-gd">
<div class="market-update-block clr-block-3">
<div class="col-md-8 market-update-left">
<h3>23</h3>
<h4>New Messages</h4>
<p>Other hand, we denounce</p>
</div>
<div class="col-md-4 market-update-right">
<i class="fa fa-envelope-o"> </i>
</div>
<div class="clearfix"> </div>
</div>
</div>
<div class="clearfix"> </div>
</div> -->
<!--market updates end here-->
<!--mainpage chit-chating-->
<!-- <div class="chit-chat-layer1">
<div class="col-md-6 chit-chat-layer1-left">
<div class="work-progres">
<div class="chit-chat-heading">
Recent Followers
</div>
<div class="table-responsive">
<table class="table table-hover">
<thead>
<tr>
<th>#</th>
<th>Project</th>
<th>Manager</th>
<th>Status</th>
<th>Progress</th>
</tr>
</thead>
<tbody>
<tr>
<td>1</td>
<td>Face book</td>
<td>Malorum</td>
<td><span class="label label-danger">in progress</span></td>
<td><span class="badge badge-info">50%</span></td>
</tr>
<tr>
<td>2</td>
<td>Twitter</td>
<td>Evan</td>
<td><span class="label label-success">completed</span></td>
<td><span class="badge badge-success">100%</span></td>
</tr>
<tr>
<td>3</td>
<td>Google</td>
<td>John</td>
<td><span class="label label-warning">in progress</span></td>
<td><span class="badge badge-warning">75%</span></td>
</tr>
<tr>
<td>4</td>
<td>LinkedIn</td>
<td>Danial</td>
<td><span class="label label-info">in progress</span></td>
<td><span class="badge badge-info">65%</span></td>
</tr>
<tr>
<td>5</td>
<td>Tumblr</td>
<td>David</td>
<td><span class="label label-warning">in progress</span></td>
<td><span class="badge badge-danger">95%</span></td>
</tr>
<tr>
<td>6</td>
<td>Tesla</td>
<td>Mickey</td>
<td><span class="label label-info">in progress</span></td>
<td><span class="badge badge-success">95%</span></td>
</tr>
</tbody>
</table>
</div>
</div>
</div> -->
<!-- <div class="col-md-6 chit-chat-layer1-rit">
<div class="geo-chart">
<section id="charts1" class="charts">
<div class="wrapper-flex">
<table id="myTable" class="geoChart tableChart data-table col-table" style="display:none;">
<caption>Student Nationalities Table</caption>
<tr>
<th scope="col" data-type="string">Country</th>
<th scope="col" data-type="number">Number of Students</th>
<th scope="col" data-role="annotation">Annotation</th>
</tr>
<tr>
<td>China</td>
<td align="right">20</td>
<td align="right">20</td>
</tr>
<tr>
<td>Colombia</td>
<td align="right">5</td>
<td align="right">5</td>
</tr>
<tr>
<td>France</td>
<td align="right">3</td>
<td align="right">3</td>
</tr>
<tr>
<td>Italy</td>
<td align="right">1</td>
<td align="right">1</td>
</tr>
<tr>
<td>Japan</td>
<td align="right">18</td>
<td align="right">18</td>
</tr>
<tr>
<td>Kazakhstan</td>
<td align="right">1</td>
<td align="right">1</td>
</tr>
<tr>
<td>Mexico</td>
<td align="right">1</td>
<td align="right">1</td>
</tr>
<tr>
<td>Poland</td>
<td align="right">1</td>
<td align="right">1</td>
</tr>
<tr>
<td>Russia</td>
<td align="right">11</td>
<td align="right">11</td>
</tr>
<tr>
<td>Spain</td>
<td align="right">2</td>
<td align="right">2</td>
</tr>
<tr>
<td>Tanzania</td>
<td align="right">1</td>
<td align="right">1</td>
</tr>
<tr>
<td>Turkey</td>
<td align="right">2</td>
<td align="right">2</td>
</tr>
</table>
<div class="col geo_main">
<h3 id="geoChartTitle">World Market</h3>
<div id="geoChart" class="chart"> </div>
</div>
-->
<!-- <!-- </div><!-- .wrapper-flex -->
</section>
</div>
<div class="clearfix"> </div>
</div>
<!--main page chit chating end here-->
<!-- <div class="main-page-charts">
<div class="main-page-chart-layer1">
<div class="col-md-6 chart-layer1-left">
<div class="glocy-chart"> -->
<!-- <div class="span-2c">
<h3 class="tlt">Sales Analytics</h3>
<canvas id="bar" height="300" width="400" style="width: 400px; height: 300px;"></canvas>
<script>
var barChartData = {
labels : ["Jan","Feb","Mar","Apr","May","Jun","jul"],
datasets : [
{
fillColor : "#FC8213",
data : [65,59,90,81,56,55,40]
},
{
fillColor : "#337AB7",
data : [28,48,40,19,96,27,100]
}
]
};
new Chart(document.getElementById("bar").getContext("2d")).Bar(barChartData);
</script>
</div> -->
</div>
</div>
<!-- <div class="col-md-6 chart-layer1-right">
<div class="user-marorm">
<div class="malorum-top">
</div>
<div class="malorm-bottom">
<span class="malorum-pro"> </span>
<h4>unde omnis iste</h4>
<h2>Melorum</h2>
<p>But I must explain to you how all this mistaken idea of denouncing pleasure and praising.</p>
<ul class="malorum-icons">
<li><a href="#"><i class="fa fa-facebook"> </i>
<div class="tooltip"><span>Facebook</span></div>
</a></li>
<li><a href="#"><i class="fa fa-twitter"> </i>
<div class="tooltip"><span>Twitter</span></div>
</a></li>
<li><a href="#"><i class="fa fa-google-plus"> </i>
<div class="tooltip"><span>Google</span></div>
</a></li>
</ul>
</div>
</div>
</div>
<div class="clearfix"> </div>
</div>
</div>
<!--main page chart layer2-->
<!-- <!-- <div class="chart-layer-2">
<div class="col-md-6 chart-layer2-right">
<div class="prograc-blocks">
<!--Progress bars-->
<!-- <div class="home-progres-main">
<h3>Total Sales</h3>
</div>
<div class='bar_group'>
<div class='bar_group__bar thin' label='Rating' show_values='true' tooltip='true' value='343'></div>
<div class='bar_group__bar thin' label='Quality' show_values='true' tooltip='true' value='235'></div>
<div class='bar_group__bar thin' label='Amount' show_values='true' tooltip='true' value='550'></div>
<div class='bar_group__bar thin' label='Farming' show_values='true' tooltip='true' value='456'></div>
</div>
<script src="js/bars.js"></script>
<!--//Progress bars-->
<<!-- /div>
</div> -->
<!-- <!-- <div class="col-md-6 chart-layer2-left">
<div class="content-main revenue">
<h3>Total Revenue</h3>
<canvas id="radar" height="300" width="300" style="width: 300px; height: 300px;"></canvas>
<script>
var radarChartData = {
labels : ["","","","","","",""],
datasets : [
{
fillColor : "rgba(104, 174, 0, 0.83)",
strokeColor : "#68ae00",
pointColor : "#68ae00",
pointStrokeColor : "#fff",
data : [65,59,90,81,56,55,40]
},
fillColor : "rgba(236, 133, 38, 0.82)",
strokeColor : "#ec8526",
pointColor : "#ec8526",
pointStrokeColor : "#fff",
data : [28,48,40,19,96,27,100]
}
]
};
new Chart(document.getElementById("radar").getContext("2d")).Radar(radarChartData);
</script>
</div>
</div>
<div class="clearfix"> </div>
</div>
<!--climate start here-->
<!-- <div class="climate">
<div class="col-md-4 climate-grids">
<div class="climate-grid1">
<div class="climate-gd1-top"> -->
<!-- <div class="col-md-6 climate-gd1top-left">
<h4>Aprill 6-wed</h4>
<h3>12:30<span class="timein-pms">PM</span></h3>
<p>Humidity:</p>
<p>Sunset:</p>
<p>Sunrise:</p>
</div> -->
<!-- <div class="col-md-6 climate-gd1top-right">
<span class="clime-icon">
<figure class="icons">
<canvas id="partly-cloudy-day" width="64" height="64">
</canvas>
</figure>
<script>
var icons = new Skycons({"color": "#fff"}),
list = [
"clear-night", "partly-cloudy-day",
"partly-cloudy-night", "cloudy", "rain", "sleet", "snow", "wind",
"fog"
],
i;
for(i = list.length; i--; )
icons.set(list[i], list[i]);
icons.play();
</script>
</span>
<p>88%</p>
<p>5:40PM</p>
<p>6:30AM</p>
</div> -->
<div class="clearfix"> </div>
</div>
<!-- <div class="climate-gd1-bottom">
<div class="col-md-4 cloudy1">
<h4>Hongkong</h4>
<figure class="icons">
<canvas id="sleet" width="58" height="58">
</canvas>
</figure>
<script>
var icons = new Skycons({"color": "#fff"}),
list = [
"clear-night", "clear-day",
"partly-cloudy-night", "cloudy", "rain", "sleet", "snow", "wind",
"fog"
],
i;
for(i = list.length; i--; )
icons.set(list[i], list[i]);
icons.play();
</script>
<h3>10c</h3>
</div> -->
<!-- <div class="col-md-4 cloudy1">
<h4>UK</h4>
<figure class="icons">
<canvas id="cloudy" width="58" height="58"></canvas>
</figure>
<script>
var icons = new Skycons({"color": "#fff"}),
list = [
"clear-night", "cloudy",
"partly-cloudy-night", "cloudy", "rain", "sleet", "snow", "wind",
"fog"
],
i;
for(i = list.length; i--; )
icons.set(list[i], list[i]);
icons.play();
</script>
<h3>6c</h3>
</div> -->
<!-- <div class="col-md-4 cloudy1">
<h4>USA</h4>
<figure class="icons">
<canvas id="snow" width="58" height="58">
</canvas>
</figure>
<script>
var icons = new Skycons({"color": "#fff"}),
list = [
"clear-night", "clear-day",
"partly-cloudy-night", "cloudy", "rain", "sleet", "snow", "wind",
"fog"
],
i;
for(i = list.length; i--; )
icons.set(list[i], list[i]);
icons.play();
</script>
<h3>10c</h3>
</div> -->
<div class="clearfix"> </div>
</div>
</div>
</div>
<!-- <div class="col-md-4 climate-grids">
<div class="climate-grid2">
<span class="shoppy-rate"><h4>$180</h4></span>
<ul>
<li> <i class="fa fa-credit-card"> </i> </li>
<li> <i class="fa fa-usd"> </i> </li>
</ul>
</div>
<div class="shoppy">
<h3>Those Who Hate Shopping?</h3>
</div>
</div> -->
<!-- <div class="col-md-4 climate-grids">
<div class="climate-grid3">
<div class="popular-brand">
<div class="col-md-6 popular-bran-left">
<h3>Popular</h3>
<h4>Brand of this month</h4>
<p> Duis aute irure in reprehenderit.</p>
</div>
<div class="col-md-6 popular-bran-right">
<h3>Polo</h3>
</div>
<div class="clearfix"> </div>
</div>
<div class="popular-follow">
<div class="col-md-6 popular-follo-left">
<p>Lorem ipsum dolor sit amet, adipiscing elit.</p>
</div>
<div class="col-md-6 popular-follo-right">
<h4>Follower</h4>
<h5>2892</h5>
</div>
<div class="clearfix"> </div>
</div>
</div>
</div> -->
<!-- <div class="clearfix"> </div>
</div> -->
<!--climate end here-->
</div>
<!--inner block end here-->
<!--copy rights start here-->
<!-- <div class="copyrights">
<p>© 2016 Shoppy. All Rights Reserved | Design by <a href="http://w3layouts.com/" target="_blank">W3layouts</a> </p>
</div> -->
<!--COPY rights end here-->
</div>
</div>
<!--slider menu-->
<?php include('includes/sidebar.php'); ?>
<div class="clearfix"> </div>
</div>
<!--slide bar menu end here-->
<?php include('includes/footer.php'); ?>
<script>
$(document).ready(function () {
$('#users').DataTable();
var navoffeset = $(".header-main").offset().top;
$(window).scroll(function () {
var scrollpos = $(window).scrollTop();
if (scrollpos >= navoffeset) {
$(".header-main").addClass("fixed");
} else {
$(".header-main").removeClass("fixed");
}
});
});
</script>
<script type="text/javascript">
var x = $('#s').val();
if (x == 'Success') {
// $("#myModal").modal();
// swal('User has been Deleted !!');
swal({
title: "",
type: "success",
text: 'User has been Deleted !!',
confirmButtonColor: "#00B4B4"
},function() {
window.location.href = "view_users.php";
});
}
</script>
<?php
}
?>
|