问用mysql和php将会话中的用户名记录到表中

EN

$username = $_SESSION['username']

//connect to db

INSERT INTO table_name
VALUES (value1, value2, $username) 

//close db connection

<?php
//When user logged-in
$_SESSION['user_id']=logged_in_user_id;

//When you need to insert
$userId = $_SESSION['user_id'];

<?php

session_start();

// On the page your login form submits to

// Your authentication code is here make sure it is returning the USER ID if there is one

$_SESSION['username'] = $result->username; // use this for user name

$_SESSION['userid'] = $result->userid; // use this for user ID
?>

<?php
    session_start();
    // Page that adds records
    $sql = "INSERT INTO table_name VALUES (value1, value2, value3, $_SESSION['username'], $_SESSION['userid']);
// I would rather see you use the user_id than the user name but you get the idea
?>