What are the best practices for encoding URLs retrieved from a MySQL database before using them in file_get_contents() calls in PHP?

When retrieving URLs from a MySQL database to use in file_get_contents() calls in PHP, it is important to properly encode the URLs to prevent any potential security vulnerabilities such as SQL injection or cross-site scripting attacks. One way to do this is by using the urlencode() function in PHP to encode the URLs before using them in file_get_contents() calls. This will ensure that the URLs are safely encoded and can be safely used in the file_get_contents() function.

// Retrieve URL from MySQL database
$url = "http://example.com/page?param=value";

// Encode the URL using urlencode()
$encoded_url = urlencode($url);

// Use the encoded URL in file_get_contents() call
$content = file_get_contents($encoded_url);

// Output the content
echo $content;