<?php


	include "config.php";
    
    	$un = $_POST['username'];
    	$pw = $_POST['password'];

	

	/*$query = "insert into tuser (user_name, user_password) values ('$un','$pw')";
	$stmt = sqlsrv_query($connection, $query);
	*/
  	
	$params = array();
	$options =  array( "Scrollable" => SQLSRV_CURSOR_KEYSET );
	$query = "SELECT user_name FROM tuser where user_name = '$un' AND user_password ='$pw'";
	$stmt = sqlsrv_query($connection, $query, $params, $options);
  	 
  	
	$row_count = sqlsrv_num_rows( $stmt );
    	
  	
 	if ($row_count === false)
   		echo "Error in retrieveing row count.";
	else
	{
   		while($post = sqlsrv_fetch_array($stmt)) 
    		{
			$posts[] = $post;
    		}
		print(json_encode($posts));		
		
	}

	sqlsrv_free_stmt( $stmt);


	

?>



try{
        			      jArray = new JSONArray(res);
        			      JSONObject json_data=null;
        			     
        			      for(int i=0;i<jArray.length();i++){
        			             json_data = jArray.getJSONObject(i);
        			             varuser=json_data.getString("user_name");
        			             
        			         }
        			      //txtdebug.setText(vartotaluser);
        			      }
        			      catch(JSONException e1){
        			    	  Toast.makeText(getBaseContext(), "No Username Found" ,Toast.LENGTH_LONG).show();
        			      } catch (ParseException e1) {
        						e1.printStackTrace();
        				}