https://www.facebook.com/groups/tr.developers/permalink/978729772175493/

978729772175493.php

<?php

// comma seperated tag list
$tags = $_POST['tags'];
$contentId = $_POST['contentId'];

$tagIds = InsertTagsAndGetIds(explode(',', $tags));

foreach ($tagIds as $tagId) {

    InsertContentTag($contentId, $tagId);
}



function InsertContentTag($contentId, $tagId)
{
    if ( ! empty($contentId) && ! empty($tagId)) {

        $query = 'INSERT INTO content_tag (content_id, tag_id) VALUES (?, ?)';

        if ($stmt = $conn->prepare($query)) {

            $stmt->bind_param('ii', $contentId, $tagId);
            $stmt->execute();
        }
    }
}

function InsertTagsAndGetIds($tags)
{
    $returnIds = [];

    foreach ($tags as $tag) {

        if ($tagId = InsertTagAndGetId($tag))
            $returnIds[] = $tagId;
    }

    return $returnIds;
}

function InsertTagAndGetId($tag)
{
    $query = 'SELECT id FROM tags WHERE name = "' . $tag . '"';

    $result = $conn->query($query);

    if ($result->num_rows == 0) {

        // insert tag
        $query = 'INSERT INTO tags (name) VALUES (?)';
        if ($stmt = $conn->prepare($query)) {

            $stmt->bind_param('s', $tag);

            return $conn->insert_id;
        }

        return null;

    } else {

        return $result->fetch_assoc()['id'];
    }
}