使用PHP什么是从数据库中将索引字符串转换为其名称值的最有效方法？

Question

Assuming I have established a connection to the database and all is well. How can I iterate efficiently through a string like $item ["tags"]=> string(54) "1,2,3,4,5,6,7,9,10,11,12,13,14,17,18,19,20,21,25,28,31"

and replace these index values with the name stored in a "tags" database table like ...

id ......... Name
1 .......... Relationships
2 .......... Services
3 .......... Counseling

Using php and mysqli... Thanks in advance.

Answer 1

I went with :

                    if ( $item->tags ) {

        $eachTag = explode(",", $item->tags);

            foreach ($eachTag as $key => $value) {
                $result = mysql_query("SELECT `name`,`id` from tags WHERE `id`=$value");
                $row = mysql_fetch_array($result);

                if ($row != "") {
                    $tagsWithName .= $row['name'].", ";
                }   
            }
        $tagsWithName = rtrim($tagsWithName, ", ");

There is probably better though ...