Pressbooks\Catalog::saveTag PHP Метод

    function saveTag($tag, $blog_id, $tag_group)
    {
        /** @var $wpdb \wpdb */
        global $wpdb;
        $tag = strip_tags($tag);
        $tag = trim($tag);
        // INSERT ... ON DUPLICATE KEY UPDATE
        // @see http://dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html
        $sql = "INSERT INTO {$this->dbTagsTable} ( users_id, tag ) VALUES ( %d, %s ) ON DUPLICATE KEY UPDATE id = id ";
        $sql = $wpdb->prepare($sql, $this->userId, $tag);
        $_ = $wpdb->query($sql);
        // Get ID
        $sql = "SELECT id FROM {$this->dbTagsTable} WHERE tag = %s ";
        $sql = $wpdb->prepare($sql, $tag);
        $tag_id = $wpdb->get_var($sql);
        // Create JOIN
        $sql = "INSERT INTO {$this->dbLinkTable} ( users_id, blogs_id, tags_id, tags_group ) VALUES ( %d, %d, %d, %d ) ON DUPLICATE KEY UPDATE users_id = users_id ";
        $sql = $wpdb->prepare($sql, $this->userId, $blog_id, $tag_id, $tag_group);
        $result = $wpdb->query($sql);
        return $result;
    }