php database field as hyperlink

Question

I have a mySQL database that has a web address field that is a type: text. When it shows up on my web page I would like it to be clickable as a hyperlink.

I have code around the field to "show if not empty" and can't figure out how to wrap it as a hyperlink.

Here's my code:

<?php if($row_rsEvents['weblink'] != "") { ?><span class="webAddress"><?php echo $row_rsEvents['weblink']; ?></a></span><br><?php } ?>

Thanks for your help.

your stored urls looks like: http://... or <a href="http://.."... ? — spinsch
– spinsch, Commented Aug 10, 2014 at 18:43

Erlesand · Accepted Answer · 2014-08-10 18:45:51Z

1

You need to add an <a> after your opening <span>,

<?php 
if($row_rsEvents['weblink'] != "") { ?>
    <span class="webAddress"><a href="<?php echo $row_rsEvents['weblink']; ?>"><?php echo $row_rsEvents['weblink']; ?></a></span><br>
<?php } ?>

answered Aug 10, 2014 at 18:45

Erlesand

1,53512 silver badges16 bronze badges

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

1 Comment

user2930069 Over a year ago

This worked. My urls are all stored without the http:// All I had to was add that to the <a href=" and it works perfectly. Thanks for your quick response!

Mureinik · Accepted Answer · 2014-08-10 18:46:48Z

0

<?php
  $weblink = $row_rsEvents['weblink'];  
  if($weblink != '') { 
    echo "<span class=\"webAddress\"><a href=\"$weblink\">$weblink</a></span><br>";
  } 
?>

answered Aug 10, 2014 at 18:46

Mureinik

316k54 gold badges399 silver badges405 bronze badges

Collectives™ on Stack Overflow

php database field as hyperlink

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related