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";
}
}
}
