File: /var/www/vhosts/uat-api.tsprojects.net/httpdocs/ratemycoach-web/PSManagement.php
<?php
session_start();
if (!isset($_SESSION['username']))
{
header('Location: ./errorpage.php');
exit;
}
if ($_SERVER['REQUEST_METHOD'] == 'POST' && isset($_POST['form_name']) && $_POST['form_name'] == 'logoutform')
{
unset($_SESSION['username']);
unset($_SESSION['fullname']);
header('Location: ./adminlogout.php');
exit;
}
?>
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Coach RYCH - Rate Your Coach</title>
<meta name="generator" content="WYSIWYG Web Builder 17 - http://www.wysiwygwebbuilder.com">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="css/font-awesome.min.css" rel="stylesheet">
<link href="css/coachRychVer2.0.css" rel="stylesheet">
<link href="css/PSManagement.css" rel="stylesheet">
<script src="js/jquery-1.12.4.min.js"></script>
<script src="js/jquery.ui.effect.min.js"></script>
<script>
$(document).ready(function()
{
$("a[href*='#headerLayoutGrid']").click(function(event)
{
event.preventDefault();
$('html, body').stop().animate({ scrollTop: $('#wb_headerLayoutGrid').offset().top }, 600, 'easeOutCirc');
});
$("a[href*='#LayoutGrid2']").click(function(event)
{
event.preventDefault();
$('html, body').stop().animate({ scrollTop: $('#wb_LayoutGrid2').offset().top }, 600, 'easeOutCirc');
});
$.fn.alternateRowColors = function()
{
$('tbody tr:odd', this).removeClass('even').addClass('odd');
$('tbody tr:even', this).removeClass('odd').addClass('even');
return this;
};
$('table.sortable').each(function()
{
var $dataviewer = $(this);
$dataviewer.alternateRowColors();
$('th', $dataviewer).each(function(column)
{
var $header = $(this);
var findSortKey;
findSortKey = function($cell)
{
return $cell.find('.sort-key').text().toUpperCase() + ' ' + $cell.text().toUpperCase();
};
if (findSortKey)
{
$header.addClass('clickable').hover(function()
{
$header.addClass('hover');
}, function()
{
$header.removeClass('hover');
}).click(function()
{
var sortDirection = 1;
if ($header.is('.sorted-asc'))
{
sortDirection = -1;
}
var rows = $dataviewer.find('tbody > tr').get();
$.each(rows, function(index, row)
{
var $cell = $(row).children('td').eq(column);
row.sortKey = findSortKey($cell);
});
rows.sort(function(a, b)
{
if (a.sortKey < b.sortKey) return -sortDirection;
if (a.sortKey > b.sortKey) return sortDirection;
return 0;
});
$.each(rows, function(index, row)
{
$dataviewer.children('tbody').append(row);
row.sortKey = null;
});
$dataviewer.find('th').removeClass('sorted-asc').removeClass('sorted-desc');
if (sortDirection == 1)
{
$header.addClass('sorted-asc');
}
else
{
$header.addClass('sorted-desc');
}
$dataviewer.find('td').removeClass('sorted').filter(':nth-child(' + (column + 1) + ')').addClass('sorted');
$dataviewer.alternateRowColors();
});
}
});
});
});
</script>
</head>
<body>
<div id="wb_headerLayoutGrid">
<div id="headerLayoutGrid">
<div class="row">
<div class="col-1">
<div id="wb_Image8">
<img src="images/logoRedStars.png" id="Image8" alt="" width="165" height="90">
</div>
</div>
<div class="col-2">
<div id="wb_Image1">
<img src="images/CoachRYCHTitleNew2.png" id="Image1" alt="" width="1036" height="156">
</div>
</div>
</div>
</div>
</div>
<div id="upStickyLayer">
<div id="wb_upIcon">
<a href="#headerLayoutGrid"><div id="upIcon"><i class="fa fa-arrow-up"></i></div></a></div>
</div>
<div id="wb_LayoutGrid2">
<div id="LayoutGrid2">
<div class="row">
<div class="col-1">
</div>
<div class="col-2">
<div id="wb_Text3">
<span style="color:#FFFFFF;font-family:Arial;font-size:29px;"><strong>Professional Services Management</strong></span>
</div>
<div id="wb_LayoutGrid5">
<div id="LayoutGrid5">
<div class="row">
<div class="col-1">
<div id="wb_ResponsiveMenu2">
<label class="toggle" for="ResponsiveMenu2-submenu" id="ResponsiveMenu2-title">Menu<span id="ResponsiveMenu2-icon"><span> </span><span> </span><span> </span></span></label>
<input type="checkbox" id="ResponsiveMenu2-submenu">
<ul class="ResponsiveMenu2" id="ResponsiveMenu2" role="menu">
<li role="menuitem"><a href="./PSManagement.php"><i class="fa fa-align-justify fa-2x"> </i><br>List of PS Consultants</a></li>
<li role="menuitem"><a href="./PSvideosNeedAprv.php"><i class="fa fa-american-sign-language-interpreting fa-2x"> </i><br>Videos Need Approval</a></li>
<li role="menuitem"><a href="./PSvideosApproved.php"><i class="fa fa-question-circle fa-2x"> </i><br>Videos Approved</a></li>
<li role="menuitem"><a href="./PSvideosRejected.php"><i class="fa fa-times-circle fa-2x"> </i><br>Videos Rejected</a></li>
<li role="menuitem"><a href="./bodashboard.php"><i class="fa fa-home fa-2x"> </i><br>Dashboard</a></li>
</ul>
</div>
<div id="wb_LayoutGrid3">
<div id="LayoutGrid3">
<div class="row">
<div class="col-1">
<div id="wb_Logout1">
<form name="logoutform" method="post" action="<?php echo basename(__FILE__); ?>" id="logoutform">
<input type="hidden" name="form_name" value="logoutform">
<button type="submit" name="logout" value="Logout" id="Logout1">Logout</button>
</form>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="col-3">
</div>
</div>
</div>
</div>
<div id="wb_LayoutGrid4">
<div id="LayoutGrid4">
<div class="row">
<div class="col-1">
</div>
<div class="col-2">
<div id="wb_Text2">
<span style="color:#652D90;font-family:Arial;font-size:24px;"><strong>List of Professional Services Consultants</strong></span>
</div>
<div id="wb_Text7">
<span style="color:#FF0000;font-family:Arial;font-size:16px;"><em>Please logout when finish</em>.</span>
</div>
</div>
<div class="col-3">
</div>
</div>
</div>
</div>
<div id="wb_LayoutGrid10">
<div id="LayoutGrid10">
<div class="row">
<div class="col-1">
</div>
<div class="col-2">
<div id="wb_Extension1">
<?php
$mysql_host = 'localhost';
$mysql_user = 'pxhlcbmy_ccast99942cr';
$mysql_password = 'rYCh2@23';
$mysql_database = 'pxhlcbmy_coachrychdb';
$mysql_table = 'users';
$db = mysqli_connect($mysql_host, $mysql_user, $mysql_password);
mysqli_select_db($db, $mysql_database);
mysqli_set_charset($db, 'utf8');
$sql = "SELECT business_name, point_of_contact, phone, email, city, state, category, primary_sports, created FROM ".$mysql_table;
$result = mysqli_query($db, $sql);
?>
<table cellpadding="0" cellspacing="0" width="100%" class="sortable paginated">
<thead>
<tr>
<th>Business Name</th>
<th> POC</th>
<th> Phone</th>
<th> Email</th>
<th> City</th>
<th> State</th>
<th> Category</th>
<th> Primary Sports</th>
<th> Date Created </th>
</tr>
</thead>
<tbody>
<?php
while ($row = mysqli_fetch_row($result))
{
echo " <tr>\n";
foreach ($row as $cell)
{
echo " <td>" . $cell . "</td>\n";
}
echo " </tr>\n";
}
?>
</tbody>
</table>
</div>
</div>
<div class="col-3">
</div>
</div>
</div>
</div>
<div id="wb_LayoutGrid1">
<div id="LayoutGrid1">
<div class="row">
<div class="col-1">
</div>
<div class="col-2">
<div id="wb_Shape2">
<img src="images/img0103.png" id="Shape2" alt="" width="42" height="210">
</div>
</div>
</div>
</div>
</div>
<div id="wb_footer">
<div id="footer">
<div class="col-1">
<div id="wb_footerText">
<span style="color:#FFFFFF;">Copyright © 2022 BTL Agency, LLC</span>
</div>
</div>
</div>
</div>
</body>
</html>