<?php
$con = mysqli_connect("localhost", "test", "b;Jx]eS1uU*=", "test");
session_start();
if (!isset($_SESSION['loggedin']) && $_SESSION['loggedin'] != true) {
header("Location: login.php");
}
if(isset($_POST['update'])){
$name = $_POST['name'];
$email = $_POST['email'];
$score = $_POST['score'];
$ppa = $_POST['ppa'];
$hash = $_POST['hash'];
$uid = $_POST['uid'];
$sql = "UPDATE `unity_users` SET `name`='$name',`email`='$email',`score`='$score',`hash`='$hash',`ppa`='$ppa' WHERE `uid` = '$uid'";
if(mysqli_query($con,$sql)){
echo '<script> alert("Successfully Updated"); </script>';
}else{
echo '<script> alert("Ops! Cannot Update"); </script>';
}
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<title>Unity Game</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
<link rel="stylesheet" href="https://cdn.datatables.net/1.10.16/css/jquery.dataTables.min.css">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
<script src="https://code.jquery.com/jquery-1.12.4.js"></script>
<script src="https://cdn.datatables.net/1.10.16/js/jquery.dataTables.min.js"></script>
<script src="https://unpkg.com/sweetalert2@7.20.10/dist/sweetalert2.all.js"></script>
<!-- Optional: include a polyfill for ES6 Promises for IE11 and Android browser -->
<script src="https://unpkg.com/promise-polyfill"></script>
<script type="text/javascript">
$(document).ready(function() {
$('#example').DataTable();
$(".details").click(function(){
// Holds the product ID of the clicked element
var categoryID = $(this).attr('id');
var categoryIDArr = categoryID.split("_");
var type = categoryIDArr[0];
var ID = categoryIDArr[1];
$.ajax({
url: "functions.php",
type: "POST",
data:{type:type,ID:ID,UnityGame:"UnityGame"},
success: function(html){
if(html=="Login"){
swal(
'Error!',
'Please login to continue!',
'error'
)
}else if(html=="NotFound"){
swal(
'Error!',
'Record not found deleted!',
'error'
)
}else if(html=="Deleted"){
swal(
'Deleted!',
'Record Successfully deleted!',
'success'
)
location.reload();
}else if(html=="Server"){
swal(
'Error!',
'Ops! Please Try Again!',
'error'
)
}else{
$("#categoryModel").html(html);
}
}
});
});
});
</script>
<style type="text/css">
img.img-rounded.img-responsive {
width: 70px !important;
}
.jumbotron {
padding-top: 5px;
padding-bottom: 20px;
}
.navbar-default {
margin-bottom: 0;
}
</style>
</head>
<body>
<nav class="navbar navbar-default">
<div class="container-fluid">
<div class="navbar-header">
<button type="button" class="navbar-toggle" data-toggle="collapse" data-target="#myNavbar">
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
<a class="navbar-brand" href="#">Unity Game</a>
</div>
<div class="collapse navbar-collapse" id="myNavbar">
<ul class="nav navbar-nav">
<li class="active"><a href="index.php">Home</a></li>
<li><a href="adduser.php">Add User</a></li>
<li><a href="conversion.php">Conversion Rate</a></li>
</ul>
<ul class="nav navbar-nav navbar-right">
<li><a href="logout.php"><span class="glyphicon glyphicon-log-out"></span> Logout</a></li>
</ul>
</div>
</div>
</nav>
<div class="jumbotron text-center">
<h1>Unity User</h1>
<p>Add user data and edit anything here!</p>
</div>
<div class="container">
<div class="row">
<table id="example" class="table table-hover display" style="width:100%">
<thead>
<tr>
<th>Id#</th>
<th>Name</th>
<th>Email</th>
<th>Score</th>
<th>PPA</th>
<th>Hash</th>
<th>Payment</th>
<th>Delete</th>
<th>Edit</th>
</tr>
</thead>
<tbody>
<?php
$sql = "SELECT * FROM `unity_users`";
$res = mysqli_query($con,$sql);
if(mysqli_num_rows($res)>0){
while ($row = mysqli_fetch_assoc($res)) {
echo '<tr>';
echo '<td>'.$row['uid'].'</td>';
echo '<td>'.$row['name'].'</td>';
echo '<td>'.$row['email'].'</td>';
echo '<td>'.$row['score'].'</td>';
echo '<td>'.$row['ppa'].'</td>';
echo '<td>'.$row['hash'].'</td>';
if($row['payment']=="Released"){
$payment = "requested";
}else{
$payment = "pending";
}
echo '<td>'.$payment.'</td>';
echo '<td class="pointer"><i id="delete_'.$row['uid'].'" class="fa fa-trash fa-2x details" aria-hidden="true"></i></td>';
echo '<td class="pointer"><i data-toggle="modal" data-target="#myModal" id="edit_'.$row['uid'].'" class="fa fa-pencil-square-o fa-2x details" aria-hidden="true"></i></td>';
echo '</tr>';
}
}
?>
</tbody>
<tfoot>
<tr>
<th>Id#</th>
<th>Name</th>
<th>Email</th>
<th>Score</th>
<th>PPA</th>
<th>Hash</th>
<th>Payment</th>
<th>Delete</th>
<th>Edit</th>
</tr>
</tfoot>
</table>
</div>
</div>
<!-- Modal -->
<div class="modal fade" id="myModal" role="dialog">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal">×</button>
<h4 style="text-align: center;margin-top: 1%;font-size: 25px;" class="modal-title">User Data</h4>
</div>
<div class="modal-body" id="categoryModel">
</div>
</div>
</div>
</div>
</body>
</html>
PH
