Untitled

<!DOCTYPE html>
<!--
To change this license header, choose License Headers in Project Properties.
To change this template file, choose Tools | Templates
and open the template in the editor.
-->
    <html lang="en"><head>

        <meta charset="utf-8">
	<title>Login</title>
	<script src="bootstrap/js/jquery.js"></script>
	<link rel="stylesheet" href="bootstrap/css/bootstrap.min.css">
	<link rel="stylesheet" href="bootstrap/css/bootstrap-theme.min.css">
	<script src="bootstrap/js/bootstrap.min.js"></script>

        <meta http-equiv="X-UA-Compatible" content="IE=edge">
        <meta name="viewport" content="width=device-width, initial-scale=1">
        <!-- The above 3 meta tags *must* come first in the head; any other head content must come *after* these tags -->
        <link rel="icon" href="../../favicon.ico">

        <!-- Custom styles for this template -->
        <link href="bootstrap/css/estilos.css" rel="stylesheet">

    </head>

    <body>

      <div class="container" style="margin: 75px auto; width:300px; height:300px;">

        <form class="form-signin" action="#" method="post">
          <h2 class="form-signin-heading">Please Log in</h2>
          <input id="inputEmail" class="form-control marged_inputs" placeholder="User" required="" autofocus="" type="text" name="name_login">
          <input id="inputPassword" class="form-control marged_inputs" placeholder="Password" required="" type="password" name="pass_login">
          <button class="btn btn-lg btn-primary btn-block" type="submit" name="send_login">Log in</button>
        </form>
            <?php
            session_start();
            $login = filter_input(INPUT_POST,"send_login");
            //$conector_bbdd = new mysqli('servidor', 'usuario', 'contraseña','nombre_base_datos');
            $conector_bbdd = new mysqli('localhost', 'root', 'raspberry','user1');
            if(isset($login)){
                $name = filter_input(INPUT_POST,"name_login");
                $pass = filter_input(INPUT_POST,"pass_login");
                $name_seguro = htmlspecialchars($name);
                $pass_segura = htmlspecialchars($pass);
                $pass_segura_cifrada = hash('md5',$pass_segura);
                $consulta = "SELECT user,password FROM login WHERE user ='".$name_seguro."' AND password ='".$pass_segura_cifrada."'";
                $resultado = $conector_bbdd->query($consulta);
                if($resultado->num_rows == 1){
                    $rows = array();
                    while($row = $resultado->fetch_array(MYSQLI_NUM))
                    {
                        $rows[] = $row;
                    }
                    $_SESSION["username"] = $rows[0];
                    header("Location: sensor.php");
                }else{
                    echo '<div class="alert alert-danger" role="alert">El usuario y la contraseña no coinciden</div>';
                }
            }
            $conector_bbdd->close();
          ?>


      </div> <!-- /container -->


      <!-- IE10 viewport hack for Surface/desktop Windows 8 bug -->
      <script src="../../assets/js/ie10-viewport-bug-workaround.js"></script>


  </body>
</html>