/_login_res.php

<?php

              $conexion = new mysqli("mysql.campanaarquidiocesana.com","mgcdb","proyectosaga","campana_saga");

              if($conexion -> connect_error){
                
                die("Error en la conexion!");
                
              }

              else {
                
                
                //echo("Conectado a la base de datos! <br/>");
                
              }
             
              $cedula = $_POST['cedula'];
              $pass = $_POST['pass'];
              $rol = $_POST['rol'];
             
              $sql = "SELECT * FROM laico_comprometido WHERE cedula LIKE '{$cedula}' AND password LIKE '{$pass}' AND rol LIKE '{$Visitador}' LIMIT 1";
              $cedula = $conexion->query("SELECT nombre FROM laico_comprometido WHERE cedula LIKE '{$cedula}' AND password LIKE '{$pass}' LIMIT 1")->fetch_row()[0];
              $result = $conexion->query($sql);
              
              if (!$result->num_rows == 1) {
                
                header('Refresh: 3;url=index.php');
                echo "Cédula o Contraseña inválida, regresando a la pagina principal...";
                session_start();
                $_SESSION['login'] = '';
                
              } 

              else {

                header('Refresh: 3;url=inicio.php');
                echo "Ha ingresado exitosamente! Redirigiendo a la pagina de inicio";
                
                session_start();
                $_SESSION['login'] = $cedula;
                

              }
            

          ?>