PepijnVDK
/
Database


			
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869
							<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="UTF-8" />
    <meta name="viewport" content="width=device-width, initial-scale=1.0" />
    <title>Document</title>
</head>

<body>
    <?php 
        $db = new SQLite3('db_naval_battle.db');

        $sql2 = 'SELECT usr_name FROM users';
        $res = $db->query($sql2);
        
        while ($row = $res->fetchArray(SQLITE3_ASSOC)){
            // var_dump($row);
        }

        // foreach($row as $data){
        //     echo $data . ' ';
        // }


    ?>

    <section id="form">
        <form method="post">
            <label>
                Username
                <input type="text" name="usr-name" required>
            </label><br><br>
            <label>
                Password
                <input type="password" name="password" required>
            </label><br><br>
            <input type="submit" name="submit">
        </form>
    </section><br><br>

    <?php 
    if(isset($_POST['submit'])){
        
        $usrName =  $_POST['usr-name'];
        $pass =  $_POST['password'];

        $sql4 = "SELECT * FROM users WHERE usr_name='" . $usrName ."' AND usr_pwd='" . $pass ."'";
        
        $res3 = $db->query($sql4);   

        if($row = $res3->fetchArray(SQLITE3_ASSOC)){
            echo "Gelukt! Hallo " . $row['usr_name'] . "!<br>";
        }else {
            echo "no such user found<br>";
        }        
    }
 
    $sqlusers = "SELECT * FROM users";
    $res2 = $db->query($sqlusers);
    while ($row = $res2->fetchArray(SQLITE3_ASSOC)){
        echo "<strong>Usrname:</strong> " . $row['usr_name']. " <strong>Password: </strong>" . $row['usr_pwd'] . "<br>";
    }
    ?>
</body>

</html>