api ng v2ray ko

<?php
$dbhost = 'localhost';
$dbuser = 'user';
$dbpass = 'pass';
$dbname = 'db';

//database connection
  $connection = new mysqli($dbhost, $dbuser, $dbpass, $dbname);

//Check connection
  if ($connection->connect_errno) {
     printf("Failed to connect to database");
     exit();
  }


if(!empty($_GET['username'])){

  $user_id = $_GET['username'];
  $user_pass = $_GET['password'];
  $userid = $user_id;
  $userpass = $user_pass;
$PRE="user_name='$userid' AND auth_vpn=md5('$userpass') AND status='live' AND is_freeze=0 AND is_ban=0 AND duration > 0";
$VIP="user_name='$userid' AND auth_vpn=md5('$userpass') AND status='live' AND is_freeze=0 AND is_ban=0 AND vip_duration > 0";
$PRIV="user_name='$userid' AND auth_vpn=md5('$userpass') AND status='live' AND is_freeze=0 AND is_ban=0 AND private_duration > 0";
//Initialize
  $data = array();



    $query = "SELECT user_name FROM users WHERE user_name = $userid";
    $result = mysqli_query($connection, $query);

  $result = $connection->query("SELECT * FROM users WHERE $PRE OR $VIP OR $PRIV");

    if (  mysqli_num_rows ( $result ) === 1 ){



            //Print array in JSON format
            $data = 1;

        }

        else {
            $data = 0;

        }
        echo json_encode($data);

}else{

}
$connection->close();
?>