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