PHP is_it_already_tagged 예제들

예제 #1

파일: tags.php 프로젝트: taqfu/rla-old

function create_tag($achievement_id, $name)
{
    $name = trim($name);
    $is_a_new_tag = !is_it_already_tagged(0, $name);
    if ($is_a_new_tag) {
        insert_tag_into_db(0, $name);
    }
    if (!is_it_already_tagged($achievement_id, $name)) {
        insert_tag_into_db($achievement_id, $name);
        $connection = new PDO("mysql:host=" . DB_HOST . ";dbname=" . DB_NAME, DB_USER, DB_PWD);
        $statement = $connection->prepare("update tags set tally=tally+1 where active=1 and achievement_id=0 and name=?");
        $statement->bindValue(1, $name, PDO::PARAM_INT);
        $statement->execute();
    }
}

예제 #2

파일: display.php 프로젝트: taqfu/rla-old

function list_new_tags($achievement_id)
{
    $connection = new PDO("mysql:host=" . DB_HOST . ";dbname=" . DB_NAME, DB_USER, DB_PWD);
    $statement = $connection->prepare("select * from tags where active=1 and achievement_id=0 order by name asc");
    $statement->bindValue(1, $achievement_id, PDO::PARAM_INT);
    $statement->execute();
    while ($tag = $statement->fetchObject()) {
        if (!is_it_already_tagged($achievement_id, $tag->name)) {
            echo "<span id='new_tag{$tag->id}' class='create_this_tag hand text-button' style='margin-left:8px;'>{$tag->name}</span>";
        }
    }
}