public function fetch($email) { $db = new Database(); $table = new UserTable(); $table->Create($db); $url = null; $sql = "Select " . UserTable::Photo_URL . " from " . UserTable::TableName . " where " . UserTable::UserName . "=:email OR " . UserTable::ID . "=:email"; $stmt = $db->prepare($sql); $stmt->bindValue(":email", addslashes(strtolower(trim($email)))); $status = $stmt->execute(); if ($status) { $row = $stmt->fetch(Database::FETCH_ASSOC); $url = $row[UserTable::Photo_URL]; if ($url != null) { $url = IMAGE_PROFILE_DIR . $url; } } else { print_r($stmt->errorInfo()); } return $url; }
public function fetch($email) { if ($this->validated($email)) { //Try Create the database table $this->database = new Database(); $table = new UserTable(); $table->Create($this->database); $columns = " " . UserTable::FullName . "," . UserTable::ID . "," . UserTable::Photo_URL . "," . UserTable::RegisterDate . "," . UserTable::Gender . "," . UserTable::LastUpdateDate . "," . UserTable::VerificationCode . "," . UserTable::UserName . " "; $query = "Select {$columns} from " . UserTable::TableName . " where " . UserTable::UserName . " =:email OR " . UserTable::ID . "=:email"; $stmt = $this->database->prepare($query); $stmt->bindValue(":email", addslashes(strtolower(trim($email)))); $aBool = $stmt->execute(); if ($aBool) { if ($stmt->rowCount() > 0) { $fetchRow = $stmt->fetch(Database::FETCH_ASSOC); $fetchRow[UserTable::Photo_URL] = IMAGE_PROFILE_DIR . $fetchRow[UserTable::Photo_URL]; return $fetchRow; } else { $this->__message = "There is no username with the give email address [{$email}]"; } } } return null; }