Guest User

Untitled

a guest
Jan 17th, 2018
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.56 KB | None | 0 0
  1. @Override
  2. public void onClick(View view) {
  3. Thread thread = new Thread(new Runnable() {
  4. @Override
  5. public void run() {
  6. final String resultado = enviarDatos(String.valueOf(asignatura.getSelectedItemPosition()+1),
  7. String.valueOf(seccion.getSelectedItemPosition()+1),
  8. String.valueOf(grupo.getSelectedItemPosition()+1));
  9. runOnUiThread(new Runnable() {
  10. @Override
  11. public void run() {
  12. int r = obtenerJSON(resultado);
  13. if(r>0){
  14. Toast.makeText(PreIngresoNotas.this, "CORRECTO", Toast.LENGTH_SHORT).show();
  15. }else{
  16. Toast.makeText(PreIngresoNotas.this, "Ha fallado", Toast.LENGTH_SHORT).show();
  17. }
  18. }
  19. });
  20. }
  21. });
  22. thread.start();
  23. }
  24.  
  25. public String enviarDatos(String cur, String sec, String gru){
  26.  
  27. String linea = "";
  28. StringBuilder sb = null;
  29. int respuesta = 0;
  30.  
  31. try{
  32.  
  33. URL url = new URL("http://192.168.1.55/proyecto/listalumno.php?curso="+cur+"&seccion="+sec+"&grupo="+gru);
  34.  
  35. HttpURLConnection conexion = (HttpURLConnection) url.openConnection();
  36. respuesta = conexion.getResponseCode();
  37.  
  38. sb = new StringBuilder();
  39.  
  40. if(respuesta==HttpURLConnection.HTTP_OK){
  41.  
  42. InputStream inputStream = new BufferedInputStream(conexion.getInputStream());
  43. BufferedReader bufferedReader = new BufferedReader(new InputStreamReader(inputStream));
  44.  
  45. while ((linea = bufferedReader.readLine())!=null){
  46. sb.append(linea + "n");
  47.  
  48. }
  49. inputStream.close();
  50. }
  51.  
  52. }catch (Exception e){
  53. e.printStackTrace();
  54. }
  55. return sb.toString();
  56. }
  57.  
  58.  
  59. public int obtenerJSON(String response){
  60. int res = 0;
  61.  
  62. try {
  63. JSONArray array = new JSONArray(response);
  64. if(array.length()>0){
  65. res = 1;
  66. }
  67.  
  68. /*for (int i=0;i<array.length();i++){
  69. usuario.setText(array.getJSONObject(i).getString("usuario"));
  70. nombre.setText(array.getJSONObject(i).getString("nombre"));
  71. apellido.setText(array.getJSONObject(i).getString("apellido"));
  72. }*/
  73.  
  74. }catch (Exception e){
  75. e.printStackTrace();
  76. }
  77. return res;
  78. }
  79. }
  80.  
  81. asignatura.getSelectedItemPosition()+1
  82.  
  83. <?php
  84.  
  85. $conexion = mysqli_connect("localhost","root","mysql","android");
  86.  
  87. $curso = mysqli_real_escape_string($conexion,$_REQUEST["curso"]);
  88. $seccion = mysqli_real_escape_string($conexion,$_REQUEST["seccion"]);
  89. $grupo = mysqli_real_escape_string($conexion,$_REQUEST["grupo"]);
  90.  
  91.  
  92.  
  93. $query = mysqli_query($conexion,"select * from alumno where idcurso = '$curso' and idsec = '$seccion' and idgru = '$grupo'") or die(mysqli_error($conexion));
  94.  
  95.  
  96.  
  97. while($fila = mysqli_fetch_array($query, MYSQLI_ASSOC)){
  98. echo $fila["usuario"].",".$fila["nombre"].",".$fila["apellido"]."<br/>";
  99. }
  100.  
  101. ?>
  102.  
  103. JSONArray array = new JSONArray(response);
  104.  
  105. while($fila = mysqli_fetch_array($query, MYSQLI_ASSOC)){
  106.  
  107. $idalu = $fila["idalu"];
  108. $usuario = $fila["usuario"];
  109. $contra = $fila["contra"];
  110. $nombre = $fila["nombre"];
  111. $apellido = $fila["apellido"];
  112. $idcurso = $fila["idcurso"];
  113. $idsec = $fila["idsec"];
  114. $idgru = $fila["idgru"];
  115.  
  116.  
  117. $alumnos[] = array("id" => $idalu, "usuario" => $usuario, "ocontra" => $contra,
  118. "nombre" => $nombre, "apellido" => $apellido, "idcurso" => $idcurso,
  119. "idsec" => $idsec, "idgru" => $idgru);
  120.  
  121. }
  122.  
  123. $json = json_encode($alumnos);
  124. echo $json;
Add Comment
Please, Sign In to add comment