为什么我的PHP没有插入数据库？

I have made a simple login to the main webpage. If the user login is successful the username, nickname, and date are supposed to be inserted into the database "userdata" why is this not the case? I don't get any errors, but my database does not update and remains empty.

php:

<?php
error_reporting(E_ALL & ~E_NOTICE);
session_start();

if($_POST['submit']) {
    $username = strip_tags($_POST['username']);
    $password = strip_tags($_POST['password']);

    $sql = "SELECT id, username, password, nickname FROM users WHERE username = '$username' AND activated = '1' LIMIT 1";
    $connect = mysqli_connect("", "", "", "root_root"); 
    $query = mysqli_query($connect, $sql);

    if ($query) {
        $row = mysqli_fetch_row($query);
        $userId = $row[0];
        $dbUsername = $row[1];
        $dbPassword = $row[2];
        $userLabel = $row[3];
    }


    if ($username == $dbUsername && $password == $dbPassword) {
        $_SESSION['username'] = $username;
        $_SESSION['id'] = $userId;
        $_SESSION['nickname'] = $userLabel;
        $date = date('m/d/y | H:i:s');

        if ($dbPassword == "password") {
            header('Location: firstlogin.php');
        }

        else
        mysqli_query($connect, "INSERT INTO userdata (username, name, timein) VALUES ('$username', '$userLabel', '$date')");
        header('Location: main.php');
        } 
    else {
        $error = "Error: Invalid username or password.";
    }
}
?>