include 'engine.php'; header('Content-type: text/html; charset=utf-8'); //Echo form for search field. echo '<form method="post" action="9. Search.php"> <table> <tr> <td><input type="text" name="keyword"/></td> <td> <input type="submit" value="Sök" name="push_button" /> </tr> </table> </form>'; //If there is a keyword, search for the keyword and order the result after occurrences. if ($_POST['keyword']) { $keyword = $_POST['keyword']; $conn = start_conn('page_search'); $stmt = $conn->prepare("SELECT p.name AS url, COUNT(*) AS occurrences FROM page p, word w, occurrence o WHERE p.id = o.page_id AND w.id = o.word_id AND w.word =? GROUP BY p.id ORDER BY occurrences DESC"); $stmt->bind_param("s", $keyword); $stmt->execute(); $result = $stmt->get_result(); $stmt->close(); $conn->close(); if ($result) { echo "<h3>Search results for '" . $_POST['keyword'] . "':</h3>\n"; for ($i = 1; $row = $result->fetch_assoc(); $i++) { echo "{$i}. <a href='" . $row['url'] . "'>" . $row['url'] . "</a>\n"; echo "occurrences: (" . $row['occurrences'] . ")<br><br>\n"; } } else { echo "No results"; }
function fill_words($word, $page_id) { $conn = start_conn('page_search'); //If it is from comments, send it to the guestbook instead. if ($page_id == 0) { $result = $conn->query("SELECT id FROM page WHERE name = \"6.2.1 Gastbok.php\""); $row = mysqli_fetch_array($result); $page_id = $row['id']; $result->close(); } $result = $conn->query("SELECT id FROM word WHERE word = \"{$word}\""); $row = mysqli_fetch_array($result); //If the word is already in the database add an occurrence of it with the page_id. if ($row) { $result->close(); $word_id = $row['id']; $sql2 = "INSERT INTO occurrence(word_id, page_id) VALUES('{$word_id}','{$page_id}')"; if ($conn->query($sql2) === TRUE) { } else { echo "Error"; } } else { $result->close(); $sql = "INSERT INTO word (word) VALUES('{$word}')"; if ($conn->query($sql) === TRUE) { $result = $conn->query("SELECT id FROM word WHERE word = \"{$word}\""); $row = mysqli_fetch_array($result); $word_id = $row['id']; $sql2 = "INSERT INTO occurrence(word_id, page_id) VALUES('{$word_id}','{$page_id}')"; if ($conn->query($sql2) === TRUE) { } else { echo "Error"; } } else { echo "Error"; } } }