How can PHP developers effectively display and manage user-specific content on a website, such as a list of movies in a personal database?

To display and manage user-specific content on a website, such as a list of movies in a personal database, PHP developers can utilize sessions to store user information and query the database for the relevant data based on the user's session ID. 

<?php
session_start();

// Check if user is logged in
if(isset($_SESSION['user_id'])) {
    // Connect to database
    $conn = new mysqli('localhost', 'username', 'password', 'database');

    // Query database for user's movies
    $user_id = $_SESSION['user_id'];
    $query = "SELECT * FROM movies WHERE user_id = $user_id";
    $result = $conn->query($query);

    // Display user's movies
    while($row = $result->fetch_assoc()) {
        echo $row['title'] . "<br>";
    }

    // Close database connection
    $conn->close();
} else {
    echo "Please log in to view your movies.";
}
?>

Keywords

PHP user-specific content database display management

Related Questions