$obj = new dbStudent(); echo $_GET['nHostelId']; echo $_GET['nRoomId']; // . "<script> alert( ".$_GET['nRoomId']." ) ; </script>"; echo $_GET['total']; // echo "<script> alert( '".$bb."' ) ; </script>"; $conn = $obj->dbconnectModel(); /*$results = $newObj->getAllFromStudentRoomAllocation(); $row = mysqli_fetch_assoc($results);*/ $updateAllocationQry = " UPDATE " . " tblstudentroomallocation " . " SET " . " isAllocated = 0 " . " WHERE " . " nHostelId = " . $_GET['nHostelId'] . " AND " . " nRoomId = " . $_GET['nRoomId']; mysqli_query($conn, $updateAllocationQry); $updateInStudent = "UPDATE " . " tblstudent " . " SET " . " bStaysAtHostel = 0 " . " WHERE " . " nGRNO IN ( " . " SELECT " . " nGRNO " . " FROM " . " tblstudentroomallocation " . " WHERE " . " isAllocated = 0 )"; mysqli_query($conn, $updateInStudent); $iterator = 1; while ($iterator <= $_GET['total']) { if ($obj->checkStudentExistence("tblstudentroomallocation", $_GET[$_GET['nRoomId'] . $iterator]) > 0) { ?> <script> alert( "in if=".$iterator ) ; </script> <?php $updateAllocationQry = " UPDATE " . " tblstudentroomallocation " . " SET " . " isAllocated = 1 " . " WHERE " . "nGRNO = " . $_GET[$_GET['nRoomId'] . $iterator]; mysqli_query($conn, $updateAllocationQry); $updateInStudent = "UPDATE " . " tblstudent " . " SET " . "bStaysAtHostel = 1 " . " Where " . " nGRNO = " . $_GET[$_GET['nRoomId'] . $iterator]; mysqli_query($conn, $updateInStudent); } else { echo $_GET['nHostelId']; echo $_GET['nRoomId']; echo $_GET[$_GET['nRoomId'] . $iterator]; $insertQry = "INSERT INTO " . " tblstudentroomallocation " . " ( nHostelId, nRoomId, nGRNO, isAllocated) " . " VALUES ( " . $_GET['nHostelId'] . ", " . $_GET['nRoomId'] . ", " . $_GET[$_GET['nRoomId'] . $iterator] . ", " . " 1 " . " ) ";