<?php

$con=mysqli_connect("localhost","xxxxx,"xxxxxx","xxxxxx");

$groupname= $_POST["groupname"];
$grouppassword= $_POST["grouppassword"];
$loggedInUser= $_POST["loggedInUser"];

 $statement = mysqli_prepare($con, "SELECT * FROM MGroup WHERE group_name= ? AND group_password = ?");
    mysqli_stmt_bind_param($statement, "ss", $groupname, $grouppassword);
    mysqli_stmt_execute($statement);

mysqli_stmt_store_result($statement);
mysqli_stmt_bind_result($statement, $groupID, $groupname, $grouppassword, $group_owner);

$group= array();

while(mysqli_stmt_fetch($statement)){
    $group["groupname"]=$groupname;
    $group["grouppassword"]=$grouppassword;
    $group["group_owner"]=$group_owner;

}
echo json_encode($group);

//update logged-in user with his current group - its is not necessary the group owner

if(mysqli_num_rows($statement) == 1)  {
$statement= mysqli_prepare($con,"UPDATE User SET group_code = (SELECT group_id FROM MGroup WHERE group_name = ? ) WHERE username= ?");
mysqli_stmt_bind_param($statement,"ss",$groupname,$loggedInUser);
mysqli_stmt_execute($statement);

}

mysqli_stmt_close($statement);
mysqli_close($con);


?>