Guest User

Untitled

a guest
Oct 5th, 2018
199
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.68 KB | None | 0 0
  1. <?php
  2. $username = 'root';
  3. $password = '';
  4. $connection = new PDO( 'mysql:host=localhost;dbname=nise', $username, $password );
  5. ?>
  6.  
  7. <?php
  8. include 'usuarios/modelUsuario.php';
  9.  
  10. //se clicou no botão
  11. if (isset($_POST['login'])){
  12.  
  13. $modelo = new ModelUsuario();
  14.  
  15.  
  16. $resultado = $modelo->autenticar( ($_POST['matricula']), ($_POST['senha']) );
  17. if(! empty($resultado) ){
  18. // redirecionar para index2
  19. header("location: http://localhost/projeto/aluno.php");
  20. }
  21.  
  22. }
  23.  
  24. ?>
  25.  
  26. <?php
  27. include 'usuarios/usuario.php';
  28.  
  29. class ModelUsuario{
  30.  
  31. public function adicionar(){
  32. include 'usuarios/bd.php';
  33.  
  34. $query = "INSERT INTO usuarios (matricula, senha)
  35. VALUES (:matricula, :senha)";
  36.  
  37. $statement = $connection->prepare($query);
  38.  
  39. $valores = array();
  40. $valores[':matricula'] = $usuario->getMatricula();
  41. $valores[':senha'] = $usuario->getSenha();
  42.  
  43.  
  44. $result = $statement->execute($valores);
  45.  
  46.  
  47. }
  48.  
  49. public function editar(){
  50.  
  51. }
  52.  
  53. public function remover(){
  54.  
  55. }
  56.  
  57.  
  58. public function autenticar($matricula, $senha){
  59. include 'usuarios/bd.php';
  60.  
  61.  
  62. $query = "SELECT nome, id FROM usuario WHERE matricula=:matricula and senha=:senha";
  63.  
  64.  
  65. $statement = $connection->prepare($query);
  66.  
  67. $valores = array();
  68. $valores[':matricula'] = $matricula;
  69. $valores[':senha'] = $senha;
  70.  
  71.  
  72. $result = $statement->execute($valores);
  73.  
  74.  
  75. $result = $statement->fetchAll();
  76.  
  77.  
  78.  
  79. return $result;
  80.  
  81. }
  82.  
  83.  
  84.  
  85.  
  86. }
  87.  
  88. ?>
  89.  
  90. <form method="POST" action ="login.php" name="for">
  91. <div class="form-group">
  92. <div class="form-label-group">
  93. <input type="text" id="inputEmail" name="matricula" class="form-control" placeholder="Email address" required="required" autofocus="autofocus">
  94. <label for="inputEmail">Matrícula</label>
  95. </div>
  96. </div>
  97. <div class="form-group">
  98. <div class="form-label-group">
  99. <input type="password" id="inputPassword" name="senha" class="form-control" placeholder="Password" required="required">
  100. <label for="inputPassword">Senha</label>
  101. </div>
  102. </div>
  103. <div class="form-group">
  104. <div class="checkbox">
  105. <label>
  106. <input type="checkbox" value="remember-me">
  107. Lembrar senha
  108. </label>
  109. </div>
  110. </div>
  111. <button type="submit" class="btn btn-primary btn-block" href="aluno.php" name="login">Login</button>
  112. <a href="registro.php" id="cadastro" class="d-block small mt-3">Cadastrar</a>
  113. </form>
Add Comment
Please, Sign In to add comment