PHP db_query_fetch_none Examples

Example #1

File: session.inc.php Project: ZlhlmChZ/source-code-mell

function log_user_ip($userId)
{
    if (!$userId) {
        message_error('No user ID was supplied to the IP logging function');
    }
    $time = time();
    $ip = get_ip(true);
    $entry = db_select_one('ip_log', array('id', 'times_used'), array('user_id' => $userId, 'ip' => $ip));
    // if the user has logged in with this IP previously
    if ($entry['id']) {
        db_query_fetch_none('
            UPDATE ip_log SET
               last_used=UNIX_TIMESTAMP(),
               ip=:ip,
               times_used=times_used+1
            WHERE id=:id', array('ip' => $ip, 'id' => $entry['id']));
    } else {
        db_insert('ip_log', array('added' => $time, 'last_used' => $time, 'user_id' => $userId, 'ip' => $ip));
    }
}

Example #2

File: session.inc.php Project: azizjonm/ctf-engine

function log_user_ip($user_id)
{
    validate_id($user_id);
    $now = time();
    $ip = get_ip(true);
    $entry = db_select_one('ip_log', array('id', 'times_used'), array('user_id' => $user_id, 'ip' => $ip));
    // if the user has logged in with this IP previously
    if ($entry['id']) {
        db_query_fetch_none('
            UPDATE ip_log SET
               last_used=UNIX_TIMESTAMP(),
               ip=:ip,
               times_used=times_used+1
            WHERE id=:id', array('ip' => $ip, 'id' => $entry['id']));
    } else {
        db_insert('ip_log', array('added' => $now, 'last_used' => $now, 'user_id' => $user_id, 'ip' => $ip));
    }
}