1. <html xmlns="http://www.w3.org/1999/xhtml">
  2. <head>
  3. <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  4. </head>
  5. <body style="font-family:Courier">
  6. <?PHP
  7. function getmicrotime() {
  8. list($usec, $sec) = explode(" ", microtime());
  9. return ((float)$usec + (float)$sec);
  10. }
  12. //initializing connection to the database
  13. $connection_string = dirname(__FILE__) . "/connectionstring.php";
  15. require_once($connection_string);
  17. //selecting table
  18. mysql_select_db("kutuphane") or die ( 'Unable to select database.' );
  20. //max number of results on the page
  21. $RESULTS_LIMIT=5;
  23. if(isset($_GET['search_term']) && isset($_GET['search_button']))
  24. {
  25. $search_term = $_GET['search_term'];
  27. if(!isset($first_pos))
  28. {
  29. $first_pos = "0";
  30. }
  32. $start_search = getmicrotime();
  33. //initializing MySQL Quary
  34. $sql_query = mysql_query("SELECT * FROM mesajlar WHERE MATCH(isim,mesaj) AGAINST('$search_term')");
  36. //additional check. Insurance method to re-search the database again in case of too many matches (too many matches cause returning of 0 results)
  37. if($results = mysql_num_rows($sql_query) != 0)
  38. {
  39. $sql = "SELECT * FROM mesajlar WHERE MATCH(isim,mesaj) AGAINST('$search_term') LIMIT $first_pos, $RESULTS_LIMIT";
  40. $sql_result_query = mysql_query($sql);
  41. }
  42. else
  43. {
  44. $sql = "SELECT * FROM mesajlar WHERE (isim LIKE '%".mysql_real_escape_string($search_term)."%' OR mesaj LIKE '%".$search_term."%') ";
  45. $sql_query = mysql_query($sql);
  46. $results = mysql_num_rows($sql_query);
  47. $sql_result_query = mysql_query("SELECT * FROM mesajlar WHERE (isim LIKE '%".$search_term."%' OR mesaj LIKE '%".$search_term."%') LIMIT $first_pos, $RESULTS_LIMIT ");
  48. }
  50. $stop_search = getmicrotime();
  51. //calculating the search time
  52. $time_search = ($stop_search - $start_search);
  53. }
  54. ?>
  56. <?PHP
  57. if($results != 0)
  58. {
  59. ?>
  60. <!-- Displaying of the results -->
  62. <?PHP echo "<i><b><font color=#000000>".$search_term."</font></b></i> "; ?>için arama sonuçları |
  63. Results <b>
  64. <?PHP echo ($first_pos+1)." - ";
  65. if(($RESULTS_LIMIT + $first_pos) < $results) echo ($RESULTS_LIMIT + $first_pos);
  66. else echo $results ; ?>
  67. </b>
  68. out of <b><?PHP echo $results; ?></b>
  69. for(<b><?PHP echo sprintf("%01.2f", $time_search); ?></b>)
  70. seconds </td>
  73. <form action="" method="GET">
  74. <input name="search_term" type="text" value="<?PHP echo $search_term; ?>" size="40">
  75. <input name="search_button" type="submit" value="Search">
  76. </form>
  78. <?PHP
  79. while($row = mysql_fetch_array($sql_result_query))
  80. {
  81. ?>
  83. <p><b><?PHP echo $row['isim']; ?></b><p><?PHP echo $row['mesaj']; ?><hr style="border-top:dashed 1px;border-bottom:none;">
  86. <?PHP
  87. }
  88. ?>
  90. <?PHP
  91. }
  92. //if nothing is found then displays a form and a message that there are nor results for the specified term
  93. elseif($sql_query)
  94. {
  96. ?>
  98. <?PHP echo "<i><b><font color=#000000>".$search_term."</font></b></i> "; ?> bulunamadı
  99. <form action="" method="GET">
  101. <input name="search_term" type="text" value="<?PHP echo $search_term; ?>">
  102. <input name="search_button" type="submit" value="Search">
  104. </form>
  106. <?PHP
  107. }
  108. ?>
  109. <?php
  110. if (!isset($_GET['search_term'])) { ?>
  112. <form action="" method="GET">
  114. <input name="search_term" type="text" value="<?PHP echo $search_term; ?>">
  115. <input name="search_button" type="submit" value="Search">
  117. </form>
  119. <?php
  120. }
  121. ?>
  123. <?PHP
  125. //displaying the number of pages where the results are sittuated
  127. if($first_pos > 0)
  128. {
  129. $back=$first_pos-$RESULTS_LIMIT;
  130. if($back < 0)
  131. {
  132. $back = 0;
  133. }
  134. echo "<a href='search.php?search_term=".stripslashes($search_term)."&first_pos=$back' ></a>";
  135. }
  137. if($results>$RESULTS_LIMIT)
  138. {
  139. $sites=intval($results/$RESULTS_LIMIT);
  140. if($results%$RESULTS_LIMIT)
  141. {
  142. $sites++;
  143. }
  144. }
  145. for ($i=1;$i<=$sites;$i++)
  146. {
  147. $fwd=($i-1)*$RESULTS_LIMIT;
  148. if($fwd == $first_pos)
  149. {
  150. echo "<a href='search.php?search_term=".stripslashes($search_term)."&first_pos=$fwd '><b>$i</b></a> | ";
  151. }
  152. else
  153. {
  154. echo "<a href='search.php?search_term=".stripslashes($search_term)."&first_pos=$fwd '>$i</a> | ";
  155. }
  156. }
  158. if(isset($first_pos) && $first_pos < $results-$RESULTS_LIMIT)
  159. {
  160. $fwd=$first_pos+$RESULTS_LIMIT;
  161. echo '<a href="./search.php?search_term='.stripslashes($search_term)."&first_pos=$fwd".' " > >></a>';
  162. $fwd=$results-$RESULTS_LIMIT;
  163. }
  164. ?>
  166. </body>
  167. </html>