Adding Html link to every line of database

Forum|Forum|16 years ago
June 11, 2009
3 replies
1594 views

I know the heading sounded a bit strange so I will try to explain it here:

I have created a recordset of a database which lists the top sites of the day now the database has a field site_names in which I add the top ten site names every day.

I m already using the nl2br code to add a line break after every line.

Now I want the lines to link to their respective sites.

See if we try to create a click here link that links to http://www.adobe.com then the code generated will be like this:

<a href="http://www.adobe.com">Click Here</a>

Now lets say the sites that I have added are

http://www.blogator.blogspot.com

http://www.tensports.com

http://www.fifa.com

so I need a code such that these values get converted into not in the database but only in the browser.

<a href="http://www.blogator.blogspot.com">http://www.blogator.blogspot.com</a>

<a href=" http://www.tensports.com"> http://www.tensports.com</a>

plz help the code that I m using now is this

<?php echo nl2br ($row_rsSites['site_names']); ?>

this code allows to add a line break to all the lines in a database.

Plz help if any one of you have not understood what m trying to explain plz let me know I will try to explain again.

Server side applications

This topic has been closed for replies.

David_Powers

Inspiring

Marking this thread as "assumed answered".

A

adi3199-1tG22dAuthor

Known Participant

Ok let me simplify it when I type a website address in adobe like I m now it comes out to be like this

http://www.wwe.com

But when I add this same line to a post it comes out with out any links in my site

     http://www.wwe.com

David_Powers

Inspiring

As the others have said, maybe time to reconsider your database structure. However, since each URL is separated by a newline character, what you want to do is fairly easy.

$sites = explode("\n", $row_rsSites['site_names']);
foreach ($sites as $site) {
  echo "<a href='$site'>$site</a><br />";
}

The first line creates an array of the sites, breaking them at the new line character. The rest of the code uses a foreach loop to go through each URL in the array, and uses echo to create the link.