/** * @return array */ public function getMyPiles() { $db = Loader::db(); $u = new User(); if ($u->isRegistered()) { $v = array($u->getUserID()); $q = "select pID from Piles where uID = ? order by name asc"; } $piles = array(); $r = $db->query($q, $v); if ($r) { while ($row = $r->fetchRow()) { $piles[] = Pile::get($row['pID']); } } return $piles; }
function get($pcID) { $db = Loader::db(); $v = array($pcID); $q = "select pID, pcID, itemID, itemType, displayOrder, quantity, timestamp from PileContents where pcID = ?"; $r = $db->query($q, $v); $row = $r->fetchRow(); $pc = new PileContent(); if (is_array($row)) { foreach ($row as $k => $v) { $pc->{$k} = $v; } } $p = Pile::get($pc->pID); $pc->p = $p; // pc-p . get it ? return $pc; }