Vanity URL

A quick tutorial for creating vanity URLs using PHP, .htaccess and MySQL.

RewriteEngine on
RewriteCond %{REQUEST_FILENAME}.php -f
RewriteRule ^([^.]+)$ $1.php [NC]
RewriteCond %{REQUEST_FILENAME} >""
RewriteRule ^([^.]+)$ profile.php?user=$1 [L]

$getName = explode("/", $_SERVER["REQUEST_URI"]);

$result = mysql_query("SELECT * FROM user WHERE url='$getName[3]'");
$num_rows = mysql_num_rows($result);

if ($num_rows == 0) {
    header("Location: 404");
}

Source:
https://culttt.com/2011/11/16/how-to-make-vanity-urls-using-php-htaccess-and-mysql/