How can PHP code be optimized to efficiently track and report user logins and posts?

To efficiently track and report user logins and posts in PHP, you can optimize the code by using a database to store user login information and post data. This way, you can easily query the database to retrieve the necessary information for reporting purposes. Additionally, you can use sessions to track user logins and store relevant data for each session. 

// Database connection
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";

$conn = new mysqli($servername, $username, $password, $dbname);

// Track user login
session_start();

if(isset($_SESSION['user_id'])){
    // User is logged in, track login
    $user_id = $_SESSION['user_id'];
    
    $login_time = date('Y-m-d H:i:s');
    
    $sql = "INSERT INTO user_logins (user_id, login_time) VALUES ('$user_id', '$login_time')";
    
    $conn->query($sql);
}

// Track user post
if(isset($_SESSION['user_id'])){
    // User is logged in, track post
    $user_id = $_SESSION['user_id'];
    $post_content = "Sample post content";
    
    $sql = "INSERT INTO user_posts (user_id, post_content) VALUES ('$user_id', '$post_content')";
    
    $conn->query($sql);
}

// Close database connection
$conn->close();

Keywords

PHP optimization user logins tracking reporting

Related Questions