Breaking News: Grepper is joining You.com. Read the official announcement!

how to insert a table on user login

Thoughtful Trout answered on September 15, 2023 Popularity 1/10 Helpfulness 1/10

answer how to insert a table on user login

how to insert a table on user login

Comment

$database->query("
    CREATE TABLE `users_sessions` (
        `session_id` int(10) UNSIGNED NOT NULL,
        `session_date` datetime NOT NULL,
        `user_id` int(10) UNSIGNED NOT NULL,
        `user_browser` varchar(64) COLLATE utf8mb4_bin NOT NULL,
        `user_os` varchar(64) COLLATE utf8mb4_bin NOT NULL,
        `user_ip` varchar(64) COLLATE utf8mb4_bin NOT NULL,
         PRIMARY KEY (`session_id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
");

Popularity 1/10 Helpfulness 1/10 Language sql

Source: stackoverflow.com

Tags: insert sql

Link to this answer
Share Copy Link