Sergio Romero's questions

Why does MySQL allow text to be inserted into an integer(INT) field?

For example, I have this:

INSERT INTO `estudiante` (`usuarioID`, `identidad`, `correo`, `institucion`)
               VALUES ("32", 'xxx', '[email protected]', 'exterior')

the second field is identity which is integer because it doesn't give me an error when inserting a text

What am I doing wrong? it's supposed to be an int it shouldn't allow text, it converts it to zero

Here is the table layout:

    CREATE TABLE `estudiante` (
    `usuarioID` INT(11) NOT NULL,
    `identidad` INT(20) NOT NULL,
    `correo` VARCHAR(40) NOT NULL,
    `institucion` VARCHAR(80) NOT NULL,
    PRIMARY KEY (`usuarioID`)
)

I have a problem with react js and with setState in the documentation it says that it is asynchronous. And the problem I have is that I am using a Select and depending on the value that I select, it makes the request with ajax to the database, but since it is asynchronous, the value is not sent when clicking on an option the first time, but until the next. click on any option.

How do I send the updated value? I've seen that setState can take a second argument which is a callBack but I'm not sure how to update the value.

       class HttpPeticion extends React.Component{
  constructor(props){
   super(props);
   this.state={lista:[],
              showData:false,showNodata:false,
              cantidadResultados:'',
              errorTipo:'',errorBool:false
            };
    }

 handlerData(data){

   if (typeof data=="undefined") return 0;

  let errorTipo=data.tipo;
  let errorBool=data.error;

  if(errorBool){
     this.setState({errorBool:data.error})
     this.setState({errorTipo:data.tipo})
  }
  else{
    let recordSize= data.records.length;
      if(recordSize<= 0) {
         this.setState({showData:false})//ocular resultados
         this.setState({showNodata:true})//muestra "no hay datos"
       }else{
        this.setState({showData:true});//mostrar resultados
        this.setState({showNodata:false})//ocultar "no hay datas"
        this.setState({lista:data.records});
      }
    this.setState({cantidadResultados:recordSize + ' Coincidencias' });
 }

 }


    componentWillReceiveProps(){
    axios.post(this.props.urlServer,{'tipo':this.props.tipo,'nombre':this.props.nombre})
      .then(res => {
         this.handlerData(res.data.data);
      })
      .catch(function (error) {
         console.log(error);
      });
}


render(){
  return (
      <div>
         <div>{this.state.cantidadResultados}  </div>
         <div className={this.state.showData ? '': 'hidden' }>
            <ResultadoBusqueda datos={this.state.lista} />
          </div>

           <div className={this.state.showNodata ? '' : 'hidden'}>
             <h1>No hay ningun resultado </h1>
           </div>

           <div className={this.state.errorBool ? '':'hidden'}>
                <p>Un error ha ocurrido conectado con el ser servidor intente refresar la pagina(f5), si el problema
                     persiste contacte con el administrador.<a href="#">Mas informacion</a>  </p>
                <small>{this.state.errorTipo}</small>
           </div>
      </div>
  );
}
}

class ResultadoBusqueda extends React.Component{
    render(){
       return(
           <table>
              <thead>
                 <tr>
                  <th>Cuenta</th>
                  <th>Nombre</th>
                  <th>Precio</th>
                 </tr>
               </thead>
             <tbody>
            {
                 this.props.datos.map((item)=>{
                    return(
                       <tr key={item.cuenta.toString()}>
                       <td>{item.cuenta} </td>
                       <td>{item.nombre}</td>
                       </tr>
                    )
                 })
                }
            </tbody>
            </table>
      );
    }

}

class BusquedaAlumno extends React.Component {
setField (e) {
   //this.checkInput(e.target.value);
  this.setState({[e.target.name]: e.target.value})
}

render() {
   return (
      <div>

      <input type="text"
        onChange={(e)=>this.setField(e)}
        onKeyUp={(e)=>this.setField(e)}
        name="valor1"
       />
       <select onChange={(e)=>this.setField(e)} value={this.state.value} name="combo">
        <option value="-1">Selecciones</option>
         <option value="1">1</option>
         <option value="0">0</option>
       </select>

             <div>{this.state.valor1}</div>
              <div>{this.state.combo}</div>
         <HttpPeticion tipo={this.state.combo} nombre={this.state.valor1} urlServer={"http://localhost/viaLacteaQueryBusquedaId.php"} />
       </div>
    );
  }

If it shows me the data but it has that little inconvenience with the select and the textbox

help in React js with ecmaScript 2015 how to call a method inside the render(){} method I get an error Cannot read property 'ss' of undefined(… where is the error ?? I can't call the ss function that I made inside the method render() :(

import React from 'react'

      class Saludo extends React.Component {
        constructor(){
         super();
         this.state={lista:[]};
        }


        componentWillMount() {
            fetch('http://localhost/viaLacteaQuery.php')
              .then((response) => {
                return response.json();
              })
              .then((data) => {
                   this.setState({lista:data.data.records});
              })
          }


         ss(){
          return  Math.random();
        }


        render() {
            return (
              <div>
                <h1>Saluditos!!</h1>

                {
                  this.state.lista.map(function(item) {
                    <ul>
                     return (
                       <ul>
                       <li key={this.ss()}>{item.nombre}</li>
                       <li key={this.ss()}>{item.cuenta}</li>
                       <li key={this.ss()}>{item.precio}</li>
                       </ul>
                     )
                  </ul>
                  })

                }

              </div>


          )
        }
      }

      export default Saludo;

Without the function it works fine for me.

I have a question with Angular 2 and typeScript

I have an interface like this:

export interface DataForm{
  cuenta:string;
  nombre:string;
}

Then I have a function like this:

public  datas(x:DataForm){
  console.log(x);
}

And I have a variable and I obj:number=20; pass it as a parameter to the function I made:

this.datas(this.obj);

In the console it returns 20.

Not being the same type is not supposed to show an error. My question is how do I check that the parameter I receive is equal to the indicated type of the function.

That function would actually receive the fields of a form with those fields, but that question arose, how do I show an error if they are not the same type. In the editor if it marks the error but when compiling it does not show any error. I think that making a type of would be the solution, only I am left wondering why it does not throw an error when compiling.

If Angular 2using typescripthow do I transpile my project to ecmascript 5? I am using angular clithat generates a folder structure for me I have seen that there is a dist folder that is generated with the ng build command but I want to upload the project to a host but I am confused I have heard of webPackit but I am still in doubt, should I use angular cliorwebPACK

What is the way to transpile to ecmascript5?

How do I highlight an area of ​​a country with leafletjs? The only way I have seen is using a Geojson file. I have used mapzen and it works, but there is another way to do it this way. The problem I have is that the geojson files are very heavy (up to 15mg) and I I am concerned about the performance of the application, in the application that I am doing it is on a map of my country; there are 18 departments

Here I give you an example, this is what I am looking for http://nominatim.openstreetmap.org/search.php?q=cortes+honduras&polygon=1&viewbox=

I am making an application of a map of my country; I live in Honduras, which is divided into departments, and each department into municipalities.

I have seen that with Google Maps the limits between each department are drawn, but it does not show in the department, it does not show its division into municipalities.

Here's an example of the result I want:

As you can see, everything in color are apartments; each distinct color with its name is a municipality.

Is it possible to do that division with Google Maps?

I'm new to angular 2,I used angular 1x a bit for a college project.

My question is with angular 2, can you bring information from the database?

For example of a database in MySQL but my question is how. In angular 1 I made a script in php that made a query to the database but in angularjs-2.0 it is the same? How do I get information from the database?

Almost all the examples I've seen use @angular/httpwith the method .get(<la url>) but use a file .jsoninstead of records from a table.

I've thought about putting a file .phpin the folder of a component that queries the server, but I'm not entirely sure why I do http.get(<la url>) n't know how to put the address in the method in the url. I have tried with a .jsonand everything is fine but to bring data from the server I have doubts.