Login pagina (login.php)

Gesponsorde koppelingen

PHP script bestanden

  1. Login pagina (login.php)
  2. MySQL
  3. Default pagina (index.php)
  4. Connectie pagina (conn.php)
  5. Check pagina (check.php)

« Lees de omschrijving en reacties

Code (php)
PHP script in nieuw venster Selecteer het PHP script
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
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
<?php
session_start();

include 'conn.php';

    if($_SERVER['REQUEST_METHOD'] == 'POST')
    {


        $login_user = $Mysqli->real_escape_string($_POST['gebruikersnaam']);
        $login_pass = $Mysqli->real_escape_string(sha1($_POST['wachtwoord']));
        $user_ip = $_SERVER['REMOTE_ADDR'];
        srand ((double) microtime( )*1000000);
        $session_id = rand(1000,1000000);
 
        $q1 = "
        SELECT
            id,
            username,
            block
        FROM
            users
        WHERE
            username = '"
.$login_user."'  
        AND
            password = '"
.$login_pass."'
        "
;

            if(!$r1 = $Mysqli->query($q1))
        {

        
            echo 'Er is een fout opgetreden!. '. $Mysqli->error;
        
        }

                                        
                                
                elseif($Mysqli->affected_rows == 1)
                {

    

                                while ($row = $r1->fetch_assoc ())
                                {

                                
                                        $_SESSION["username"] = $row['username'];
                                        $_SESSION['user_id'] = $row['id'];  
                                        $_SESSION['user_ip'] = $user_ip;
                                        $_SESSION['session_id'] = $session_id;
                                              
                                    if ($row['block'] == 1)
                                    {

                                        echo 'Je bent geblokkeerd, je kunt niet meer inloggen!';
                                    }

                                        else
                                        {
                                            //Inloggen gelukt!!
                                            header("location: " . 'index.php?msg=succes');
                                        }


                                
    
    
                    $q2 = "
                    INSERT INTO
                        sessions
                    (
                        user_id,
                        session_id,
                        user_ip
                    )
                    VALUES
                    (
                        '"
.$row['id']."',
                        '"
.$session_id."',
                        '"
.$user_ip."'
                    )
                    "
;
                                }


                                    if (!$Mysqli->query ($q2) )
                                    {

                                    
                                        echo 'Er is een fout opgetreden!'. $Mysqli->error;
                                    
                                    }
                                



                }

                    else
                    {  
                        echo 'Gebruikersnaam of wachtwoord onjuist, probeer het opnieuw!';
                    }  
          
    }

        else
        {
            ?>

                <html>
                <head>
                <title>Login</title>
                </head>
                <body>
                <h2>Login</h2>
                
                <?php
                    if(isset($_GET['error']))
                    {

                        if($_GET['error'] == 'sess')
                        {

                            echo 'De sessie is ongeldig! Log aub opnieuw in!<p>';
                        }
                    }

                ?>

                    <form method='post'>  
                                <table>  
                                    <tr>  
                                        <td>Gebruikersnaam:</td>  
                                        <td><input type='text' name='gebruikersnaam'></td>  
                                    </tr>  
                                    <tr>  
                                        <td>Wachtwoord:</td>  
                                        <td><input type='password' name='wachtwoord'></td>  
                                    </tr>  
                                    <tr>  
                                        <td><input type='submit' name='submit' value='Login'></td>  
                                    </tr>  
                                </table>  
                    </form>
                      
                </body>
                </html>          
        <?php
        }  
        ?>

 
 

Om de gebruiksvriendelijkheid van onze website en diensten te optimaliseren maken wij gebruik van cookies. Deze cookies gebruiken wij voor functionaliteiten, analytische gegevens en marketing doeleinden. U vindt meer informatie in onze privacy statement.