Using php/mysql to populate href link

Question

I want my hyperlinks destination to be filled by a value from my database. However, when I click the link in my app it doesn't clear the "http://localhost/videoStorageApp/" before inserting the URl value from the database.

QUESTION: How do I clear the web browser url so only the URL value form the database is used?

WHAT I AM GETTING: http://localhost/videoStorageApp/'www.sonsofanarchy.tv'
WHAT I WANT: www.sonsofanarchy.tv

CODE:

This is the line that displays the hyperlink in question, if more code is needed please ask and ill add anything else that's needed:

echo '<td> <a href="\'' . $row['url'] . '\'" target="_blank" style="color: #137e80" (\''.$row['url'].'\');return false;">' . $row['url'] . '</a></td>';

Is the database storing just the "www.sonsofanrchy.tv"? If so, try adding switching it to <a href="htt:///\'' . $row... — Matthew Johnson
– Matthew Johnson, Commented Nov 9, 2013 at 0:27

speccode · Accepted Answer · 2013-11-09 00:27:30Z

1

echo '<td> <a href="http://'.$row['url'].'" target="_blank" style="color: #137e80">' . $row['url'] . '</a></td>';

answered Nov 9, 2013 at 0:27

speccode

1,5629 silver badges11 bronze badges

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

3 Comments

Corey Over a year ago

This was helpful and it nearly works, it seems to leave out the : after http.

speccode Over a year ago

Nearly? If $row['url'] returns URL like this: www.example.com not http://www.example.com then it have to work.

Corey Over a year ago

ah i see. The link i was testing with had http:// in the database entry. I removed it and your code worked as you said it would! I will have to change my application so it removes the "http://" when someone submits a link. Thanks for your help!

frnhr · Accepted Answer · 2013-11-09 00:51:29Z

1

You are probably missing "http://" in your href attribute.

<a href="google.com">

... will take you to http://currentsite.com/maybe-a-subfolder/google.com

<a href="http://google.com">

... will take you to http://google.com

answered Nov 9, 2013 at 0:51

frnhr

13k9 gold badges70 silver badges96 bronze badges

Collectives™ on Stack Overflow

Using php/mysql to populate href link

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related