UserInterfaceDevelopment_Portal/results.php at main · ewsc/UserInterfaceDevelopment_Portal · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
<?php
    include"header.php";
    $query = $_GET["query"];
?>

<div class="uk-height-large uk-flex uk-flex-center uk-flex-middle uk-background-cover uk-light" data-src="res/search.jpg" uk-img style="background-attachment: fixed">
    <h1 class="text-shadow" id="results-header">Search results</h1>
</div>

<div class="uk-container uk-margin-top sp-height">

    <div class="uk-grid-match uk-grid-divider" uk-grid>

    <?php $sql = "SELECT id, name, added_by, desc_short, desc_full, time_added FROM main WHERE name LIKE '%$query%' ORDER BY time_added desc";
    $result = $conn->query($sql);

    if ($result->num_rows == 0) {
        $sql = "SELECT id, name, added_by, desc_short, desc_full, time_added FROM main WHERE desc_short LIKE '%$query%' ORDER BY time_added desc";
        $result = $conn->query($sql);
    }

    if ($result->num_rows == 0) {
        $sql = "SELECT id, name, added_by, desc_short, desc_full, time_added FROM main WHERE desc_full LIKE '%$query%' ORDER BY time_added desc";
        $result = $conn->query($sql);
    }

    if ($result->num_rows > 0) {
        while($row = $result->fetch_assoc()) { ?>

    <?php $tempDate = new DateTime($row["time_added"]); ?>

        <div class="uk-width-1-3">
            <div class="uk-card uk-card-body uk-card-default uk-margin-bottom">
                <h3 class="uk-margin-remove-bottom"><a class="uk-link-reset" href=""><?php echo $row["name"]?></a></h3>
                <p class="uk-text-meta uk-margin-remove-top">by <i><a href="#"><?php echo $row["added_by"]?></a></i> on <?php echo date_format($tempDate, "H:i, d.m.y") ?></p>
                <hr>
                <p class="uk-text-meta"><?php echo $row["desc_short"] ?></p>
                <a class="uk-button uk-button-text" href="/article.php?id=<?php echo $row["id"] ?>">Read more</a>
            </div>
        </div>

    <?php }
    } else { ?>

        <div class="uk-width-1-1">
            <div class="uk-card uk-card-body uk-card-default uk-margin-bottom">
                <h3 class="uk-margin-remove-bottom"><a class="uk-link-reset" href="">Nothing found.</a></h3>
                <hr>
                <p class="uk-text-meta">No results from your query "<?php echo $query?>"</p>
            </div>
        </div>

    <?php } ?>

    </div>

</div>

<?php include"footer.php" ?>