Get username from database to display in textbox
<p>I can't seem to display my username from my database into the textbox. These are my codes:</p>

<pre><code>$con = new mysqli_connect("", "", "", "");

$username = $_GET['username'];
$query = "SELECT username FROM users WHERE username=?";
$result = mysqli_query($query);
if (!$result) 
{
    die("Error: Data not found..");
}
$test = mysqli_fetch_array($result);
$username=$test['username'];
</code></pre>

<p>input type="text" name="username" id="username" value=" echo $username;?>"</p>