D:\host\scoreman.in\assisiinterschool2025closed\service1.php

<?php
include('dbconnect.php');
	   
echo '<?xml version="1.0" encoding="iso-8859-1"?> ';
if ($_SERVER['REQUEST_METHOD'] == 'GET')
{
	$req=$_GET["req"];
if($req=="prof")
{	
$skey=$_GET["sid"];
	if($skey !="")
{		$databaseQuery = 'SELECT * FROM applicationskldt23 where (regid= "'.$con->real_escape_string($skey).'")';
$result = mysqli_query($con,$databaseQuery) or die('Query failed: ' . mysqli_error());
}

if($result)
{
	echo "<skaters>";
	$row = mysqli_fetch_array($result);
	echo "<skater>";
	echo "<regid>";
		echo $row["regid"];
	echo "</regid>";
	echo "<sname>";
	echo $row["skatername"];
	echo "</sname>";
	echo "<dob>";
	echo trim($row["dob"]);
	echo "</dob>";
	echo "<photo>";
	echo $row["photo"];
	echo "</photo>";
	echo "<dobdoc>";
	echo $row["dobimage"];
	echo "</dobdoc>";
		echo "<fathername>";
	echo $row["fathersname"];
	echo "</fathername>";
	$username = $_SESSION['username'];
	$dt=trim($row["district"]);
	   echo "<dt>".$dt."</dt>";
	      echo "<login>a".$username."</login>";
		  		echo "<address>";
	echo $row["address"];
	echo "</address>";
	
   echo "<city>".trim($row["city"])."</city>";
   echo "<pin>".trim($row["pin"])."</pin>";
echo "<phone>".trim($row["phone"])."</phone>";
echo "<email>".trim($row["email"])."</email>";
echo "<parentoccupation>".trim($row["parentoccupation"]). "</parentoccupation>";
echo "<school>".trim($row["school"]). "</school>";
echo "<clubname>".trim($row["clubname"]). "</clubname>";
echo "<clubname>".trim($row["club"]). "</clubname>";
	//if($dt==$username)
	if($username==$dt || $username=="secretary")
{
	 echo "<privilege>";
	echo "show";
	echo "</privilege>";

 }
 else
 {
	 echo "<privilege>";
	echo "hide";
	echo "</privilege>";
	
	 }
									   
echo "<bloodgroup>".trim($row["bloodgroup"])."</bloodgroup>";	   
   echo "<gender>".trim($row["gender"])."</gender>";
	echo "</skater>";
		echo "</skaters>";
}
} //profile ends

if($req=="load")
{	
$skey=$_GET["appno"];
	if($skey !="")
{		//$databaseQuery = 'SELECT * FROM skaterbase_'.strtolower($_SESSION['username']).' where (appno= "'.$con->real_escape_string($skey).'")';

	$dt=$_SESSION['username'];
		if($dt=="secretary")
	{
		$dt=$_SESSION['teamf'];
	//	$dt="Chennai";
	}
if($dt=="TRIVANDRUM")
{
	$dt="Thiruvananthapuram";
}


$databaseQuery = 'SELECT * FROM applicationskldt23  where (appno= "'.$con->real_escape_string($skey).'")';
$result = mysqli_query($con,$databaseQuery) or die('Query failed: ' . mysqli_error());
}



if($result)
{
	


	echo "<skaters><skater>";
	echo "<stat>ok</stat>";	
	while($data = mysqli_fetch_assoc($result)) {
  foreach($data as $key => $value) {
    echo "<$key>$value</$key>";
  }
	}

		echo "</skater></skaters>";
		
		
		

}
} //profile edit ends


if($req=="edit")
{	
$skey=$_GET["appno"];
	if($skey !="")
{		$databaseQuery = 'SELECT * FROM applications where (appno= "'.$con->real_escape_string($skey).'")';
$result = mysqli_query($con,$databaseQuery) or die('Query failed: ' . mysqli_error());
}



if($result)
{
	


	echo "<skaters><skater>";
	
	while($data = mysqli_fetch_assoc($result)) {
  foreach($data as $key => $value) {
    echo "<$key>$value</$key>";
  }
	}

		echo "</skater></skaters>";
		
		
		

}
} //profile edit ends


if($req=="appno")
{	
	$appno=0;
$databaseQuery = 'update counters set cnt=cnt+1 where item="appno"';
  $result1 = mysqli_query($con,$databaseQuery) or die('Query failed: ' . mysqli_error());
  
$databaseQuery = 'SELECT cnt FROM counters where item="appno"';
	$result = mysqli_query($con,$databaseQuery) or die('Query failed: ' . mysqli_error());
if($result)
{while($row = mysqli_fetch_array($result))
  {
	$appno=$row["cnt"];
	
  }
  echo "<result>";
  echo "<appno>";
  echo $appno;
    echo "</appno>";
	  echo "</result>";
  
}

}

}
if($req=="adjappno")
{	
	$adjappno=0;
$databaseQuery = 'update counters set cnt=cnt+1 where item="adjapp"';
  $result1 = mysqli_query($con,$databaseQuery) or die('Query failed: ' . mysqli_error());
  
$databaseQuery = 'SELECT cnt FROM counters where item="adjapp"';
	$result = mysqli_query($con,$databaseQuery) or die('Query failed: ' . mysqli_error());
if($result)
{while($row = mysqli_fetch_array($result))
  {
	$adjappno=$row["cnt"];
	
  }
  echo "<result>";
  echo "<adjappno>";
  echo "adj".$adjappno;
    echo "</adjappno>";
	  echo "</result>";
  
}
}



?>