profile/index.php
<?php

//MySQLI Connection//
function ConnectToMYSQLI()
{
$db_host = "localhost";
$db_username = "<some_user>";
$db_pass = "<some_pass>";
$db_name = "<some_db>";

$myConnection1 = mysqli_connect("$db_host","$db_username","$db_pass", "$db_name") or die ("could not connect to mysql");

return $myConnection1;

mysqli_close($myConnection1);
}
//---------------------------//

//------Get User Data------//
function GetUserData($GetUserDataName)
{
    //Make the string safe//
        //$GetUserDataName1 =  mysqli_real_escape_string(ConnectToMYSQLI(),$GetUserDataName);

        $UserData = "";

    //Get Author Name//
        $sqlCommand = "SELECT * FROM users WHERE Username='$GetUserDataName1' LIMIT 1";
        $query = mysqli_query(ConnectToMYSQLI(), $sqlCommand) or die("Error Getting User Data: " . mysqli_error());
        $NumRows = mysqli_num_rows($query);
        if($NumRows != 0)
        {
            while ($row = mysqli_fetch_array($query)) {
                $UserData['ID'] = $row["ID"];
                $UserData['Email'] = $row["Email"];
                $UserData['HideEmail'] = $row["hide_email"];
                $UserData['IP'] = $row["ip"];
                $UserData['Joined'] = $row["Joined"];
                $UserData['LastOnline'] = $row["Last_Online"];
                $UserData['Location'] = $row["Location"];
                $UserData['Name'] = $row["Name"];
                $UserData['DOB'] = $row["DOB"];
                $UserData['Website'] = $row["Website"];
                $UserData['Steam'] = $row["Steam"];
                $UserData['XFire'] = $row["XFire"];
                $UserData['PS3'] = $row["ps3"];
                $UserData['Xbox'] = $row["xbox"];
                $UserData['Youtube'] = $row["youtube"];
                $UserData['Avatar'] = $row["Avatar"];
                $UserData['Sig'] = $row["Signature"];
            }
        } else {
            $UserData['ID'] = "ERROR";
        }
        mysqli_free_result($query);

//Return Value//
return $UserData;
}
//---------------------------//


if(isset($_GET["name"]))
{
    $GetUserName = $_GET["name"];
    $UserURLName = mysqli_real_escape_string(ConnectToMYSQLI(), $GetUserName);

    echo $UserURLName . "<br />";

    $UserDATA = GetUserData($UserURLName);


    if($UserDATA['ID'] != "ERROR")
    {
        echo "UserID: " . $UserDATA['ID'] . "<br />";
        echo "Email: " . $UserDATA['Email'] . "<br />";
        echo "Joined: " . $UserDATA['Joined'] . "<br />";
    } else {
        echo "ERROR!!!";
    }

}
?>
.httaccess
Options +FollowSymlinks
RewriteEngine on
RewriteRule ^profile/([^/]+) profile/index.php?name=$1