src/snac/server/database/SQL.php
/**
     * Get user id email
     *
     * Return the first user record based on email. Email is not unique, so there may be multiple users with
     * the same email address. This simply returns the first appuser record found. See the commentary with
     * function readUser() in DBUser.php
     *
     * @param string $email Email to look up for the associated User
     *
     * @return string[] A list with keys: id, active, username, email, first, last, fullname, avatar,
     * avatar_small, avatar_large, affiliation. Or false is returned.
     */
Get user id email
Return the first user record based on email. Email is not unique, so there may be multiple users with
the same email address. This simply returns the first appuser record found. See the commentary with
function readUser() in DBUser.php

@param string $email Email to look up for the associated User

@return string[] A list with keys: id, active, username, email, first, last, fullname, avatar,
avatar_small, avatar_large, affiliation. Or false is returned.
Get user id email Return the first user record based on email . Email is not unique so there may be multiple users with the same email address . This simply returns the first appuser record found . See the commentary with function readUser () in DBUser . php @param string $email Email to look up for the associated User @return string [] A list with keys : id active username email first last fullname avatar avatar_small avatar_large affiliation . Or false is returned .
public function selectUserByEmail($email)
    {
        $result = $this->sdb->query("select id from appuser where lower(email) = lower($1) limit 1",
                                    array($email));
        $row = $this->sdb->fetchrow($result);
        if ($row && array_key_exists('id', $row))
        {
            $rec = $this->selectUserByID($row['id']);
            return $rec;
        }
        return false;
    }
public function selectUserByEmail ( $ email ) { $ result = $ this -> sdb -> query ( " select id from appuser where lower(email) = lower($1) limit 1 " , array ( $ email ) ) ; $ row = $ this -> sdb -> fetchrow ( $ result ) ; if ( $ row && array_key_exists ( 'id' , $ row ) ) { $ rec = $ this -> selectUserByID ( $ row [ 'id' ] ) ; return $ rec ; } return false ; }
Get user id email
 Return the first user record based on email.
Get user id email Return the first user record based on email .
/*
             * Call selectUserByID() to avoid all copy/paste code.
             */