Untitled

<?php
session_start();
include_once 'dbconnect.php';

$servername = "localhost";
$username = "user";
$password = "pw";
$dbname = "name";
$conn = new mysqli($servername, $username, $password, $dbname);

if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}


$user_name = $userRow['user_name'];
$cprize = $_POST['cprize'];
$prize = $_POST['prize'];
$ticket = $_POST['ticket'];
$deposit = $_POST['deposit'];

if(isset($_POST['editp'])) {

$sql1 = "UPDATE  `deniiynz_lottery`.`admin` SET  `prize_current` =  '$cprize' WHERE  `admin`.`user_id` =1;";
if($conn->query($sql1) === TRUE) {
echo "The current prize is successfuly updated!!!";
} else {
echo "Error updating record: " . $conn->error;

}
}

if(isset($_POST['editpr'])) {

$sql2 = "UPDATE  `deniiynz_lottery`.`admin` SET  `prize_rate` =  '$prize' WHERE  `admin`.`user_id` =1;";
if($conn->query($sql2) === TRUE) {
echo "The current prize rate is successfuly updated!!!";
} else {
echo "Error updating record: " . $conn->error;

}
}

if(isset($_POST['editt'])) {

$sql3 = "UPDATE  `deniiynz_lottery`.`admin` SET  `ticket_rate` =  '$ticket' WHERE  `admin`.`user_id` =1;";
if($conn->query($sql3) === TRUE) {
echo "The current ticket rate is successfuly updated!!!";
} else {
echo "Error updating record: " . $conn->error;

}
}

if(isset($_POST['editd'])) {

$sql4 = "UPDATE  `deniiynz_lottery`.`admin` SET  `deposit_min` =  '$deposit' WHERE  `admin`.`user_id` =1;";
if($conn->query($sql4) === TRUE) {
echo "The current deposit minimum is successfuly updated!!!";
} else {
echo "Error updating record: " . $conn->error;

}
}


if(!isset($_SESSION['user']))
{
	header("Location: index.php");


}

$res=mysql_query("SELECT * FROM admin WHERE user_id=".$_SESSION['user']);
$userRow=mysql_fetch_array($res);

$conn->close();
?>
<html>
<style>
@font-face {
    font-family: 'bitcoinregular';
    src: url('bitcoin-webfont.eot');
    src: url('bitcoin-webfont.eot?#iefix') format('embedded-opentype'),
         url('bitcoin-webfont.woff2') format('woff2'),
         url('bitcoin-webfont.woff') format('woff'),
         url('bitcoin-webfont.ttf') format('truetype');
    font-weight: normal;
    font-style: normal;

}
</style>
<br>
<td><h2>Welcome Admin</h2>&nbsp;<a href="logout.php?logout">[Log Out]</a></td>
<br>
<h1>Tickets Sold :</h1>
<h1>Deposited Bitcoins : </h1>
<br>
<center>
<form method="post" action="<?php $PHP_SELF ?>">
<h2>Current Prize : <?php echo $userRow['prize_current']; ?>&nbsp<input type="text" name="cprize">&nbsp;<input type="submit" name="editp"

value="Edit"></h2>
<h2>Prize Rate : <?php echo $userRow['prize_rate']; ?>&nbsp;%&nbsp<input type="text" name="prize">&nbsp;<input type="submit" name="editpr"

value="Edit"></h2>
<h2>Ticket Rate : <?php echo $userRow['ticket_rate']; ?>&nbsp<font style="font-family: bitcoinregular, arial, sans-

serif">&#x0e3f;</font>&nbsp;<input type="text" name="ticket">&nbsp;<input type="submit" name="editt" value="Edit"></h2>
<h2>Deposit Minimum : <?php echo $userRow['deposit_min']; ?>&nbsp<input type="text" name="deposit">&nbsp;<input type="submit" name="editd"

value="Edit"></h2>
</form>
<br>
<br>

<br>
<br>
<h3>&copy Ticket Box 2016</h3>
</center>
</html>