test/index.php at main · mhrzashova/test · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
<?php
if(isset($_POST['login'])) // isset is click, submit vako ho ki haina check garxa
{
    // login click gareko xa vane k kam garne define gareko
    $email=$_POST['email']; //name collect garne variable
    $password=md5($_POST['password']); //password collect garne variable
    //echo ($email." and ".$password."<br>"); //display of variable

    // Connection ko variable
    $connection = new mysqli("localhost","root","", "admin");
    // Checking Database Connection
    if($connection->connect_errno!=0)
    //0 means connected
    {
        die("Database Connectivity Error");
    }

    // comparison query using select
    $sql="SELECT * FROM admin WHERE email='$email' AND password='$password'";
    $result=$connection->query($sql); //query execution
    if($result->num_rows>0) //data match vako xa vane
    {
        //echo("Success");
        session_start();
        //table ma vako data extract gareko
        $row = $result->fetch_assoc();
        //tes lai $_session ma store gareko
        $_SESSION['admin']=$row;

        //redirecting to dashboard page after login is successful with session
        header("Location:dashboard.php");

    }
    //data match vako xaina vane
    else
    {
      echo
        ("
          <script>
          alert(' Wrong Email Or Password ');
          </script>
        ");
    }

}
?>


<!DOCTYPE html>
<html lang="en">
<head>
  <meta charset="UTF-8">
  <meta name="viewport" content="width=device-width, initial-scale=1.0">
  <title>Admin Login</title>
  <link rel="stylesheet" href="style.css">
  <link rel="stylesheet" href="fontawesome/css/all.min.css"/>
</head>
<body>
  <div class="wrapper">
    <header>Admin Login Form</header>
    <form action="index.php" method="post">
      <div class="field email">
        <div class="input-area">
          <input type="email" name="email" id="email" placeholder="Email Address" value="<?php if(isset($_POST['login'])) {echo $email;} ?>"required/>
          <!-- Yedi email rw Password wrong vayo vane input ma display hos
          type garna naparos feri vanera -->
          <i class="icon fas fa-envelope"></i>
          <i class="error error-icon fas fa-exclamation-circle"></i>
        </div>
        <div class="error error-txt">Email can't be blank</div>
      </div>
      <div class="field password">
        <div class="input-area">
          <input type="password" name="password" id="password" placeholder="Password" required/>
          <i class="icon fas fa-lock"></i>
          <i class="error error-icon fas fa-exclamation-circle"></i>
        </div>
        <div class="error error-txt">Password can't be blank</div>
      </div>
      <input type="submit" name="login" value="Login">
    </form>
  </div>

</body>
</html>