Server IP : 50.63.8.133 / Your IP : 3.17.179.20 Web Server : Microsoft-IIS/10.0 System : Windows NT P3NWVPWEB032 6.2 build 9200 (Windows Server 2012 Standard Edition) i586 User : IWPD_10999(xformtec) ( 0) PHP Version : 5.4.45 Disable Function : NONE MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : G:/PleskVhosts/xform.in/madhurivivah.com/admin/ |
Upload File : |
Current File : G:/PleskVhosts/xform.in/madhurivivah.com/admin/all-profile.php |
<?php
session_start();
include('include/config.php');
if (strlen($_SESSION['uname']) == 0) {
header('location:index.php');
} else {
if (isset($_GET['delid']) && $_GET['delid'] != "") {
$indexing_del_query = "DELETE FROM member_profile WHERE id=" . $_GET['delid']; //above selected id record or images delete here
$indexing_del_query_run = mysqli_query($con, $indexing_del_query);
?><script type="text/javascript">
window.location = "all-profile.php";
</script><?php
}
if (isset($_GET['editid']) && $_GET['editid'] != "") {
$indexing_del_query = "UPDATE member_profile SET status=1 WHERE id=" . $_GET['editid']; //above selected id record or images delete here
$indexing_del_query_run = mysqli_query($con, $indexing_del_query);
?><script type="text/javascript">
window.location = "all-profile.php";
</script><?php
}
if (isset($_GET['ditid']) && $_GET['ditid'] != "") {
$indexing_del_query = "UPDATE member_profile SET status=0 WHERE id=" . $_GET['ditid']; //above selected id record or images delete here
$indexing_del_query_run = mysqli_query($con, $indexing_del_query);
?><script type="text/javascript">
window.location = "all-profile.php";
</script><?php
}
if (isset($_GET['memid']) && $_GET['memid'] != "") {
$indexing_del_query1 = "UPDATE member_profile SET membership=0 WHERE id=" . $_GET['memid']; //above selected id record or images delete here
$indexing_del_query_run1 = mysqli_query($con, $indexing_del_query1);
?><script type="text/javascript">
window.location = "all-profile.php";
</script><?php
}
if (isset($_GET['memeid']) && $_GET['memeid'] != "") {
$indexing_del_query1 = "UPDATE member_profile SET membership=1 WHERE id=" . $_GET['memeid']; //above selected id record or images delete here
$indexing_del_query_run1 = mysqli_query($con, $indexing_del_query1);
?><script type="text/javascript">
window.location = "all-profile.php";
</script><?php
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<!-- Required meta tags -->
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<!-- Twitter -->
<meta name="twitter:site" content="">
<meta name="twitter:creator" content="">
<meta name="twitter:card" content="">
<meta name="twitter:title" content="">
<meta name="twitter:description" content="">
<meta name="twitter:image" content="">
<!-- Facebook -->
<meta property="og:url" content="">
<meta property="og:title" content="Bracket">
<meta property="og:description" content="">
<meta property="og:image" content="">
<meta property="og:image:secure_url" content="">
<meta property="og:image:type" content="image/png">
<meta property="og:image:width" content="1200">
<meta property="og:image:height" content="600">
<!-- Meta -->
<meta name="description" content="Premium Quality and Responsive UI for Dashboard.">
<meta name="author" content="ThemePixels">
<title>Madhuri Vivah </title>
<!-- vendor css -->
<link href="lib/font-awesome/css/font-awesome.css" rel="stylesheet">
<link href="lib/Ionicons/css/ionicons.css" rel="stylesheet">
<link href="lib/perfect-scrollbar/css/perfect-scrollbar.css" rel="stylesheet">
<link href="lib/jquery-switchbutton/jquery.switchButton.css" rel="stylesheet">
<link href="lib/highlightjs/github.css" rel="stylesheet">
<link href="lib/datatables/jquery.dataTables.css" rel="stylesheet">
<link href="lib/select2/css/select2.min.css" rel="stylesheet">
<!-- Bracket CSS -->
<link rel="stylesheet" href="css/bracket.css">
</head>
<body>
<!-- ########## START: LEFT PANEL ########## -->
<?php include_once('sidebar.php'); ?>
<!-- br-sideleft -->
<!-- ########## END: LEFT PANEL ########## -->
<!-- ########## START: HEAD PANEL ########## -->
<?php include_once('include/header.php'); ?>
<!-- br-header -->
<!-- ########## END: HEAD PANEL ########## -->
<!-- ########## START: RIGHT PANEL ########## -->
<?php include_once('right-pannel-sidebar.php'); ?>
<!-- br-sideright -->
<!-- ########## END: RIGHT PANEL ########## --->
<!-- ########## START: MAIN PANEL ########## -->
<div class="br-mainpanel">
<div class="br-pageheader pd-y-15 pd-l-20">
<nav class="breadcrumb pd-0 mg-0 tx-12">
<a class="breadcrumb-item" href="dashboard.php">Dashboard</a>
<a class="breadcrumb-item" href="#">All Profile</a>
<span class="breadcrumb-item active">Member Profile</span>
</nav>
</div><!-- br-pageheader -->
<div class="pd-x-20 pd-sm-x-30 pd-t-20 pd-sm-t-30">
<h4 class="tx-gray-800 mg-b-5">All Member Profile</h4>
<p class="mg-b-0">DataTables is a plug-in for the jQuery Javascript library.</p>
</div>
<div class="br-pagebody">
<div class="br-section-wrapper">
<h6 class="tx-gray-800 tx-uppercase tx-bold tx-14 mg-b-10">Basic Responsive DataTable</h6>
<p class="mg-b-25 mg-lg-b-50">Searching, ordering and paging goodness will be immediately added to the table, as shown in this example.</p>
<div class="table-wrapper">
<table id="datatable1" class="table display responsive nowrap">
<thead>
<tr>
<th class="wd-15p">Profile Photo</th>
<th class="wd-15p">Profile Id</th>
<th class="wd-15p">Candidate Name</th>
<th class="wd-15p">Date Of Birth</th>
<th class="wd-25p">joining date</th>
<th class="wd-10p">Status</th>
<th class="wd-25p">Action</th>
<th class="wd-25p">Membership</th>
</tr>
</thead>
<tbody>
<?php
if (isset($_GET['pageno'])) {
$pageno = $_GET['pageno'];
} else {
$pageno = 1;
}
$no_of_records_per_page = 8;
$offset = ($pageno - 1) * $no_of_records_per_page;
$total_pages_sql = "SELECT COUNT(*) FROM member_profile";
$result = mysqli_query($con, $total_pages_sql);
$total_rows = mysqli_fetch_array($result)[0];
$total_pages = ceil($total_rows / $no_of_records_per_page);
$query = mysqli_query($con, "SELECT * from member_profile order by member_profile.id desc LIMIT $offset, $no_of_records_per_page");
if (isset($query)) { ?>
<?php
$rowcount = mysqli_num_rows($query);
if ($rowcount == 0) {
?>
<tr>
<td colspan="4" align="center">
<h3 style="color:red">No record found</h3>
</td>
</tr>
<?php
} else {
?>
<?php while ($row = mysqli_fetch_array($query)) {
?>
<tr>
<td>
<?php if ($row['profile_photo']) {
?>
<img src="img/profile-photos/<?php echo htmlentities($row['profile_photo']); ?>" class="wd-150 " alt="">
<?php
} else {
?>
<img src="img/image-not-available.png" class="wd-150 " alt="">
<?php
}
?>
</td>
<td><?php echo htmlentities($row['member_profile_id']); ?></td>
<td><?php echo htmlentities($row['first_name']); ?> <?php echo htmlentities($row['last_name']); ?></td>
<td><?php echo htmlentities($row['date_of_birth']); ?></td>
<td><?php echo htmlentities($row['date']); ?></td>
<td><?php if (isset($row)) {
if ($row['status'] == 0) {
echo "<span style='color:Red;'>Deactive</span>";
} else {
echo "<span style='color:green;'>Active</span>";
}
} ?></td>
<td>
<a href="edit-profile.php?editid=<?php if (isset($row)) {
echo $row['id'];
} ?>" class="btn btn-warning btn-with-icon">
<div class="ht-40 justify-content-between">
<span class="pd-x-15">Edit Profile</span>
<span class="icon wd-40"><i class="fa fa-eye"></i></span>
</div>
</a>
<a href="view-profile.php?viewid=<?php if (isset($row)) {
echo $row['member_profile_id'];
} ?>" class="btn btn-primary btn-with-icon">
<div class="ht-40 justify-content-between">
<span class="pd-x-15">View Profile</span>
<span class="icon wd-40"><i class="fa fa-eye"></i></span>
</div>
</a>
<?php if (isset($row)) {
if ($row['status'] == 0) {
?>
<a href='all-profile.php?editid=<?php echo $row['id']; ?>' class='btn btn-success btn-with-icon'>
<div class='ht-40 justify-content-between'>
<span class='pd-x-15'>Active Profile</span>
<span class='icon wd-40'><i class='fa fa-key'></i></span>
</div>
</a>
<?php
} else {
?>
<a href="all-profile.php?ditid=<?php echo $row['id']; ?>" class="btn btn-warning btn-with-icon">
<div class="ht-40 justify-content-between">
<span class="pd-x-15">Deactive Profile</span>
<span class="icon wd-40"><i class="fa fa-key"></i></span>
</div>
</a>
<?php
}
} ?>
<a href="all-profile.php?delid=<?php echo $row['id']; ?>" class="btn btn-danger btn-with-icon" onclick="return checkDelete()">
<div class="ht-40 justify-content-between">
<span class="pd-x-15">Delete Profile</span>
<span class="icon wd-40"><i class="fa fa-trash"></i></span>
</div>
</a>
</td>
<td>
<?php if (isset($row)) {
if ($row['status'] == 0) {
?>
<a class='btn btn-danger btn-with-icon' style="color: white;">
<div class='ht-40 justify-content-between'>
<span class='pd-x-15'>Profile Not Active</span>
</div>
</a>
<?php
} else {
?>
<?php
if ($row['membership'] == 0) {
?>
<a href='all-profile.php?memeid=<?php echo $row['id']; ?>' class='btn btn-success btn-with-icon'>
<div class='ht-40 justify-content-between'>
<span class='pd-x-15'>Active Membership</span>
<span class='icon wd-40'><i class='fa fa-key'></i></span>
</div>
</a>
<?php
} else {
?>
<a href="all-profile.php?memid=<?php echo $row['id']; ?>" class="btn btn-warning btn-with-icon">
<div class="ht-40 justify-content-between">
<span class="pd-x-15">Deactive Member Ship</span>
<span class="icon wd-40"><i class="fa fa-key"></i></span>
</div>
</a>
<?php
}
?>
<?php
}
} ?>
</td>
</tr>
<?php }
} ?>
<?php } ?>
<div class="ht-80 bd d-flex align-items-center justify-content-center">
<nav aria-label="Page navigation">
<ul class="pagination pagination-basic mg-b-0">
<li class="page-item active"><a href="?pageno=1" class="page-link">First</a></li>
<li class="<?php if ($pageno <= 1) {
echo 'disabled';
} ?> page-item">
<a href="<?php if ($pageno <= 1) {
echo '#';
} else {
echo "?pageno=" . ($pageno - 1);
} ?>" class="page-link">Prev</a>
</li>
<li class="<?php if ($pageno >= $total_pages) {
echo 'disabled';
} ?> page-item">
<a href="<?php if ($pageno >= $total_pages) {
echo '#';
} else {
echo "?pageno=" . ($pageno + 1);
} ?> " class="page-link">Next</a>
</li>
<li class="page-item"><a href="?pageno=<?php echo $total_pages; ?>" class="page-link">Last</a></li>
</ul>
</nav>
</div>
</tbody>
</table>
</div><!-- table-wrapper -->
</div><!-- br-section-wrapper -->
</div><!-- br-pagebody -->
<?php
require_once('include/footer.php');
?>
</div><!-- br-mainpanel -->
<!-- ########## END: MAIN PANEL ########## -->
<script src="lib/jquery/jquery.js"></script>
<script src="lib/popper.js/popper.js"></script>
<script src="lib/bootstrap/bootstrap.js"></script>
<script src="lib/perfect-scrollbar/js/perfect-scrollbar.jquery.js"></script>
<script src="lib/moment/moment.js"></script>
<script src="lib/jquery-ui/jquery-ui.js"></script>
<script src="lib/jquery-switchbutton/jquery.switchButton.js"></script>
<script src="lib/peity/jquery.peity.js"></script>
<script src="lib/highlightjs/highlight.pack.js"></script>
<script src="lib/datatables/jquery.dataTables.js"></script>
<script src="lib/datatables-responsive/dataTables.responsive.js"></script>
<script src="lib/select2/js/select2.min.js"></script>
<script src="js/bracket.js"></script>
<script>
$(function() {
'use strict';
$('#datatable1').DataTable({
responsive: true,
language: {
searchPlaceholder: 'Search...',
sSearch: '',
lengthMenu: '_MENU_ items/page',
}
});
$('#datatable2').DataTable({
bLengthChange: false,
searching: false,
responsive: true
});
// Select2
$('.dataTables_length select').select2({
minimumResultsForSearch: Infinity
});
});
</script>
</body>
</html>
<?php } ?>