| @@ 62-68 (lines=7) @@ | ||
| 59 | } |
|
| 60 | $sql = "SELECT id, uid, name, grouping, shared, mtime, deleted, note FROM *PREFIX*ownnote n WHERE n.id= ? $uidSql $deletedSql"; |
|
| 61 | $results = []; |
|
| 62 | foreach ($this->execute($sql, $params)->fetchAll() as $item) { |
|
| 63 | /** |
|
| 64 | * @var $note NextNote |
|
| 65 | */ |
|
| 66 | $note = $this->makeEntityFromDBResult($item); |
|
| 67 | $results[] = $note; |
|
| 68 | } |
|
| 69 | return array_shift($results); |
|
| 70 | } |
|
| 71 | ||
| @@ 94-100 (lines=7) @@ | ||
| 91 | } |
|
| 92 | $sql = "SELECT id, uid, name, grouping, shared, mtime, deleted, note FROM *PREFIX*ownnote n WHERE `uid` = ? $groupSql $deletedSql"; |
|
| 93 | $results = []; |
|
| 94 | foreach ($this->execute($sql, $params)->fetchAll() as $item) { |
|
| 95 | /** |
|
| 96 | * @var $note NextNote |
|
| 97 | */ |
|
| 98 | $note = $this->makeEntityFromDBResult($item); |
|
| 99 | $results[] = $note; |
|
| 100 | } |
|
| 101 | return $results; |
|
| 102 | } |
|
| 103 | ||