public function get_num_row($keyword)
{
if (empty(self::$conn)) {
self::$conn = $this->connect_pdo();
}
$sql = "SELECT distinct p.id \n\t\t\t\t\tFROM pages AS p,tags_target AS tg,tags AS t,users AS u\n\t\t\t\t\tWHERE p.id=tg.page_id AND t.id=tg.tag_id AND u.id=p.author_id\n\t\t\t\t\t\tAND t.name LIKE'%{$keyword}%'";
$stmt = self::$conn->prepare($sql);
$stmt->execute();
$num = $stmt->rowCount();
return $num;
}
