gamerig/ricerca.php at master · federico-castellani/gamerig · 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
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
<?php
    $servername = "localhost";
    $username = "esame";
    $password = "esameWeb25";
    $dbname = "GameRig";
    $conn = mysqli_connect($servername, $username, $password, $dbname);
    if (!$conn) {
        die("Connessione fallita: ".mysqli_connect_error());
    }

    if(!isset($_GET['ricerca'])) {
        header("Location: index.php");
        exit();
    }

    $ricerca = $_GET['ricerca'];
    $ricerca = $conn->real_escape_string($ricerca);
    $sql = "SELECT * FROM Prodotto WHERE nomeProdotto LIKE '%".$ricerca."%';";
    $result = mysqli_query($conn, $sql);
?>
<!DOCTYPE html>
<html lang="it-IT">
    <head>
        <title>GameRig: <?php echo $ricerca;?></title>
        <meta charset="utf-8">
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
        <meta name="description" content="Sito di vendita di componenti per PC da Gaming">
        <link href="style.css" type="text/css" rel="stylesheet">
        <link rel="stylesheet" href="https://fonts.googleapis.com/icon?family=Material+Icons">
    </head>
    <body>
        <header class="header">
            <form method="GET" action="ricerca.php">
                <a href="index.php"><h1>GameRig</h1></a>
                <input type="text" name="ricerca" placeholder="Cerca" id="cerca" class="ricercaBarraLunga">
                <button type="submit"><i class="material-icons" style="font-size:2.3em;">search</i></button>
                <a href="utente.php" class="icone"><i class="material-icons" style="font-size:2.3em;">person</i></a>
                <a href="carrello.php" class="icone"><i class="material-icons" style="font-size:2.3em;">shopping_cart</i></a>
            </form>
            <a href="javascript:void(0);" id="hamburger">
                <i class="material-icons" style="font-size:1.5em;" id="icona-hamburger">menu</i>
                <p>Menu</p>
            </a>
            <nav>
                <ul>
                    <li><a href="cpu.php">CPU</a></li>
                    <li><a href="gpu.php">SCHEDE VIDEO</a></li>
                    <li><a href="ram.php">RAM</a></li>
                    <li><a href="motherboard.php">SCHEDE MADRI</a></li>
                    <li><a href="case.php">CASE</a></li>
                </ul>
            </nav>
        </header>
        <main class="ricerca">
            <?php
                if (mysqli_num_rows($result) > 0) {
                    echo "<h1>Risultati per '".$ricerca."'</h2>";
                    echo "<div>";
                    while($row = mysqli_fetch_assoc($result)) {
                        echo "<div><a href='prodotto.php?idProdotto=".$row["idProdotto"]."'>";
                        echo "<img src='images/".$row["idProdotto"]."_1.jpg' alt='Immagine ".$row["nomeProdotto"]."'>";
                        echo "<p>".$row["nomeProdotto"]."</p>";
                        $sconto = "SELECT sconto
                                   FROM Offerta
                                   WHERE idProdotto = ".$row['idProdotto']." AND dataInizio <= CURDATE() AND dataFine >= CURDATE()";
                        $risSconto = mysqli_query($conn, $sconto);

                        if (mysqli_num_rows($risSconto) > 0) {
                            $sconto = mysqli_fetch_assoc($risSconto);
                            $prezzoScontato = $row['prezzo'] - ($row['prezzo'] * $sconto['sconto'] / 100);
                            echo "<p>Prezzo: <del>".$row['prezzo']."€</del> ".round($prezzoScontato, 2)."€</p>";
                            echo "<p>Sconto: ".$sconto['sconto']."%</p>";
                        } else {
                            echo "<p>Prezzo: " .$row['prezzo']. "€</p>";
                        }
                        echo "</a></div>";
                    }
                    echo "</div>";
                } else {
                    echo "<h1>Nessun risultato trovato</h2>";
                }
            ?>
        </main>
        <footer>
            <p>Advertise</p>
            <p>Cookie Policy</p>
            <p>Terms of service</p>
            <p onclick="location.href='maps.html'" id="maps">Dove siamo</p>
        </footer>
        <script src="scripts/hamburger.js"></script>
    </body>
</html>
<?php
    mysqli_close($conn);
?>