在 php 和 mysql 中标记

发布于 2024-10-10 17:32:08 字数 873 浏览 5 评论 0原文

我用于添加标签的数据库架构与这个问题相同...

我的问题是如何将每个标签与当前线程相关联，到目前为止我已经这样做了：

    $sql = "INSERT INTO thread (title, content, author_id)
            VALUES ('$safe_title', '$safe_html_content', '$user_id')";
    $insert_thread = insert_Query($sql, $link);

    #   get the thread id:
    $thread_id = mysqli_insert_id($link);

    #   insert the tags:
    foreach ($tags as $tag)
    {
        insert_Query("INSERT INTO tags (tag) 
        VALUES ('$tag')", $link);
    }

    #   connect tags to thread:
    $sql = "INSERT INTO thread_tags (thread_id, tag_id)
            VALUES ('$thread_id', )"; ## what to do here?

我想知道如何填写 ItemTag 表（在我的情况下是 thread_tags ）...我可以获得 id当前线程的 ID，如 $thread_id var 中所示，但是如何获取每个标记的 id 并将其与该线程关联？

谢谢。

原文

My database schema for adding tags is the same as this question...

My question is how do I relate each tag with the current thread, so far I have done this:

    $sql = "INSERT INTO thread (title, content, author_id)
            VALUES ('$safe_title', '$safe_html_content', '$user_id')";
    $insert_thread = insert_Query($sql, $link);

    #   get the thread id:
    $thread_id = mysqli_insert_id($link);

    #   insert the tags:
    foreach ($tags as $tag)
    {
        insert_Query("INSERT INTO tags (tag) 
        VALUES ('$tag')", $link);
    }

    #   connect tags to thread:
    $sql = "INSERT INTO thread_tags (thread_id, tag_id)
            VALUES ('$thread_id', )"; ## what to do here?

I want to know how I can fill in the ItemTag table (thread_tags in my case)... I can get the id of the current thread as shown in the $thread_id var, but how do I get the id of each tag and associate it with this thread?

Thank you.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

掀纱窥君容 2024-10-17 17:32:08

我不太确定你为什么要这样做，但你尝试过吗？

#   insert the tags:
foreach ($tags as $tag)
{
    insert_Query("INSERT INTO tags (tag) 
    VALUES ('$tag')", $link);
    $tag_id = mysqli_insert_id($link);
    insert_Query("INSERT INTO thread_tags (thread_id, tag_id)
        VALUES ('$thread_id', $tag_id )",$link);
}

I'm not really sure why do you want to do it like that, but did you try this?

#   insert the tags:
foreach ($tags as $tag)
{
    insert_Query("INSERT INTO tags (tag) 
    VALUES ('$tag')", $link);
    $tag_id = mysqli_insert_id($link);
    insert_Query("INSERT INTO thread_tags (thread_id, tag_id)
        VALUES ('$thread_id', $tag_id )",$link);
}

回复收藏 0 原文

~没有更多了~