Tagging in php and mysql

Question

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.

Josh · Accepted Answer · 2011-01-06 06:19:06Z

2

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);
}

edited Jan 6, 2011 at 6:19

Josh

11.1k11 gold badges67 silver badges112 bronze badges

answered Jan 6, 2011 at 1:08

Jose Armesto

14k8 gold badges55 silver badges58 bronze badges

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

Collectives™ on Stack Overflow

Tagging in php and mysql

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related