PHP db_DoQuery Examples

Example #1

File: streamsdb.php Project: switchUA/stuff

function DbSetVote($movie_name, $vote_value)
{
    if ($vote_value < 0) {
        return;
    }
    if ($vote_value > 5) {
        return;
    }
    // welke movie en user id?
    $movie_id = DbGetMovieId($movie_name);
    $user = DbGetCurrentUser();
    $vote[movie_id] = $movie_id;
    $vote[user_id] = $user[user_id];
    $vote[vote_value] = $vote_value;
    // bestaande vote weghalen
    db_DoQuery("\n\t    DELETE \n\t    FROM votes\n\t    WHERE user_id='{$vote['user_id']}'\n\t    AND\tmovie_id='{$vote['movie_id']}'\n\t");
    // noaie toevoegn
    db_SetRow("votes", 0, $vote);
}

Example #2

File: config.php Project: LastResortGames/ludumdare

function _config_Set($key, $value)
{
    db_Connect();
    return db_DoQuery("INSERT " . CMW_TABLE_CONFIG . " (\n\t\t\t`key`, `value`, `timestamp`\n\t\t)\n\t\tVALUES ( \n\t\t\t?, ?, NOW()\n\t\t);", $key, $value);
}