PHP FeedAggregator_DatabaseHelper::get_tag_id_for_tag_string Examples

Example #1

File: FeedAggregator_DatabaseHelper.inc.php Project: saulhoward/haddock-cms

    public static function add_tags_to_feed($id, $tags)
    {
        $dbh = DB::m();
        foreach ($tags as $tag) {
            $tag = mysql_real_escape_string($tag);
            $tag_query_1 = <<<SQL
INSERT
INTO
    hpi_feed_aggregator_tags
SET
    tag = '{$tag}',
    principal = 'no'

SQL;
            $result = mysql_query($tag_query_1, $dbh);
            if ($result) {
                $tag_id = mysql_insert_id($dbh);
            } else {
                if (mysql_errno() == 1062) {
                    #duplicate
                    $tag_id = FeedAggregator_DatabaseHelper::get_tag_id_for_tag_string($tag);
                }
            }
            $tag_id = mysql_real_escape_string($tag_id);
            $tag_query_2 = <<<SQL
INSERT
INTO
    hpi_feed_aggregator_tags_to_feed_links
SET
    tag_id = '{$tag_id}',
    feed_id = '{$id}'

SQL;
            $result = mysql_query($tag_query_2, $dbh);
            if (!$result) {
                if (mysql_errno() == 1062) {
                    #duplicate
                    # Do nothing, link already exists
                }
            }
        }
        return $id;
    }