无法在URL中获取用户名

Question

So I'm trying to make public profiles. So i'm getting the result from the database and shooting it back. Here's my code

$username = $con->prepare("SELECT username FROM users WHERE email=:email");
$username->bindValue(':email', $email, PDO::PARAM_STR);
$username->execute();
$userurl = $_GET['username'];

For some reason I'm not getting anything back. No errors either. Any help would be great. So basically what I want to do is get example.com/profile?username=joe

Answer 1

$stmt = $con->prepare("SELECT username FROM users WHERE email=:email");
$stmt->bindValue(':email', $email, PDO::PARAM_STR);
$stmt->execute();

$row = $stmt->fetch();
$username = $row['username'];


$userurl = "example.com/profile?username=$username";
header("Location: $userurl") ;

You executed the query but never fetched the data, $_GET doesn't do what you think, it is meant to get a query string value.

As the @Rangad and @David pointed out in the comment below, you should generate the query string using http_build_query:

...
$stmt->execute(); 
$row = $stmt->fetch();
header('Location: example.com/profile?'.http_build_query($row)) ;