php - 将标签添加到数据库值

Question

我从数据库中获取一些值，我想拆分它并向其中添加 html 标签。

$sql = "SELECT
            ip_adres,
        GROUP_CONCAT(DISTINCT nickname2 ORDER BY nickname2) nickname
        FROM
            users
        GROUP BY ip_adres
        HAVING COUNT(*) > 1";
$users = $db->prepare($sql);
$users->execute();

foreach($users as $u){
    $nick = $u['nickname'];
    $ip = $u['ip_adres'];
    echo "$nick $ip";
}

$nick输出类似于 value1,value2现在我想给这两个值都添加一个 a href所以输出必须像 <a href=test.php?url=value>value1</a>, <a href=test.php?url=value2>value2</a>所以每个昵称都可以点击并 href 到昵称页面我该怎么做？

Answer 1

尝试

<?php

if($s = $db->query('SELECT
            ip_adres,
        GROUP_CONCAT(DISTINCT nickname2 ORDER BY nickname2) namen
        FROM
                users
        GROUP BY ip_adres
        HAVING COUNT(*) > 1')) {
    while ($row = $s->fetch(PDO::FETCH_ASSOC)) { 
        $c = '';
        $nicks = explode(',', $row['namen']);
        foreach($nicks as $nick) {
            echo "
            $c <a href=$nick>$nick</a> 
            ";
            $c = ', ';
        }
        echo ' IP-Adres (' . $row['ip_adres'] . ')<br>';
    }
}

?>