make a PHP variable a link

Question

Does anyone know how to make a link out of a php variable. I want my php variable $LeagueLink to be a link to leaguehome with the name of the result of a mysql query. Please help if you can....

$result = mysql_query("SELECT League FROM League_Info WHERE User_ID = '$id'");
$result2 = mysql_fetch_array($result);
    $result3 = $result2['League'];
    $LeagueLink = '<a href="home.com/test.php"><?=$result3?></a>';

security tip: use prepared statements

Kurt
– Kurt

2012-07-22 02:33:39 +00:00
Commented Jul 22, 2012 at 2:33 — Kurt
– Kurt, Commented Jul 22, 2012 at 2:33

Hubro · Accepted Answer · 2012-07-22 02:14:17Z

4

$LeagueLink = "<a href=\"http://home.com/leaguehome.php\">$result3</a>";

To place variables directly into a string like above, it needs to be a double quote string ("), not a single quote string (')

Or, if you're worried about carelessness-provoked errors, use string concatenation:

$LeagueLink = '<a href="http://home.com/leaguehome.php">' . $result3 . '</a>';

answered Jul 22, 2012 at 2:14

Hubro

60.1k74 gold badges241 silver badges404 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Cole Tobin Over a year ago

Please don't embed variables in strings, it is subject to errors if done carelessly.

user849137 Over a year ago

"<a href=\"home.com/leaguehome.php\">$result3</a>" should be "<a href=\"home.com/leaguehome.php\">".$result3."</a>"

sgielen Over a year ago

And when you're at it, if you don't need metacharacters in the string, change the double-quotes to single-quotes. And don't forget to put http:// before home.com, so the link works correctly.

Hubro Over a year ago

@sgielen: I need the double quotes for embedding variables. I used single quotes on the concatenation alternative

codingbiz · Accepted Answer · 2012-07-22 02:17:09Z

1

You can also do this

$LeagueLink = '<a href="home.com/leaguehome.php">'.$result3.'</a>';

answered Jul 22, 2012 at 2:17

codingbiz

26.4k9 gold badges62 silver badges99 bronze badges

2 Comments

John Doe Over a year ago

what about with this... $LeagueLink = "<a href="leaguehome.php">$result3</a>";

codingbiz Over a year ago

You need to escape the double quotes. You can't put double quotes with double quotes. It is either ' "a" ' or " 'a' "

Collectives™ on Stack Overflow

make a PHP variable a link

2 Answers 2

4 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related