What are the best practices for handling URLs or links retrieved from databases in PHP to avoid issues like broken links or incorrect formatting?

When handling URLs or links retrieved from databases in PHP, it is important to properly sanitize and validate the data to avoid issues like broken links or incorrect formatting. One way to do this is by using PHP's built-in filter_var() function with the FILTER_VALIDATE_URL filter to ensure that the URL is valid. Additionally, you can use functions like htmlspecialchars() to escape special characters and prevent XSS attacks. 

// Example code snippet to handle URLs retrieved from a database
$url = $row['url']; // Assume $row is the result from a database query

// Validate the URL
if (filter_var($url, FILTER_VALIDATE_URL)) {
    // URL is valid, do something with it
    echo '<a href="' . htmlspecialchars($url) . '">Link</a>';
} else {
    // URL is not valid, handle error
    echo 'Invalid URL';
}

Keywords

URL validation database retrieval link formatting error handling PHP functions

Related Questions