/** * @param BasePDO $_pdo * @param int $id * @return self */ public static function find(BasePDO $_pdo, \int $id) { $row = $_pdo->fetchOne("SELECT * FROM university WHERE id = :id", ["id" => $id]); return $row ? new self($_pdo, $row) : null; }
/** * @param BasePDO $_pdo * @param GreekOrganization $_org * @param University $_uni * @return Chapter */ public static function findByOrgAndUni(BasePDO $_pdo, GreekOrganization $_org, University $_uni) { $query = "SELECT * FROM chapter WHERE greek_organization_id = :o AND university_id = :u"; $row = $_pdo->fetchOne($query, ["o" => $_org->getId(), "u" => $_uni->getId()]); if (!$row) { return null; } $temp = new self($_pdo, $row); $temp->_university = $_uni; $temp->_greek_organization = $_org; return $temp; }
/** * @param BasePDO $_pdo * @param string $token * @return Remember */ public static function findByToken(BasePDO $_pdo, \string $token) { $row = $_pdo->fetchOne("SELECT * FROM remember WHERE token = :t", ["t" => $token]); return $row ? new self($_pdo, $row) : null; }
/** * @param BasePDO $_pdo * @param string $name_link * @return self */ public static function findByNameLink(BasePDO $_pdo, \string $name_link) { $query = "SELECT * FROM `user` WHERE name_link = :e OR CONCAT(name_link, name_link_duplicate) = :e"; $row = $_pdo->fetchOne($query, ["e" => $name_link]); return $row ? new self($_pdo, $row) : null; }
/** * @param BasePDO $_pdo * @param int $id * @return self */ public static function find(BasePDO $_pdo, \int $id) { /** @noinspection SqlResolve */ $row = $_pdo->fetchOne("SELECT * FROM `table` WHERE id = :id", ["id" => $id]); return $row ? new self($_pdo, $row) : null; }
private static function findByColumn(BasePDO $_pdo, $column, $value) : array { return $_pdo->fetchOne("SELECT * FROM guardian WHERE {$column} = :v", ["v" => $value]); }
/** * @param BasePDO $_pdo * @param FilesystemInterface $_fs * @param int $id * @return self */ public static function find(BasePDO $_pdo, FilesystemInterface $_fs, \int $id) { $row = $_pdo->fetchOne("SELECT * FROM `file` WHERE id = :id", ["id" => $id]); return $row ? new self($_pdo, $_fs, $row) : null; }