<?php
include "db.php"; 
$type = $_POST['type'];
if($type == 1){
    $id_No = $_POST['id_No'];
    $addInst = "SELECT * FROM addInstance where status = '1' and instanceId like '%".$id_No."%' order by id asc limit 5";
    $addInstData = mysqli_query($conn,$addInst);
    $addInst_arr = array();
    while($data = mysqli_fetch_assoc($addInstData)){
        $id           = $data['id'];
        $idNumber    = $data['instanceId']; 
        $addInst_arr[] = array("id" => $id, "idNumber" => $idNumber);
    }
    echo json_encode($addInst_arr);
} 

 if($type == 2){
    $keyid = $_POST['keyid'];
    $addInst2 = "SELECT * FROM addInstance where id = ".$keyid;
    $addInstData2 = mysqli_query($conn,$addInst2);
    $addInst_arr2 = array();
    while($data2 = mysqli_fetch_assoc($addInstData2)){
        $id                     = $data2['id'];
        $partnerId              = $data2['partnerId'];
        $instanceId             = $data2['instanceId'];
        $comapanyName           = $data2['comapanyName']; 
        $dateofcreation         = $data2['dateofcreation']; 
        $instanceExpiryDate     = $data2['instanceExpiryDate']; 
        $totalUsers             = $data2['totalUsers']; 
        $activeUsers            = $data2['activeUsers']; 
        $ratePerUser            = $data2['ratePerUser']; 
        $action                 = $data2['action']; 
        $totalDue               = $data2['totalDue']; 
        $billGeneratedDate      = $data2['billGeneratedDate']; 
        $amountPaidDetails      = $data2['amountPaidDetails']; 
        $UPILink                = $data2['UPILink']; 
        $tallyLicenseSlNo       = $data2['tallyLicenseSlNo']; 
        $tallyVersion           = $data2['tallyVersion']; 
        $tallyRelease           = $data2['tallyRelease']; 
        $tallyDotNetId          = $data2['tallyDotNetId']; 
        $tallyDotNetPassword    = $data2['tallyDotNetPassword']; 
        $tssExpiryDate          = $data2['tssExpiryDate']; 
        $contactPersonName      = $data2['contactPersonName']; 
        $mobileNo               = $data2['mobileNo']; 
        $emailId                = $data2['emailId']; 
        $loginPass              = $data2['loginPass']; 
        $rdpLoginId             = $data2['rdpLoginId']; 
        $password               = $data2['password']; 
        $filezillaId            = $data2['filezillaId']; 
        $password1              = $data2['password1']; 
        $status                 = $data2['status']; 
        $create_date            = $data2['create_date'];  
        $addInst_arr2[] = array("id"=>$id, "partnerId"=>$partnerId, "instanceId"=>$instanceId, "comapanyName"=>$comapanyName, "dateofcreation"=>$dateofcreation, "instanceExpiryDate"=>$instanceExpiryDate, "totalUsers"=>$totalUsers, "activeUsers"=>$activeUsers, "ratePerUser" =>$ratePerUser, "action"=>$action, "totalDue"=>$totalDue, "billGeneratedDate"=>$billGeneratedDate, "amountPaidDetails"=>$amountPaidDetails, "UPILink"=>$UPILink, "tallyLicenseSlNo"=>$tallyLicenseSlNo, "tallyVersion"=>$tallyVersion, "tallyRelease"=>$tallyRelease, "tallyDotNetId"=>$tallyDotNetId, "tallyDotNetPassword"=>$tallyDotNetPassword, "tssExpiryDate"=>$tssExpiryDate, "contactPersonName"=>$contactPersonName, "mobileNo"=>$mobileNo, "emailId"=>$emailId, "loginPass"=>$loginPass, "rdpLoginId"=>$rdpLoginId, "password"=>$password, "filezillaId"=>$filezillaId, "password1"=>$password1, "status"=>$status, "create_date"=>$create_date);
    }
    echo json_encode($addInst_arr2); 
}
?>