超链接数据库内容

Question

I'm building a database-driven gaming fansite and I want to be able to hyperlink mentions of items and other words that have their own page. For example, assume this is a page.

Item Name

This is a description of the item being pulled from the database. It can be combined with Item2 and Item3 to make Item4.

I would like to hyperlink Item2, Item3 and Item4 to their respective pages so that a user can navigate through the website more efficiently rather than having to type each name into the search bar manually.

I know that this can be achieved by inserting HTML into the description cell and have the browser to output it, but besides the obvious security risk of outputting unsantiised HTML, it would also be incredibly tedious to do this for each item and the table could begin to look rather ugly as it gets filled with anchor tags.

Nevertheless, I've seen such functionality on other websites and I'm wondering what's the safest and/or most efficient way of achieving this?

Answer 1

Create file like item.php.

if(isset($_GET['name']) && !empty($_GET['name'])) {

    $item_name = $_GET['name'];
    //Your code like fetching from database WHERE name LIKE $item_name
    //And also printing your description with the hyperlinks to the  actualy item from $_GET['name']

}

If you have not so much different items you can add the achors with str_replace. Heres an example.

<?php
$text = "This is a description of the item being pulled from the database. It can be combined with Item2 and Item3 to make Item4.";

$item_names = array("Item2", "Item3", "Item4");

foreach($item_names as $item_name) {
    $text = str_replace($item_name, "<a href='item.php?name=".$item_name."'>".$item_name."</a>", $text);
}

echo $text;
?>

$item_names must be a array with all you item names.

And Hyperlinks like:

This is a description of the item being pulled from the database. It can >be combined with Item2 (item.php?name=item2) and Item3 >(item.php?name=item3) to make Item4 (item.php?name=item4).`