El Cóndor's questions

I download a CSV (unicode) file from a website, the fields are separated by tabs and between double quotes and the line break does not make it at the end of each row as seen in the CSV, example of how the information is seen of the CSV when opening it with notepad:

"campo1"    "campo2"    "campo3"    "campo4"    
"campo5"    "campo6"    "000000AA1011"  "000000AA1012"  
"000000AA1013" "000000AA1014"   "000000AA1015"  "000000AA1016"  
"000000AA1017"  "000000AA1018"  "000000AA1019" "000000AA1020"   
"000000AA1021"  "000000AA1022"  

I want to convert it to CSV(utf-8) so that the fields are separated by commas and are not between double quotes and the line break is done as seen in the CSV and in this way I can do the LOAD DATA LOCAL INFILEfrom MySQLand insert the CSV records without any problem to the table MySQL, example of how I want the CSV to look when opened with a notepad:

campo1,campo2,campo3,campo4,campo5,campo6
000000AA1011,000000AA1012,000000AA1013,000000AA1014,000000AA1015,000000AA1016
000000AA1017,000000AA1018,000000AA1019,000000AA1020,000000AA1021,000000AA1022

It is worth mentioning that in the 1st instance try to take the CSV(unicode) and insert it into the table MySQLas follows:

LOAD DATA LOCAL INFILE 'C:/data.csv' INTO TABLE bd.down_data
    FIELDS TERMINATED BY '\t' ESCAPED BY '"'
    LINES TERMINATED BY '\n' IGNORE 1 LINES
    (campo1, campo2, campo3);

This query inserts the data but puts a space after each character, example:

    campo1                       campo2                       campo3
0 0 0 0 0 0 A A 1 0 1 1     0 0 0 0 0 0 A A 1 0 1 2     0 0 0 0 0 0 A A 1 0 1 3
0 0 0 0 0 0 A A 1 0 1 7     0 0 0 0 0 0 A A 1 0 1 8     0 0 0 0 0 0 A A 1 0 1 9

and try to remove the spaces as follows:

Select REPLACE(campo1,' ','') as campo1 from bd.down_data;

but it does not make any changes, I imagine that the problem is the encoding of the original CSV file and therefore I want to correct the problem from the CSV (have the fields separated by commas and without double quotes when doing the LOAD DATA LOCAL INFILE) since if I save again the same CSV from the excel as CSV replacing it and I open it with the notepad it already appears separated by commas.

I am doing this in Python:

import csv

path =  'data.csv'

with open(path, 'r', encoding='utf-8', errors='ignore') as infile, open('final.csv', 'w') as outfile:
     inputs = csv.reader(infile)
     output = csv.writer(outfile)

     for index, row in enumerate(inputs):

         if index == 0:
             continue
         output.writerow(row)

I create the new file final.csvbut without any record and I get the following error:

Traceback (most recent call last):
  File "export.py", line 9, in <module>
    for index, row in enumerate(inputs):
_csv.Error: line contains NULL byte

UPDATE:

actual file:

https://drive.google.com/open?id=1LnCJVVc83HPAXAc88BMtKoHFIHpP5xtW

Good day

I have the following table in MySQL:

id     |    pais    |  categoria
193    |     BR     |     A
188    |     BR     |     A
133    |     BR     |     B
145    |     BR     |     C
124    |     CA     |     A
165    |     CA     |     B
113    |     CA     |     B
177    |     CA     |     C
197    |     MX     |     A
213    |     MX     |     B
208    |     MX     |     C
222    |     MX     |     C

I want to get the category total for each country in a different column, that is:

categoria  |  totalBR  |  totalCA  |  totalMX
    A      |    2      |    1      |    1
    B      |    1      |    2      |    1
    C      |    1      |    1      |    2

It occurs to me to create a temporary table for the total by country and category but I think it would not be such a good idea since I would have to create 9 temporary tables and then do aunion all

UPDATE

I get the 1st table from a query SQLand since I couldn't get the total of different columns of the 1st table, I modified my query SQLobtaining the following table:

  |      id     |    pais    |  categoriaBR  | categoriaCA  | categoriaMX  |
  |      193    |     BR     |     A         |     null     |    null      |
  |      188    |     BR     |     A         |     null     |    null      |
  |      133    |     BR     |     B         |     null     |    null      |
  |      145    |     BR     |     C         |     null     |    null      |
  |      124    |     CA     |    null       |       A      |    null      |
  |      165    |     CA     |    null       |       B      |    null      |
  |      113    |     CA     |    null       |       B      |    null      |
  |      177    |     CA     |    null       |       C      |    null      |
  |      197    |     MX     |    null       |     null     |      A       |
  |      213    |     MX     |    null       |     null     |      B       |
  |      208    |     MX     |    null       |     null     |      C       |
  |      222    |     MX     |    null       |     null     |      C       |

and create 9 temporary tables

#------------------------------------------------categoriasBR------------------------------------------------
DROP temporary table IF EXISTS categoriaBR1;
CREATE TEMPORARY TABLE IF NOT EXISTS categoriaBR1 AS ( 
    SELECT 1 as id, ifnull(sum(case when categoriaBR = 'A' then 1 else 0 end),0) as 'Total'
        FROM tabla
);

DROP temporary table IF EXISTS categoriaBR2;
CREATE TEMPORARY TABLE IF NOT EXISTS categoriaBR2 AS ( 
    SELECT 2 as id, ifnull(sum(case when categoriaBR = 'B' then 1 else 0 end),0) as 'Total'
        FROM tabla
);

DROP temporary table IF EXISTS categoriaBR3;
CREATE TEMPORARY TABLE IF NOT EXISTS categoriaBR3 AS ( 
    SELECT 3 as id, ifnull(sum(case when categoriaBR = 'C' then 1 else 0 end),0) as 'Total'
        FROM tabla
);

#------------------------------------------------categoriasCA------------------------------------------------
    DROP temporary table IF EXISTS categoriaCA4;
CREATE TEMPORARY TABLE IF NOT EXISTS categoriaCA4 AS ( 
    SELECT 1 as id, ifnull(sum(case when categoriaCA = 'A' then 1 else 0 end),0) as 'Total'
        FROM tabla
);

DROP temporary table IF EXISTS categoriaCA5;
CREATE TEMPORARY TABLE IF NOT EXISTS categoriaCA5 AS ( 
    SELECT 2 as id, ifnull(sum(case when categoriaCA = 'B' then 1 else 0 end),0) as 'Total'
        FROM tabla
);

DROP temporary table IF EXISTS categoriaCA6;
CREATE TEMPORARY TABLE IF NOT EXISTS categoriaCA6 AS ( 
    SELECT 3 as id, ifnull(sum(case when categoriaCA = 'C' then 1 else 0 end),0) as 'Total'
        FROM tabla
);

#---------------------------------------------------categoriasMX--------------------------------------------------
DROP temporary table IF EXISTS categoriaMX7;
CREATE TEMPORARY TABLE IF NOT EXISTS categoriaMX7 AS ( 
    SELECT 1 as id, ifnull(sum(case when categoriaMX = 'A' then 1 else 0 end),0) as 'Total'
        FROM tabla
);

DROP temporary table IF EXISTS categoriaMX8;
CREATE TEMPORARY TABLE IF NOT EXISTS categoriaMX8 AS ( 
    SELECT 2 as id, ifnull(sum(case when categoriaMX = 'B' then 1 else 0 end),0) as 'Total'
        FROM tabla
);

DROP temporary table IF EXISTS categoriaMX9;
CREATE TEMPORARY TABLE IF NOT EXISTS categoriaMX9 AS ( 
    SELECT 3 as id, ifnull(sum(case when categoriaMX = 'C' then 1 else 0 end),0) as 'Total'
        FROM tabla
);
#------------------------------------UNION DE TODO---------------------------------------------------------------    
select 'A' as Categoria, categoriaBR1.Total as TotalBR, categoriaCA1.Total as TotalCA, categoriaMX1.Total as TotalMX from categoriaBR1
        INNER JOIN categoriaCA1 ON categoriaBR1.id = categoriaCA1.id
        INNER JOIN categoriaMX1 ON categoriaBR1.id = categoriaMX1.id
    union all
select 'B' as Categoria, categoriaBR2.Total as TotalBR, categoriaCA2.Total as TotalCA, categoriaMX2.Total as TotalMX from categoriaBR2
        INNER JOIN categoriaCA2 ON categoriaBR2.id = categoriaCA2.id
        INNER JOIN categoriaMX2 ON categoriaBR2.id = categoriaMX2.id
    union all
select 'C' as Categoria, categoriaBR3.Total as TotalBR, categoriaCA3.Total as TotalCA, categoriaMX3.Total as TotalMX from categoriaBR3
        INNER JOIN categoriaCA3 ON categoriaBR3.id = categoriaCA3.id
        INNER JOIN categoriaMX3 ON categoriaBR3.id = categoriaMX3.id

It is worth mentioning that with the creation of the 9 temporary tables I obtain the result that I want, but the idea that I have is to reach the same result without so many temporary tables.

First of all mention that I found questions similar to this one with possible solutions or closed for being duplicates but without a solution.

To pass the variable from JavaScriptto phpI decided to do it Ajaxthis way:

<script type="text/javascript">
        function ejecutar(){
		console.log("Inicia");
		var count = 5;
		$.ajax({
			url: "index.php",
			type: "POST",
			data: {num:count},

			success : function(json) {
		        console.log("success");
		    },

		    error : function(xhr, status) {
		        console.log("error "+" xhr: "+xhr+" Status: "+status);
		    },

		    complete : function(xhr, status) {
		        console.log("complete "+" xhr: "+xhr+" Status: "+status);
		        console.log("count = "+count);
		        console.log("num = "+num);
		    }
		});
		console.log("Fin");
            }
	</script>

And so I want to get the value of the variable in php:

<?php
if(isset($_POST['num'])){
	echo "num = ".$identificador;
}else{
	echo "variable vacia";
}
?>

This is my complete file index.php:

<!DOCTYPE html>
<html>
<head>
    <title>Ajax con php</title>
    <meta charset="utf-8">
    <script src="js/jquery-3.2.1.min"></script>

    <script type="text/javascript">

        function ejecutar(){
            console.log("Inicia");
            var count = 5;
            $.ajax({
                url: "index.php",
                type: "POST",
                data: {num:count},
                success : function(json) {
                    console.log("success");
                },

                error : function(xhr, status) {
                    console.log("error "+" xhr: "+xhr+" Status: "+status);
                },

                complete : function(xhr, status) {
                    console.log("complete "+" xhr: "+xhr+" Status: "+status);
                    console.log("count = "+count);
                    console.log("num = "+num);
                }
            });
            console.log("Fin");
        }
    </script>
</head>

<body>
<?php
    if(isset($_POST['num'])){
        echo "num = ".$identificador;
    }else{
        echo "variable vacia";
    }
?>
    <button type="button" onclick="ejecutar();">Ejecutar</button>
</body>
</html>

The result I get in the Google Chrome Developer Tools console is the following:

and in the browser the following:

Finally mention that it is the 1st time that I do this so if I am omitting something basic or simple an apology

I have the following code:

$sql = "CALL bd.spPrueba()";

$result = $conn->query($sql);

if ($result->num_rows > 0) { 

    while ($row[] = $result->fetch_assoc()) {

        $json = json_encode($row);

    }

} else {

    echo "0 results";

}

echo $json;

$conn->close();

And it gives me the following result:

[{"Clave":"79","Tiempo":"02:23:43","Estatus":"Si","FechaInicio":"2017-03-06 13:02:41"}]

But if I want to get each result to store it in a variable, that is to say this:

 $sql = "CALL bd.spPrueba()";

 $result = $conn->query($sql);

     if ($result->num_rows > 0) { 

         while ($row[] = $result->fetch_assoc()) {

             $Clave = $row["Clave"];
             $Tiempo = $row["Tiempo"];

             echo "<br>";
             echo "Clave = ".$Clave;
             echo "<br>";
             echo "Tiempo = ".$Tiempo;

             $json = json_encode($row);

         }

     } else {

         echo "0 results";

     }

     echo $json;
     $conn->close();

It just doesn't work and it doesn't save me anything, it just shows me the following:

Clave = 
Tiempo = 
[{"Clave":"79","Tiempo":"02:23:43","Estatus":"Si","FechaInicio":"2017-03-06 13:02:41"}]

Unless you remove the square brackets from the variable $rowin the whileie like this:

$sql = "CALL bd.spPrueba()";

$result = $conn->query($sql);

if ($result->num_rows > 0) { 

    while ($row = $result->fetch_assoc()) {

        $Clave = $row["Clave"];
        $Tiempo = $row["Tiempo"];

        echo "<br>";
        echo "Clave = ".$Clave;
        echo "<br>";
        echo "Tiempo = ".$Tiempo;

        $json = json_encode($row);

    }

} else {

    echo "0 results";

}

echo $json;
$conn->close();

And it would give me the following result:

Clave = 79
Tiempo = 02:23:43
{"Clave":"79","Tiempo":"02:23:43","Estatus":"Si","FechaInicio":"2017-03-06 13:02:41"}

If I make avar_dump();

In $row[]I can see the following:

array(1) { [0]=> array(8) { ["Clave"]=> string(2) "79" ["Tiempo"]=> string(8) "02:50:30" ["Estatus"]=> string(5) "Si" ["FechaInicio"]=> string(19) "2017-03-06 13:29:27" } } 

In rowI can see the following:

array(8) { ["Clave"]=> string(2) "79" ["Tiempo"]=> string(8) "02:51:04" ["Estatus"]=> string(5) "Si" ["FechaInicio"]=> string(19) "2017-03-06 13:30:01" } 

I would like to leave the brackets but to save the fields in variables phpbecause if I remove the brackets, the arrayJsonone I have in Android crashes.

I have the following ArrayList which I fill with information from a database

ArrayList<HashMap<String, String>> employeeList;
employeeList = new ArrayList<>();
private static final String TAG_NAME = "name";
public static final String TAG_DESIGNATION = "designation";

Log.d("INICIA ","employeeList= "+employeeList);

In the Logcat it gives me the following:

D/INICIA: employeeList= [{designation=manager, name=rick}]

Everything works fine but I have a doubt how I could access the value managerfound in the arrayList to be able to use it in a condition

The device in which the application will be will always be in the same place but in that same place there are many Wi-Fi networks.

Investigating I found that there is the class: WifiManager and its methods: WIFI_STATE_ENABLED, getConfiguredNetworks well I don't know if what I want to do can be done and I also have no idea where to start can someone tell me if it is possible or not?

UPDATE

Apparently what I mentioned above is possible. So far I can get it to connect to a Wi-Fi network it has previously been connected to with the following:

public class MainActivity extends AppCompatActivity {

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);

          WifiManager wifiManager= (WifiManager)getSystemService(Context.WIFI_SERVICE);
          wifiManager.setWifiEnabled(true);
    }
}

However, I don't know how to specify which Wi-Fi network it should connect to.

I have the tablau:

Nombre  ApellidoP  ApellidoM
Juan    Ruiz       Robles
Pedro   Lopez      Lopez
Luis    Diaz       Ruiz

and the tablelog_users

id     fecha_delete  Nombre
null   null          null

Also I have the following Trigger:

       CREATE DEFINER=`root`@`localhost` TRIGGER PRUEBA_BD_TRIGGER

            BEFORE DELETE ON test.tablau 
            FOR EACH ROW 
            BEGIN 
            INSERT INTO test.log_users 
             (fecha_delete,Nombre) VALUES (now(),Nombre); 

        END

I remove records from the tablaulike this:

delete FROM test.tablau where Nombre = 'Luis';

The trigger does the following on the table log_users:

id     fecha_delete           Nombre
1      2017-01-11 14:49:13    

As you can see, it does not save the field Nombreof the deleted row, how can I do that in the Trigger?

I have 2 procedures stored in the same file, the connection is made correctly since if I delete any of the 2 procedures, the other one shows information, but if I leave both, only the first one is executed.

I have the file conectar.phpwith the following code:

class Clase_Conecta{
     var $_Server = 'localhost';
     var $_User = 'root';
     var $_Password = '';
     var $_Bd = 'bd1';

     function Fn_getConnect(){
        if (!($conexion = new mysqli($this -> _Server, $this -> _User, $this -> _Password, $this -> _Bd))){
           echo "Error Conectando la base de Datos";
           exit();
        }else{
          echo "conexion exitosa";
        }
        return $conexion;
     }
  }

And my file principal.phpwith the following:

include ("conectar.php");
$Fn = new Clase_Conecta();
$Cn = $Fn -> Fn_getConnect();

$sql1 = "call sp1()";
$r = query($sql1);

while ($rP = $r -> fetch_array()){
            //Imprime tabla
       }

//Hasta aquí funciona bien pero si quiero ejecutar otro procedimiento almacenado no lo hace
//solo ejecuta el de arriba (el primero)

$sql2 = "call sp2()";
$r2 = query($sql2);

 while ($rP2 = $r2 -> fetch_array()){
            //Imprime tabla
     }

I imagine that I am misunderstanding the concepts but I have already read and investigated and it is not entirely clear to me, please if someone is so kind as to guide me as to what I am doing wrong or what I am omitting

I will put a simple example of what I want to do, I have the table Usuarioswhich is updated every 90 seconds in this example the table will have the following information:

Usuarios

Nombre    Puerto      Ip
  Juan        4      192.168.1.1
  Juan        9      192.168.1.1
  Jorge       8      192.168.1.2
  Roberto     3      192.168.1.1

But in some update you can have the following information:

Usuarios

    Nombre    Puerto      Ip
      Juan        4      192.168.1.1
      Juan        9      192.168.1.1
      Jorge       2      192.168.1.2
      Jorge       8      192.168.1.2
      Roberto     3      192.168.1.1
      Roberto     7      192.168.1.1

To know in which team each user is, I do the following query:

 Select Nombre, Puerto, Ip,
         CASE WHEN Nombre='Juan' and Puerto>5 and Ip='192.168.1.1' THEN '20' ELSE
         CASE WHEN Nombre='Juan' and Puerto<6 and Ip='192.168.1.1' THEN '19' ELSE
         CASE WHEN Nombre='Jorge' and Puerto>5 and Ip='192.168.1.2' THEN '18' ELSE
         CASE WHEN Nombre='Jorge' and Puerto<6 and Ip='192.168.1.2' THEN '17' ELSE
         CASE WHEN Nombre='Roberto' and Puerto>5 and Ip='192.168.1.1' THEN '16' ELSE
         CASE WHEN Nombre='Roberto' and Puerto<6 and Ip='192.168.1.1' THEN '15'
         END END END END END END AS Equipo
From Usuarios
Order by Usuarios Desc

My result considering the first table is as follows:

Nombre    Puerto      Ip              Equipo
  Juan        9      192.168.1.1        20 
  Juan        4      192.168.1.1        19    
  Jorge       8      192.168.1.2        18
  Roberto     3      192.168.1.1        15

As you can see, it omits Teams 17 and 16 since the case, so I want to perform a query in which I identify which teams are found without using something like this:

Nombre    Puerto      Ip              Equipo    Estado
  Juan        9      192.168.1.1        20      En_uso
  Juan        4      192.168.1.1        19      En_uso
  Jorge       8      192.168.1.2        18      En_uso
  Jorge       2      192.168.1.2        17      Sin_usar
  Roberto     7      192.168.1.1        16      Sin_usar
  Roberto     3      192.168.1.1        15      En_uso

But since the table is updated and when the equipment is not in use, its information simply does not exist in the table, I do not know how to do it.

PS: The table is a simple example so ignore the logic of the table information, the table I am working with was not made by me

I have the following code htmlto create a table, I put it as an example, I want the rows of my table to look wider (if it works) and the same rows to look higher (it doesn't work), doing some research I found what Next:

The attribute heightdoes not work in all browsers, and its use is not widespread. The cells usually have the height they need to fit all the content that has been inserted, that is, they grow enough to fit what we have placed inside.

Can I do what I want directly in HTMLor should it be done with CSS?

  <table>
      <tr style="width:130%; height:150%;">
        <td>Enero</td>
        <td>$100</td>
      </tr>
      <tr>
        <td>Febrero</td>
        <td>$80</td>
      </tr>
    </table>

I am using CodeIgniter and I have the following function in my controller:

public function miFuncion{
  $sql_fecha = "CALL db.spFECHA();";//obtiene una fecha en formato datetime
  $query = $this->db->query($sql_fecha);

  $sql1 = "CALL db.spReport1('".$query."');";            
  $sql2 = "CALL db.spReport2('".$query."');";  
  $query1 = $this->db->query($sql1); 
  $query2 = $this->db->query($sql2);  
}

The variable $sql_fechais executed without problem because I did a test where I print the result in a table and there is no problem, but if I want to use the result that is saved in $queryto pass it to another procedure it does not consider it, I have tried to do a echo $query;but it does not print any.

I think there is something that I am not understanding yet, since I have always made the queries in my controller and I always print the result in a table but now I found this new situation where the result obtained I have to send it in a variable to another stored procedure , also change the variable $queryfor a fixed date in the parameters of $sql1and $sql2and it does it without any problem.

I have table1 with the following records:

campo1    campo2     campo3

Adrian      25       2016-09-17
Juan        27       2016-09-14
Alex        23       2016-09-03
Ana         31       2016-09-17
Rocio       29       2016-09-17

In the supposed case that field3 is always being modified but not all the records at the same time, as I can get only the records that have the most recent date, try to do it with max()

Select * from tabla1 where campo3 = max(campo3);

In this case I want to get the following result:

campo1    campo2     campo3

Adrian      25       2016-09-17
Ana         31       2016-09-17
Rocio       29       2016-09-17

but I repeat that date again, it will not be fixed, it will always be modified, so try to obtain the most recent date with max(), I already tried to group and nothing, if you are so kind to explain to me what I am failing or what would be the logic that applies

I mean what are the possible cases where a MySQL query does not occupy the indexes created on a table. I ask because I perform a query where I get 39000 records out of 41000 existing ones, using the statement explainI can notice that the indexes of the table are not being used. So can it be because it only fetches records from a single table and it's almost all of them? and if so, in what other cases could the same thing happen (indices not being used)?

I have the following stored procedure in MySQL, it works for me but nevertheless it brings me more records, I mean that there are several records that coincide in almost all the fields except in the series and in the date, for that reason I decided to order them as in a ranking .

CREATE DEFINER=`usuarioroot`@`%` PROCEDURE `spRank`()
BEGIN

set @report_rank := 0;
set @current  := 0; 

select a.*, 
       @report_rank := IF(@current  = clave , @report_rank + 1, 1) AS report_rank,
                                            @current  := clave              
  from (
    SELECT tabla1.serie,Count(*) as cantSerie,fecha,  
        CASE WHEN DateDiff(fecha,Now())<0 Then 0 Else  
        CASE WHEN DateDiff(fecha,Now())>0 AND DateDiff(fecha,Now())<20 Then 1 
                        Else 2 End End As Codfecha, 
                        DateDiff(Max(fecha),Now()) as DiasExp, 
                        CASE WHEN IsNull(seriePdf) Then 'No' Else 'Si' end as EnPdf,  
                        tabla2.clave,campo4 as antiguo 
                        From bd1.tabla1, bd1.tabla2, bd2.tabla3  ,
                            (SELECT tabla2.clave 
                                From bd1.tabla2, bd2.tabla3 
                                Where tabla2.clave = bd2.tabla3.clave 
                                Group By tabla2.clave) 
                                Subclave
                                Where tabla2.clave = bd2.tabla3.clave  
                                AND tabla1.serie=tabla2.serie  
                                and subclave.clave = tabla2.clave
                                GROUP BY tabla2.clave,tabla1.serie 
                                ) a
            ORDER BY antiguo,clave,fecha DESC,cantSerie,serie;

END

I can get the following result:

  serie    cantSerie         fecha       Codfecha   DiasExp  EnPdf  clave  antiguo report_rank @current :=clave

123AB0123      5     2016-04-26 00:00:00     0       -114      Si   01A1     NO        1                01A1
123AC0123      4     2014-03-26 00:00:00     0       -876      Si   01A1     NO        2                01A1
123BC0123      1     2013-03-30 00:00:00     0       -1237     Si   01A1     NO        3                01A1
123BD0123      5     2013-03-30 00:00:00     0       -1237     Si   01A1     NO        4                01A1
124BF0123      1     2016-06-10 00:00:00     0       -69       Si   01A2     NO        1                01A2
123BD0023      1     2013-03-30 00:00:00     0       -1237     Si   01A2     NO        2                01A2

But I only want the records that have report_rank = 1, I tried using the where clause like this: where @report_rank = 1 but it doesn't bring me any record and it doesn't give me an error, I would also like the last 2 fields not to be seen in the final result :report_rank @current :=clave

In a nutshell I want to get the following result:

  serie    cantSerie         fecha       Codfecha   DiasExp  EnPdf  clave  antiguo 

123AB0123      5     2016-04-26 00:00:00     0       -114      Si   01A1     NO        
124BF0123      1     2016-06-10 00:00:00     0       -69       Si   01A2     NO       

I want when executing this query

SELECT tabla1.campo1 
            From tabla1, tabla2 
            Where tabla1.campo1 = tabla2.campo1 
            Group By tabla1.campo1;

Which will give me, for example, 600 records, save the 600 records in an array to later use the index of the array (from 1 to 600) as a comparison in another query, as I must use an array and a for loop, but I already investigated and no I find a clear example, I would like to know the following things:

Can it do what I want?

Is it resource efficient?

Is there any better method?

I want to set the minimum and maximum value of a DatePickerDialogthat emerges when clicking on a EditTextDate type, according to what I have investigated it can be done with this:

setMaxDate(long maxDate)
setMinDate(long minDate)

But I don't know how to apply it to the code I have, my code is as follows:

public class MainActivity extends AppCompatActivity implements View.OnClickListener {
    public static EditText fechauso, horainicio;
    private int anio, dia, mes, hora, minuto;
    private static final int TIPO_DIALOGO = 0;
    private static DatePickerDialog.OnDateSetListener oyenteSelectorFecha;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);

        fechauso = (EditText) findViewById(R.id.txt_fechadeuso);
        horainicio = (EditText) findViewById(R.id.txt_horainicio);

        horainicio.setOnClickListener(this);
        fechauso.setInputType(InputType.TYPE_NULL);

        Calendar calendario = Calendar.getInstance();
        anio = calendario.get(Calendar.YEAR);
        mes = calendario.get(Calendar.MONTH);
        dia = calendario.get(Calendar.DAY_OF_MONTH);

        oyenteSelectorFecha = new DatePickerDialog.OnDateSetListener() {
            @Override
            public void onDateSet(DatePicker view, int year, int monthOfYear, int dayOfMonth) {
                anio = year;
                mes = monthOfYear;
                dia = dayOfMonth;
                mostrarFecha();
                horainicio.requestFocus();
            }
        };

        fechauso.setOnFocusChangeListener(new View.OnFocusChangeListener() {
            public void onFocusChange(View v, boolean hasFocus) {
                if (hasFocus) {
                    closeSoftKeyBoard();
                    mostrarCalendario(fechauso);
                }
            }
        });

        horainicio.setOnFocusChangeListener(new View.OnFocusChangeListener() {
            public void onFocusChange(View v, boolean hasFocus) {
                if (hasFocus) {
                    closeSoftKeyBoard();
                    mostrarTime();
                }
            }
        });
    }

    public void mostrarCalendario(View control) {
        showDialog(TIPO_DIALOGO);
    }

    public void mostrarFecha() {
        fechauso.setText(anio + "-" + (mes + 1) + "-" + dia);
    }

    public void mostrarTime() {
        // Get Current Time
        final Calendar c = Calendar.getInstance();
        hora = c.get(Calendar.HOUR);
        minuto = c.get(Calendar.MINUTE);

        TimePickerDialog timePickerDialog = new TimePickerDialog(this,
                new TimePickerDialog.OnTimeSetListener() {
            @Override
            public void onTimeSet(TimePicker view, int hourOfDay,
                                          int minute) {
                horainicio.setText(hourOfDay + ":" + minute + ":00");
            }
        }, hora, minuto, false);

        timePickerDialog.show();
    }

    @Override
    protected Dialog onCreateDialog(int id) {
        switch (id) {
            case 0:
                return new DatePickerDialog(this, oyenteSelectorFecha, anio, mes, dia);
        }

        return null;
    }

    public void closeSoftKeyBoard() {
        InputMethodManager inputMethodManager = (InputMethodManager) getSystemService(Context.INPUT_METHOD_SERVICE);
        inputMethodManager.hideSoftInputFromWindow(getCurrentFocus().getWindowToken(), 0);
    }

    @Override
    public void onClick(View v) {
        if (v == horainicio) {
            closeSoftKeyBoard();
            mostrarTime();
        }
    }
}

It happens that I have one Spinnerthat has 4 names:

   <string-array name="Nombres">
        <item>Seleccione</item>
        <item>Juan</item>
        <item>Pedro</item>
        <item>Carlos</item>
        <item>Jose</item>
    </string-array>

I want to save them in a MySQL database, but the field to save is of type int, since it is my foreign key to relate that table to another. In HTML I usually do it like this:

   <select class="nombre" name="nombre">
      <option>Seleccione</option>
      <option value="1">Juan</option>
      <option value="2">Pedro</option>
      <option value="3">Carlos</option>
      <option value="3">Jose</option>
   </select>

My question is can this be done on Android?:

   <string-array name="Nombres">
        <item>Seleccione</item>
        <item value="1">Juan</item>
        <item value="2">Pedro</item>
        <item value="3">Carlos</item>
        <item value="4">Jose</item>
    </string-array>

I haven't found a similar example, that's why I'm asking.

Right now, I'm doing it like this:

Spinner spinner_nombres = (Spinner)findViewById(R.id.sp_nombre);

ArrayAdapter adapter_d = ArrayAdapter.createFromResource(this, R.array.Nombres, R.layout.spiner_item);
spinner_nombres.setAdapter(adapter_d);

String selec = spinner_nombres.getSelectedItem().toString();
        int id_nombre = 0;
        if (selec.equals("Juan")) {
            id_nombre = 1;
        } else
        if (selec.equals("Pedro")) {
            id_nombre = 2;
        }
        else
        if (selec.equals("Carlos")) {
            id_nombre = 3;
        }
        else
        if (selec.equals("Jose")) {
            id_nombre = 4;
        }

And so I send it to PHP:

nameValuePairs = new ArrayList<NameValuePair>(1);
nameValuePairs.add(new BasicNameValuePair("idnombre",Integer.toString(id_nombre).trim()));

The detail is that I am using 14 Spinnersin my application and so much code is starting to drive me crazy, so I would really appreciate it if someone could help me.

Hello, I have a question about the best way to convert a string to a date in android.

fechauso = (EditText)findViewById(R.id.txt_fechadeuso);
String fechausoo = fechauso.getText().toString();

I want to convert it to date because just as I have it when saving it in a mysql database in a Date type field, it saves it like this:

0000-00-00

I am trying to solve it in the following way:

String newfecha = fechauso.getText().toString();
        try {
            SimpleDateFormat sdf = new SimpleDateFormat("dd-MM-yyyy");
            Date fecha = sdf.parse(newfecha);
        } catch (ParseException e){
            e.printStackTrace();
        }

nameValuePairs = new ArrayList<NameValuePair>(1);
 nameValuePairs.add(new BasicNameValuePair("fecha_prestamo",newfecha.trim()));

but it gives me the following error:

Incopatible types:
Required: java.sql.Date;
Found: java.util.Date

amount as follows:

import java.sql.Date;

but even so it continues to mark the error, I apologize if I'm asking something very basic, but seriously I'm lost...

First of all, I am new to Android, and I want to clarify that I have already investigated and searched for tutorials, what I intend to do is, solely and exclusively, that information can be saved in an Android application through a form which contains: EditTextand Spinners. It should be clarified that I have already done this on a web page, but now I want to create the application that performs the same function, that is, save.

I also want to clarify that I have already done this before in java, but I have been searching the Internet for days and days and I can't find any similar example. Also, from the little I have found, I have tried to adapt it to what I need and nothing. Is what I want to do very complicated or is it more difficult to do this kind of thing in Android?

Well, I don't want them to do the project for me, but could someone guide me on what I need to do?

After researching your advice I decided to try doing it natively and so far I have the following but I am having trouble saving the date formats and I have no idea how to save thespinners

I attach the image of my form (the button that saves says next because I still intend to make some changes)

The xml of the image above is as follows:

    <?xml version="1.0" encoding="utf-8"?>
<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:tools="http://schemas.android.com/tools"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    android:paddingBottom="@dimen/activity_vertical_margin"
    android:paddingLeft="@dimen/activity_horizontal_margin"
    android:paddingRight="@dimen/activity_horizontal_margin"
    android:paddingTop="@dimen/activity_vertical_margin"
    tools:context="com.example.server.guardar_a.MainActivity">

    <ScrollView
        android:layout_width="fill_parent"
        android:layout_height="fill_parent"
        android:id="@+id/scrollView">
        <RelativeLayout
            android:layout_width="fill_parent"
            android:layout_height="fill_parent">

            <Spinner
                android:layout_width="140dp"
                android:layout_height="wrap_content"
                android:id="@+id/sp_tiempodeuso"
                android:focusable="true"
                android:layout_below="@+id/txtv_tiempouso"
                android:layout_alignParentLeft="true"
                android:layout_alignParentStart="true" />

            <TextView
                android:layout_width="140dp"
                android:layout_height="30dp"
                android:text="Tiempo de uso:"
                android:textColor="#000000"
                android:textSize="20sp"
                android:id="@+id/txtv_tiempouso"
                android:layout_alignTop="@+id/txtv_docente" />

            <EditText
                android:layout_width="match_parent"
                android:layout_height="wrap_content"
                android:inputType="time"
                android:ems="10"
                android:hint="Hora de Inicio"
                android:textColorHint="#424242"
                android:id="@+id/txt_horainicio"
                android:imeOptions="actionNext"
                android:layout_below="@+id/txt_fechadeuso"
                android:layout_alignParentLeft="true"
                android:layout_alignParentStart="true"
                android:layout_marginTop="18dp" />

            <EditText
                android:layout_width="match_parent"
                android:layout_height="wrap_content"
                android:inputType="none"
                android:descendantFocusability="blocksDescendants"
                android:ems="10"
                android:hint="Fecha de uso"
                android:textColorHint="#424242"
                android:nextFocusDown="@+id/txt_horainicio"
                android:id="@+id/txt_fechadeuso"
                android:imeOptions="actionNext"
                android:layout_below="@+id/txt_practica"
                android:layout_alignParentRight="true"
                android:layout_alignParentEnd="true"
                android:layout_marginTop="16dp"
                android:onClick="mostrarCalendario" />

            <Spinner
                android:layout_width="140dp"
                android:layout_height="wrap_content"
                android:id="@+id/sp_docente"
                android:focusable="true"
                android:focusableInTouchMode="true"
                android:layout_alignBaseline="@+id/sp_tiempodeuso"
                android:layout_alignBottom="@+id/sp_tiempodeuso"
                android:layout_alignParentRight="true"
                android:layout_alignParentEnd="true" />

            <TextView
                android:layout_width="130dp"
                android:layout_height="30dp"
                android:text="Docente:"
                android:textColor="#000000"
                android:id="@+id/txtv_docente"
                android:textSize="20sp"
                android:layout_marginTop="31dp"
                android:layout_below="@+id/txt_horainicio"
                android:layout_alignParentRight="true"
                android:layout_alignParentEnd="true" />

            <EditText
                android:layout_width="match_parent"
                android:layout_height="wrap_content"
                android:inputType="textPersonName"
                android:ems="10"
                android:id="@+id/txt_practica"
                android:hint="Practica"
                android:textColorHint="#424242"
                android:layout_marginTop="9dp"
                android:layout_alignParentLeft="true"
                android:layout_alignParentStart="true" />

            <Button
                android:layout_width="match_parent"
                android:layout_height="fill_parent"
                android:text="Siguiente"
                android:textSize="20sp"
                android:id="@+id/btn_form1"
                android:layout_below="@+id/sp_tiempodeuso"
                android:layout_alignParentLeft="true"
                android:layout_alignParentStart="true"
                android:layout_marginTop="41dp"/>

        </RelativeLayout>

    </ScrollView>


</RelativeLayout>

My JSONParser class

public class JSONParser {

    static InputStream is = null;
    static JSONObject jObj = null;
    static String json = "";

    public JSONParser(){
    }

    public JSONObject getJSONFromUrl(final String url){

        try {
            DefaultHttpClient httpClient = new DefaultHttpClient();

            HttpPost httpPost = new HttpPost(url);

            HttpResponse httpResponse = httpClient.execute(httpPost);

            HttpEntity httpEntity = httpResponse.getEntity();

            is = httpEntity.getContent();
        }catch (UnsupportedEncodingException e){
            e.printStackTrace();
        }catch (ClientProtocolException e){
            e.printStackTrace();
        }catch (IOException e){
            e.printStackTrace();
        }

        try {
            BufferedReader reader = new BufferedReader(new InputStreamReader(
                    is, "iso-8859-1"), 8);

            StringBuilder sb = new StringBuilder();

            String line = null;

            while ((line = reader.readLine()) != null){
                sb.append(line+"\n");
            }
            is.close();

            json = sb.toString();
        }catch (Exception e){
            Log.e("JSON Parser", "Error parsing data " + e.toString());
        }
        return jObj;
    }


    public JSONObject makeHttpRequest(String url, String method,
                                      List params){

        try{
            if(method == "POST"){
                DefaultHttpClient httpClient = new DefaultHttpClient();
                HttpPost httpPost = new HttpPost(url);
                httpPost.setEntity(new UrlEncodedFormEntity(params));

                HttpResponse httpResponse = httpClient.execute(httpPost);
                HttpEntity httpEntity = httpResponse.getEntity();
                is = httpEntity.getContent();
            }else if(method == "GET"){

                DefaultHttpClient httpClient = new DefaultHttpClient();
                String paramString = URLEncodedUtils.format(params,"utf-8");
                url += "?" + paramString;
                HttpGet httpGet = new HttpGet(url);

                HttpResponse httpResponse = httpClient.execute(httpGet);
                HttpEntity httpEntity = httpResponse.getEntity();
                is = httpEntity.getContent();
            }
        }catch (UnsupportedEncodingException e){
            e.printStackTrace();
        }catch (ClientProtocolException e){
            e.printStackTrace();
        }catch (IOException e){
            e.printStackTrace();
        }

        try{
            BufferedReader reader = new BufferedReader(new InputStreamReader(
                    is, "iso-8859-1"), 8);
            StringBuilder sb = new StringBuilder();
            String line = null;

            while ((line = reader.readLine()) != null){
                sb.append(line + "\n");
            }
            is.close();
            json = sb.toString();
        }catch (Exception e){
            Log.e("Buffer Error","Error converting result"+e.toString());
        }

        try{
            jObj = new JSONObject(json);
        }catch (JSONException e){
            Log.e("JSON Parser", "Error parsing data " + e.toString());
        }
        return jObj;
    }
}

And my MainActivity

public class MainActivity extends AppCompatActivity implements View.OnClickListener{

    private EditText practica, fechauso, horainicio;
    private Button botonform1;
    Spinner n_docentes, t_uso;
    private int anio, dia, mes, hora, minuto;
    private static final int TIPO_DIALOGO=0;
    private static DatePickerDialog.OnDateSetListener oyenteSelectorFecha;

    private ProgressDialog pDialog;

    JSONParser jsonParser = new JSONParser();

    private static final String REGISTER_URL = "http://wservervv.esy.es/laboratorio/guardar_solicitud.php";

    private static final String TAG_SUCCESS = "success";
    private static final String TAG_MESSAGE = "message";

    @Override
    protected void onCreate(Bundle savedInstanceState) {
            super.onCreate(savedInstanceState);
            setContentView(R.layout.activity_main);

            practica = (EditText)findViewById(R.id.txt_practica);
            fechauso = (EditText)findViewById(R.id.txt_fechadeuso);
            horainicio = (EditText)findViewById(R.id.txt_horainicio);
    //        t_uso = (Spinner)findViewById(R.id.sp_tiempodeuso);
    //        n_docentes = (Spinner)findViewById(R.id.sp_docente);
            botonform1 = (Button)findViewById(R.id.btn_form1);
            botonform1.setOnClickListener(this);

        fechauso.setInputType(InputType.TYPE_NULL);

        ArrayAdapter adapter_d = ArrayAdapter.createFromResource(this, R.array.Nombres_Docentes, R.layout.spiner_item_lab);
        n_docentes.setAdapter(adapter_d);
        ArrayAdapter adapter_t = ArrayAdapter.createFromResource(this, R.array.Tiempo_Uso, R.layout.spiner_item_lab);
        t_uso.setAdapter(adapter_t);

        Calendar calendario = Calendar.getInstance();
        anio = calendario.get(Calendar.YEAR);mes = calendario.get(Calendar.MONTH);dia = calendario.get(Calendar.DAY_OF_MONTH);

        oyenteSelectorFecha = new DatePickerDialog.OnDateSetListener() {
            @Override
            public void onDateSet(DatePicker view, int year, int monthOfYear, int dayOfMonth) {
                anio = year;mes = monthOfYear;dia = dayOfMonth;mostrarFecha();
           /*     try {
                    Thread.sleep (5000);
                } catch (Exception e) {
                // Mensaje en caso de que falle
                }   */
                horainicio.requestFocus();
            }
        };

        fechauso.setOnFocusChangeListener(new View.OnFocusChangeListener() {

            public void onFocusChange(View v, boolean hasFocus) {
                //Si tiene el Foco esconde el teclado y muestra el datePicker
                if(hasFocus){
                    closeSoftKeyBoard();mostrarCalendario(fechauso);
                }
            }
        });

        horainicio.setOnFocusChangeListener(new View.OnFocusChangeListener() {

            public void onFocusChange(View v, boolean hasFocus) {
                //Si tiene el Foco Esconde el teclado y muestra el timePicker
                if(hasFocus){
                    closeSoftKeyBoard();
                    mostrarTime();
                }
            }
        });
            }


    @Override
    public void onClick(View args0) {
        if(args0 == horainicio){
            closeSoftKeyBoard();
            mostrarTime();
        }
        if(args0 == botonform1) {
            String practicaa = practica.getText().toString();
            String fechausoo = fechauso.getText().toString();
            String horainicioo = horainicio.getText().toString();
            //        String t_usoo = t_uso.getText().toString();
            //        String n_docentess = n_docentes.getText().toString();
            new CreateUser().execute(practicaa, fechausoo, horainicioo);
         }
        }

    class CreateUser extends AsyncTask<String, String, String> {

        protected void onPreExecute(){
            super.onPreExecute();
            pDialog = new ProgressDialog(MainActivity.this);
            pDialog.setMessage("Guardando.....");
            pDialog.setIndeterminate(false);
            pDialog.setCancelable(true);
            pDialog.show();
        }

        @Override
        protected String doInBackground(String... args) {
            // Todo Auto-generated method stub
            // Check for success tag
            int success;
            String practicaa = args[0];
            String fechausoo = args[1];
            String horainicioo = args[2];
//            String t_usoo = args[3];
//            String n_docentess = args[4];

            try{
                List params = new ArrayList();
                params.add(new BasicNameValuePair("practica", practicaa));
                params.add(new BasicNameValuePair("fecha_prestamo", fechausoo));
                params.add(new BasicNameValuePair("hora_prestamo", horainicioo));
//                params.add(new BasicNameValuePair("horas_uso", t_usoo));
//                params.add(new BasicNameValuePair("idusuario", n_docentess));

                Log.d("request!", "starting");

                JSONObject json = jsonParser.makeHttpRequest(
                        REGISTER_URL, "POST", params);

                Log.d("Registering attempt", json.toString());

                success = json.getInt(TAG_SUCCESS);
                if(success == 1){
                    Log.d("User Created!", json.toString());
                    finish();
                    return json.getString(TAG_MESSAGE);
                }else{
                    Log.d("Registering Failure!", json.getString(TAG_MESSAGE));
                    return json.getString(TAG_MESSAGE);
                }
            }catch (JSONException e){
                e.printStackTrace();
            }
            Toast.makeText(getApplicationContext(),"Usuario guardado con exito... ",Toast.LENGTH_LONG).show();
            return null;
        }

        protected void onPostExecute(String file_url){

            pDialog.dismiss();
            if (file_url != null){
                Toast.makeText(MainActivity.this, file_url, Toast.LENGTH_LONG).show();
            }
        }

    }

    public void mostrarTime(){
        // Get Current Time
        final Calendar c = Calendar.getInstance();
        hora = c.get(Calendar.HOUR);
        minuto = c.get(Calendar.MINUTE);

        TimePickerDialog timePickerDialog = new TimePickerDialog(this,
                new TimePickerDialog.OnTimeSetListener() {

                    @Override
                    public void onTimeSet(TimePicker view, int hourOfDay,
                                          int minute) {

                        horainicio.setText(hourOfDay + ":" + minute+":00");
                     //   t_uso.requestFocus();
                    }
                }, hora, minuto, false);
        timePickerDialog.show();
    }

    public void closeSoftKeyBoard() {
        InputMethodManager inputMethodManager = (InputMethodManager)getSystemService(Context.INPUT_METHOD_SERVICE);
        inputMethodManager.hideSoftInputFromWindow(getCurrentFocus().getWindowToken(), 0);
    }

    @Override
    protected Dialog onCreateDialog(int id) {
        switch (id){
            case 0:
                return new DatePickerDialog(this, oyenteSelectorFecha, anio, mes, dia);
        }
        return null;
    }

    public void mostrarCalendario(View control){
        showDialog(TIPO_DIALOGO);
    }

    public void mostrarFecha(){
        fechauso.setText(anio+"-"+(mes+1)+"-"+dia);
    }
}

The strings.xml

<resources>
    <string name="app_name">Guardar_A</string>

    <!-- Spinner docentes  -->
    <string-array name="Nombres_Docentes">
        <item>Seleccione</item>
        <item>Juan</item>
        <item>Pedro</item>
        <item>Jose</item>
    </string-array>

    <!-- Spinner tiempo de uso  -->
    <string-array name="Tiempo_Uso">
        <item>Seleccione</item>
        <item>1 Hora</item>
        <item>2 Horas</item>
        <item>3 Horas</item>
    </string-array>

</resources>

My loan table :

my php files:

db_config.php

<?php
define('DB_USER',"u557976579_swgvv");
define('DB_PASSWORD',"guardar_a");
define('DB_DATABASE',"u557976579_bdser");
define('DB_SERVER',"mysql.hostinger.mx");
?>

db_connect.php

<?php

class DB_CONNECT {

    function __construct(){
        $this->connect();
    }

    function __destruct(){
        $this->close();
    }


    function connect(){

    require_once __DIR__ . '/db_config.php';

    $con = @mysql_connect(DB_SERVER, DB_USER, DB_PASSWORD) or die(mysql_error());

    $db = @mysql_select_db(DB_DATABASE) or die(mysql_error()) or die(mysql_error());

    return $con;
    }

    function close(){

        mysql_close();
    }

  }
?>

save_request.php

guardar_solicitud.php
<?php

$response = array();

//if (isset($_POST['idusario']) && isset($_POST['fecha_prestamo']) && isset($_POST['hora_prestamo']) && isset($_POST['horas_uso']) && isset($_POST['practica']) && isset($_POST['idusuariosolicitud'])){
if (isset($_POST['fecha_prestamo']) && isset($_POST['hora_prestamo']) && isset($_POST['practica'])){
    $nombredocente = 4;
    $fechauso = $_POST['fechauso'];
    $horainicio = $_POST['horainicio'];
    $timeuso = 1;
    $practica = $_POST['practica'];
    $usuariosolicitud=1;

    require_once __DIR__ . '/db_connect.php';

    $db = new DB_CONNECT();

    $result = mysql_query("INSERT INTO prestamo(idusuario,fecha_prestamo,hora_prestamo,horas_uso,practica,idusuariosolicitud) VALUES('$nombredocente', '$fechauso', '$horainicio', '$timeuso','$practica', '$usuarioquesolicita')");

    if ($result){

        $response["success"] = 1;
        $response["message"] = "Product successfully created.";

        echo json_encode($response);
    }else{

        $response["success"] = 0;
        $response["message"] = "Oops! An error ocurred.";       

        echo json_encode($response);
    }
}else{

        $response["success"] = 0;
        $response["message"] = "Required field(s) is missing";      

        echo json_encode($response);

}

?>

That's what I have so far

It happens that I have an Edit Text of type textPersonName and when I pass the focus to another Edit Text of type date it shows me the virtual keyboard but I want it not to show it to me, since instead I want a dialog containing a DatePicker (which I already have)

This question has already been asked and the solution I read is:

TuEditText.setInputType(InputType.TYPE_NULL); 

and in the xml:

android:inputType="none"

but this only removes the focus and I have to click on the EditText to show the DatePicker dialog and I want it to keep the focus but not show the virtual keyboard and show my DatePicker dialog

Another solution I saw is to remove the focus from the EditText date with the following code:

android:focusable="false"

but this is not what I intend to do since when I remove the focus I must click on the EditText to show the DatePicker dialog I repeat I intend to keep the focus but not show the virtual keyboard and show my DatePicker dialog

Here is the xml code:

<?xml version="1.0" encoding="utf-8"?>
<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:tools="http://schemas.android.com/tools"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    android:paddingBottom="@dimen/activity_vertical_margin"
    android:paddingLeft="@dimen/activity_horizontal_margin"
    android:paddingRight="@dimen/activity_horizontal_margin"
    android:paddingTop="@dimen/activity_vertical_margin">

 <EditText
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:inputType="textPersonName"
        android:ems="10"
        android:id="@+id/txt_practica"
        android:hint="Practica"
        android:layout_marginTop="9dp"
        android:layout_alignParentLeft="true"
        android:layout_alignParentStart="true" />

<EditText
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:inputType="date"
        android:ems="10"
        android:hint="Fecha de uso"
        android:id="@+id/txt_fechadeuso"
        android:layout_below="@+id/txt_practica"
        android:layout_alignParentRight="true"
        android:layout_alignParentEnd="true"
        android:layout_marginTop="16dp"
        android:onClick="mostrarCalendario" />

</RelativeLayout>