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