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();
}
