PHP xf\db Database::getObject Examples

Example #1

File: api.php Project: rudolphm/xataface-school

function get_user($token = null)
{
    $db = new Database(df_db());
    if (!isset($token)) {
        $token = $_POST['token'];
    }
    if (!$token) {
        return null;
    }
    $user = $db->getObject("select username from sessions where token_id=:token_id and expires > :now", array('token_id' => $token, 'now' => time()));
    if ($user) {
        return $user->username;
    }
    return null;
}

Example #2

File: api.php Project: shannah/social-network-server

function get_profile($token = null, $username = null)
{
    global $error_message;
    $db = new Database(df_db());
    $user = get_user();
    if (!$user) {
        $error_message = "You are not logged in";
        return false;
    }
    if (!$username) {
        $username = $user;
    }
    $out = $db->getObject("select p.username, p.screen_name, p.avatar from profiles p where p.username=:user", array('user' => $username));
    if ($out) {
        $out->avatar = get_avatar_url($out);
    }
    return $out;
}