Display SQL database query result as link

Question

I have a search form on a previous page where I allow users to search for $q. I then query the database for 'keys' LIKE $q. The while loop displays the 'name' and 'weblink' of each matching database entry.

This all works correctly. However, I would like the 'weblink' to display as a clickable link. Ideally it would read as if it were HTML: 'weblink'. I cannot figure out the correct combo of php and html to make both the while loop, and the HTML work.

Any help would be appreciated. Thanks in advance.

// query database
$query = mysql_query("SELECT * FROM  `forumlist` WHERE  `keys` LIKE  '%$q%'");
// display query results
while($row = mysql_fetch_array($query))
    {
        echo $row['name'];
        echo "<br/>";
        echo $row['weblink'];                           
    }

alex · Accepted Answer · 2011-04-24 07:39:00Z

5

while($row = mysql_fetch_array($query))
    {
        echo $row['name'];
        echo "<br/>";
        echo '<a href="' . $row['weblink'] . '">' . $row['weblink'] . '</a>';                           
    }

answered Apr 24, 2011 at 7:39

alex

492k205 gold badges890 silver badges992 bronze badges

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

4 Comments

alex Over a year ago

@SeanA Why would I want to do that?

Dan Hoerst Over a year ago

That was easier than I thought. Works perfect. Thanks!

Sean Adkinson Over a year ago

@alex Oops, yeah, you are right. I just meant if weblink happened to have a double quote in it, it would break the HTML, so you may need to handle that, especially if weblink is user input.

alex Over a year ago

@SeanA If it were user input, I would echo with htmlspecialchars().

Collectives™ on Stack Overflow

Display SQL database query result as link

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related