- $r = q("SELECT `pub_keywords`, `username`, `nickname`, `user`.`uid` FROM `user` LEFT JOIN `profile` ON `user`.`uid` = `profile`.`uid` WHERE `is-default` = 1 AND `user`.`hidewall` = 0 AND MATCH `pub_keywords` AGAINST ('%s') LIMIT %d , %d ",
- dbesc($search),
- intval($startrec),
- intval($perpage)
+ if (DBA::isResult($count_stmt)) {
+ $row = DBA::fetch($count_stmt);
+ $total = $row['total'];
+ }
+
+ DBA::close($count_stmt);
+
+ $search_stmt = DBA::p(
+ "SELECT `pub_keywords`, `username`, `nickname`, `user`.`uid`
+ FROM `user`
+ JOIN `profile` ON `user`.`uid` = `profile`.`uid`
+ WHERE `is-default` = 1
+ AND `user`.`hidewall` = 0
+ AND MATCH(`pub_keywords`) AGAINST (?)
+ LIMIT ?, ?",
+ $search,
+ $startrec,
+ $perpage