search.php 940 B

123456789101112131415161718192021222324252627282930313233
  1. <?php
  2. if(!defined('IN_T')){
  3. die('hacking attempt');
  4. }
  5. $word = Common::sfilter($_REQUEST['word']);
  6. if (!empty($word)) {
  7. $size = 32; //定义每页显示10条
  8. $page = intval($_REQUEST['page']);
  9. $page = $page<1 ? 1 : $page;
  10. $res = search($word,$page,$size);
  11. $pages = Common::set_page($size,$page,$res['count']);
  12. foreach ($pages as $key => $value) {
  13. $pages[$key]['url'] = "/search?page=".$value['num'].$res['spm'];
  14. }
  15. $tp->assign("word",$word);
  16. $tp->assign("page",$page);
  17. $tp->assign("pages",$pages);
  18. $tp->assign("list",$res);
  19. }
  20. function search($word,$page=0,$size=32){
  21. $sql = $GLOBALS['Base']->table('worksmain').' WHERE name LIKE "%'.$word.'%"';
  22. $spm = "&word=$word"; //整合检索字符串
  23. $res['spm']= $spm;
  24. $res['count'] = $GLOBALS['Db']->query("SELECT COUNT(*) AS num FROM ".$sql,"One");
  25. $res['res'] = $GLOBALS['Db']->query('SELECT * FROM '.$sql." LIMIT ".($page-1)*$size.",".$size."","All");
  26. return $res;
  27. }
  28. ?>