/search.php

https://github.com/joesteinkamp/Postia-CMS · PHP · 68 lines · 41 code · 23 blank · 4 comment · 10 complexity · f86e0aa9661801cc07baf1b9b6f87da8 MD5 · raw file 

    

  1. <?php include 'objects/pullsettings.php'; // Retrieve settings ?>
    2. 

  2. 

  3. <?php
    4. 

  4. 

  5. $query = $_GET["q"];
    6. 

  6. 

  7. 

  8. // If no query, give message
    9. 

  9. if($query == "") {
    10. 

  10. 	echo "Oops! You didnt search for anything. Make sure you type what you want to search in the search box above.";
    11. 

  11. }
    12. 

  12. 

  13. // Perform Search
    14. 

  14. include './objects/opendb.php';
    15. 

  15. 

  16. // Search Posts Table
    17. 

  17. $result = mysql_query("SELECT * FROM $table_posts WHERE title LIKE '%$query%' OR content LIKE '%$query%' OR author LIKE '%$query%' ORDER BY timestamp DESC LIMIT 10") or die('Error : ' . mysql_error());
    18. 

  18. 	while($row = mysql_fetch_array($result, MYSQL_NUM)) {
    19. 

  19. 		list($id, $content, $timestamp, $author, $title) = $row;
    20. 

  20. 		$content = stripslashes($content);
    21. 

  21. 		
    22. 

  22. 		$search_results .= '<div class="post">';
    23. 

  23. 		if(!$title == "") { $search_results .= '<a href="post.php?id='.$id.'"><h3 class="title">'.$title.'</h3></a>'; } // If post has title, display it.
    24. 

  24. 		$search_results .= '<div class="postcontent">'.$content.'</div>';
    25. 

  25. 		$search_results .= '<div class="postmeta">'.$timestamp.' by <a href="user.php?user='.$author.'">'.$author.'</a></div>';
    26. 

  26. 		$search_results .= '<div class="postnavs"><a href="post.php?id='.$id.'">View</a> | <a href="post.php?id='.$id.'#comment">Comment</a>';
    27. 

  27. 		$user_role = getRole();
    28. 

  28. 		$current_user = getCurrentUser();
    29. 

  29. 		if($user_role  == "3" || $current_user == $author) { $search_results .= ' | <a href="">Edit</a>'; }
    30. 

  30. 		$search_results .= '</div>';
    31. 

  31. 		$search_results .= '</div>';
    32. 

  32. 	}
    33. 

  33. 	
    34. 

  34. 	
    35. 

  35. 	
    36. 

  36. 

  37. 

  38. 

  39. // End Search
    40. 

  40. include './objects/closedb.php';
    41. 

  41. 

  42. 

  43. ?>
    44. 

  44. 

  45. 

  46. <html>
    47. 

  47. <head>
    48. 

  48. 	<link rel="stylesheet" type="text/css" href="theme/<?php echo $theme; ?>/style.css" />
    49. 

  49. 	<title><?php echo $site_name; ?>: Home</title>
    50. 

  50. </head>
    51. 

  51. 

  52. <body>
    53. 

  53.     
    54. 

  54.     <div id="container">
    55. 

  55.     
    56. 

  56. 		<div id="logonav">
    57. 

  57. 			<?php include 'theme/'.$theme.'/logonav.php'; ?>
    58. 

  58. 		</div>
    59. 

  59. 		
    60. 

  60. 		<div id="content">
    61. 

  61. 			<h2>Search Results for "<?php echo $query; ?>"</h2>
    62. 

  62. 			<?php echo $search_results; ?>
    63. 

  63. 		</div>
    64. 

  64.     
    65. 

  65.     </div>
    66. 

  66.     
    67. 

  67. </body>
    68. 

  68. </html>
    69.