What potential security risks are associated with storing user data, such as IP addresses, in a .txt file?

Storing user data, such as IP addresses, in a .txt file can pose security risks if the file is not properly secured. If the file is accessible to unauthorized users, it can lead to data breaches or unauthorized access to sensitive information. To mitigate this risk, it is important to store user data in a secure location with restricted access controls, such as a database.

<?php
// Store user IP address in a secure database instead of a .txt file
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "user_data";

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

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

// Get user IP address
$user_ip = $_SERVER['REMOTE_ADDR'];

// Insert user IP address into database
$sql = "INSERT INTO user_ips (ip_address) VALUES ('$user_ip')";

if ($conn->query($sql) === TRUE) {
    echo "User IP address stored successfully";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

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