Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- @Override
- public void onClick(View view) {
- Thread thread = new Thread(new Runnable() {
- @Override
- public void run() {
- final String resultado = enviarDatos(String.valueOf(asignatura.getSelectedItemPosition()+1),
- String.valueOf(seccion.getSelectedItemPosition()+1),
- String.valueOf(grupo.getSelectedItemPosition()+1));
- runOnUiThread(new Runnable() {
- @Override
- public void run() {
- int r = obtenerJSON(resultado);
- if(r>0){
- Toast.makeText(PreIngresoNotas.this, "CORRECTO", Toast.LENGTH_SHORT).show();
- }else{
- Toast.makeText(PreIngresoNotas.this, "Ha fallado", Toast.LENGTH_SHORT).show();
- }
- }
- });
- }
- });
- thread.start();
- }
- public String enviarDatos(String cur, String sec, String gru){
- String linea = "";
- StringBuilder sb = null;
- int respuesta = 0;
- try{
- URL url = new URL("http://192.168.1.55/proyecto/listalumno.php?curso="+cur+"&seccion="+sec+"&grupo="+gru);
- HttpURLConnection conexion = (HttpURLConnection) url.openConnection();
- respuesta = conexion.getResponseCode();
- sb = new StringBuilder();
- if(respuesta==HttpURLConnection.HTTP_OK){
- InputStream inputStream = new BufferedInputStream(conexion.getInputStream());
- BufferedReader bufferedReader = new BufferedReader(new InputStreamReader(inputStream));
- while ((linea = bufferedReader.readLine())!=null){
- sb.append(linea + "n");
- }
- inputStream.close();
- }
- }catch (Exception e){
- e.printStackTrace();
- }
- return sb.toString();
- }
- public int obtenerJSON(String response){
- int res = 0;
- try {
- JSONArray array = new JSONArray(response);
- if(array.length()>0){
- res = 1;
- }
- /*for (int i=0;i<array.length();i++){
- usuario.setText(array.getJSONObject(i).getString("usuario"));
- nombre.setText(array.getJSONObject(i).getString("nombre"));
- apellido.setText(array.getJSONObject(i).getString("apellido"));
- }*/
- }catch (Exception e){
- e.printStackTrace();
- }
- return res;
- }
- }
- asignatura.getSelectedItemPosition()+1
- <?php
- $conexion = mysqli_connect("localhost","root","mysql","android");
- $curso = mysqli_real_escape_string($conexion,$_REQUEST["curso"]);
- $seccion = mysqli_real_escape_string($conexion,$_REQUEST["seccion"]);
- $grupo = mysqli_real_escape_string($conexion,$_REQUEST["grupo"]);
- $query = mysqli_query($conexion,"select * from alumno where idcurso = '$curso' and idsec = '$seccion' and idgru = '$grupo'") or die(mysqli_error($conexion));
- while($fila = mysqli_fetch_array($query, MYSQLI_ASSOC)){
- echo $fila["usuario"].",".$fila["nombre"].",".$fila["apellido"]."<br/>";
- }
- ?>
- JSONArray array = new JSONArray(response);
- while($fila = mysqli_fetch_array($query, MYSQLI_ASSOC)){
- $idalu = $fila["idalu"];
- $usuario = $fila["usuario"];
- $contra = $fila["contra"];
- $nombre = $fila["nombre"];
- $apellido = $fila["apellido"];
- $idcurso = $fila["idcurso"];
- $idsec = $fila["idsec"];
- $idgru = $fila["idgru"];
- $alumnos[] = array("id" => $idalu, "usuario" => $usuario, "ocontra" => $contra,
- "nombre" => $nombre, "apellido" => $apellido, "idcurso" => $idcurso,
- "idsec" => $idsec, "idgru" => $idgru);
- }
- $json = json_encode($alumnos);
- echo $json;
Add Comment
Please, Sign In to add comment