How can you ensure that only the data entered by a specific user is displayed in PHP when retrieving data from a database?

To ensure that only data entered by a specific user is displayed in PHP when retrieving data from a database, you can use a WHERE clause in your SQL query to filter the results based on the user's ID or username. This way, only data associated with that particular user will be fetched from the database. 

<?php

// Assuming $userId contains the ID of the specific user
$userId = 1;

// Connect to the database
$conn = new mysqli("localhost", "username", "password", "database");

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Query to fetch data for a specific user
$sql = "SELECT * FROM your_table_name WHERE user_id = $userId";

$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // Output data of each row
    while($row = $result->fetch_assoc()) {
        echo "Data: " . $row["column_name"] . "<br>";
    }
} else {
    echo "0 results";
}

$conn->close();

?>

Keywords

PHP database user authentication SQL injection data filtering

Related Questions