<?php
   include "db.php"; 
   if(!empty($_POST['instId']))
   {
      $instId = $_POST['instId'];
      $instRec = array();
      $subUserLogins = "SELECT * FROM addSubUser where instanceId = '$instId'";
      $subUserLoginsData = mysqli_query($conn,$subUserLogins);


       $countQuery = "SELECT COUNT(*) FROM addSubUser where instanceId = '$instId'";
       $countQueryData = mysqli_query($conn,$countQuery);
       $countQueryRec = mysqli_fetch_array($countQueryData)[0]; 


      while($instUserData = mysqli_fetch_assoc($subUserLoginsData))
      {
         $id  = $instUserData['id'];
         $firstName  = $instUserData['firstName'];
         $lastName   = $instUserData['lastName'];
         $instanceId = $instUserData['instanceId'];
         $mailId     = $instUserData['mailId'];
         $password   = $instUserData['password']; 
         $phoneNo    = $instUserData['phoneNo']; 
         $countUser  = $countQueryRec;
         $instRec[] = array("id"=>$id,"firstName" => $firstName, "lastName" => $lastName, "instanceId" => $instanceId, "mailId" => $mailId, "password" => $password, "phoneNo" => $phoneNo, "countUser" => $countUser);
       }
       echo json_encode($instRec);
   }
?>