How do I embed a php variable into an html href link?

Question

Requirement: Read rows from a mysql database, where one column contains an address and a city, make the resulting address into a link to google maps, by passing the address for the location only as described in the following link: is there a way to pass arguments to google map's get directions functionality? php code shippet $result = mysql_query($sql) or die(mysql_error()); while($row = mysql_fetch_array($result)) { echo''.$row['DAYTIME'].''.$row['MEETINGNAME'].' '.''.$row['ADDRESSCITY'].''.''.$row['BLDGNAME'].''; } ?> The above block of code sucefully creates a link to maps.google.com BUT I want to put $row['ADDRESSCITY'] between the "http://maps.google.com/?q= and the closing " I tried this:

'<a href="http://maps.google.com/?q='.$row['ADDRESSCITY'].'/a'">'

and no results are displayed, and no error message either. Thanks

nekiala · Accepted Answer · 2015-02-19 13:39:31Z

1

Can you try to remove the quote " just after <a href="http://maps.google.com/?q=

answered Feb 19, 2015 at 13:39

nekiala

5001 gold badge10 silver badges23 bronze badges

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

Comments

maartenpaauw · Accepted Answer · 2015-02-19 13:35:27Z

0

Change the url to this.

echo'<tr><td>'.$row['DAYTIME'].'</td><td>'.$row['MEETINGNAME'].'</td><td>'.'<a href="http://maps.google.com/?q='.$row['ADDRESSCITY'].'">Google Maps</a>'.'</td><td>'.$row['BLDGNAME'].'</td></tr>';

answered Feb 19, 2015 at 13:35

maartenpaauw

6242 gold badges8 silver badges21 bronze badges

Comments

Neo · Accepted Answer · 2015-02-19 13:36:00Z

0

Try this :

echo'<tr><td>'.$row['DAYTIME'].'</td><td>'.$row['MEETINGNAME'].'</td><td>'.'<a href="http://maps.google.com/?q="'.$row['ADDRESSCITY'].'"></a></td><td>'.$row['BLDGNAME'].'</td></tr>';

answered Feb 19, 2015 at 13:36

Neo

6962 gold badges14 silver badges33 bronze badges

2 Comments

John Connolly Over a year ago

Requirement: Must open the above link in a new window. Here is what I tried, but it did not open a new window or tab (I don't care which) - those pesky single and double quotes!

John Connolly Over a year ago

echo'<tr><td>'.$row['DAYTIME'].'</td><td>'.$row['MEETINGNAME'].'</td><td>'.'<a href="google.com/….' target="_blank".'">'.$row['ADDRESSCITY'].'</a>'.'</td><td>'.$row['BLDGNAME'].'</td></tr>';

Collectives™ on Stack Overflow

How do I embed a php variable into an html href link?

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related