search.php 1.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748
  1. <?php
  2. session_start();
  3. include('logo.html');
  4. include('menulist.html');
  5. include('configuration');
  6. include('searchengine.php');
  7. include('search.html');
  8. if(isset($_POST['search'])) {
  9. $searchtext = $_REQUEST['searchtext'];
  10. $in = $_REQUEST['searchmenu'];
  11. if(trim($searchtext) == '') {
  12. echo '<div align="center"><font color="RED">Please enter some keyword to search</font></div>';
  13. exit();
  14. }
  15. $searchtext = '%'.$searchtext.'%';
  16. }
  17. else if($_GET['author'] != '') {
  18. $searchtext = '%'.$_GET['author'].'%';
  19. $in = "author";
  20. }
  21. else if ($_GET['disp'] == 'all') {
  22. $searchtext = "%";
  23. $in = "module";
  24. }
  25. else if ($_GET['disp'] != '') {
  26. $searchtext = $_GET['disp'].'%';
  27. $in = "module";
  28. }
  29. else
  30. exit();
  31. $result = searchdb($searchtext, $in, $db);
  32. echo '<table align="left" border="0" cellpadding="8" cellspacing="1">';
  33. if($row = sqlite3_fetch_array($result))
  34. echo "<tr><td><a href=\"dispmoduleinfo.php?module=".$row['module']."\">".$row["module"]."</a></br>".
  35. "<a href=\"search.php?author=".$row["author"]."\">".$row["author"]."</a> : ". $row["title"].
  36. " </br> </br></td></tr>";
  37. else
  38. echo '<div align="center"><font color="RED"> No results found</font></div>';
  39. while($row = sqlite3_fetch_array($result)) {
  40. echo "<tr><td><a href=\"dispmoduleinfo.php?module=".$row['module']."\">".$row["module"]."</a></br>".
  41. "<a href=\"search.php?author=".$row["author"]."\">".$row["author"]."</a> : ". $row["title"].
  42. " </br> </br></td></tr>";
  43. }
  44. echo '</table>';
  45. ?>