.

<?php
 require('connect.php');

if (isset($_POST['username']) and isset($_POST['password'])){

$username = $_POST['username'];
$password = $_POST['password'];

$query = "SELECT * FROM `user` WHERE username='$username' and password='$password'";

$result = mysqli_query($connection, $query) or die(mysqli_error($connection));
$count = mysqli_num_rows($result);

if ($count == 1){
if ($count["premium"] == 0){
$premium = "true";
} else {
$premium = "false";
}
$output = "{\"status\":\"success\", \"username\":\"$username\", \"premium\":\"$premium\"}";
die($output);
}else{
die('{"status":"failure"}');
}
}
?>