public static function find_by_name($name) { $sql = "SELECT * FROM users WHERE name = ? ORDER BY updated_at DESC LIMIT 1"; $pdo = NeechyDatabase::connect_to_db(); $query = $pdo->prepare($sql); $query->execute(array($name)); $row = $query->fetch(PDO::FETCH_ASSOC); if ($row) { $user = new User($row); } else { $user = new User(array('name' => $name)); } return $user; }
public static function find_by_title($title) { $sql = "SELECT * FROM pages WHERE slug = ? ORDER BY created_at DESC LIMIT 1"; $slug = self::title_to_slug($title); $pdo = NeechyDatabase::connect_to_db(); $query = $pdo->prepare($sql); $query->execute(array($slug)); $row = $query->fetch(PDO::FETCH_ASSOC); if ($row) { $page = new Page($row); } else { $page = new Page(array('title' => $title, 'slug' => $slug)); } return $page; }
public static function count() { $sql = sprintf('SELECT COUNT(*) FROM %s', self::extract_table_name()); $pdo = NeechyDatabase::connect_to_db(); return $pdo->query($sql)->fetchColumn(); }