Ventacar/index.php at master · Mathilde89/Ventacar · 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
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
<?php
// session_start();
// var_dump($_POST);

require __DIR__ . "/pdo.php";
require __DIR__."/session.php";


function showAnnonce($pdo){

    // JOIN cars ON listcars.id_cars=cars.id
    $query = $pdo->prepare("SELECT listcars.startingprice,listcars.id,listcars.startdate,listcars.enddate,listcars.sellingprice,cars.model,cars.powerful,cars.year,cars.description FROM `listcars`JOIN cars ON listcars.id_cars=cars.id");
    $query->execute();
    $listcars = $query->fetchAll(PDO::FETCH_ASSOC);

    // Affichage des enchères terminées
    // var_dump($listcars);
    // var_dump($listcars[0]["id"]);

    if(isset($_POST["submitTri"]) && $_POST["submitTri"]=="Enchères terminées"){

        foreach ($listcars as $key => $listcar) {
            if(date('Y-m-d')>$listcar["enddate"]){
                echo "<ul>";
                    echo "<li>Modèle : ".$listcar["model"]."</li>";
                    echo "<li>Puissance: ".$listcar["powerful"]."chevaux fiscaux</li>";
                    echo "<li>Année de mise en circulation: ".$listcar["year"]."</li>";
                    echo "<li>Description: ".$listcar["description"]."</li>";
                    echo "<li>ID de l'annonce ".$listcar["id"]."</li>";
                    echo "<li><div class='choix'><a href='enchere.php?id=".$listcar['id']."'>Voir l'enchère</a></div></li>";
                 echo "</ul>";
                }


        }

    } else if(isset($_POST["submitTri"]) && $_POST["submitTri"]=="Enchères en cours"){
        foreach ($listcars as $key => $listcar) {
            if(date('Y-m-d')<=$listcar["enddate"]){
                echo "<ul>";
                    echo "<li>Modèle : ".$listcar["model"]."</li>";
                    echo "<li>Puissance: ".$listcar["powerful"]."chevaux fiscaux</li>";
                    echo "<li>Année de mise en circulation: ".$listcar["year"]."</li>";
                    echo "<li>Description: ".$listcar["description"]."</li>";
                    echo "<li>ID de l'annonce ".$listcar["id"]."</li>";
                    echo "<li><div class='choix'><a href='enchere.php?id=".$listcar['id']."'>Voir l'enchère</a></div></li>";
                echo "</ul>";
                }

    }
    } else{
        foreach ($listcars as $key => $listcar) {
             echo "<ul>";

                    echo "<li>Modèle : ".$listcar["model"]."</li>";
                    echo "<li>Puissance: ".$listcar["powerful"]."chevaux fiscaux</li>";
                    echo "<li>Année de mise en circulation: ".$listcar["year"]."</li>";
                    echo "<li>Description: ".$listcar["description"]."</li>";
                    echo "<li>ID de l'annonce ".$listcar["id"]."</li>";
                    echo "<li><div class='choix'><a href='enchere.php?id=".$listcar['id']."'>Voir l'enchère</a></div></li>";
                echo "</ul>";
                }

    }
    }


?>
<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="UTF-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.2.0/css/all.min.css" integrity="sha512-xh6O/CkQoPOWDdYTDqeRdPCVd1SpvCA9XXcUnZS2FmJNp1coAFzvtCN9BmamE+4aHK8yyUHUSCcJHgXloTyT2A==" crossorigin="anonymous" referrerpolicy="no-referrer" />
    <link rel="preconnect" href="https://fonts.googleapis.com">
    <link rel="preconnect" href="https://fonts.gstatic.com" crossorigin>
    <link href="https://fonts.googleapis.com/css2?family=Tenor+Sans&display=swap" rel="stylesheet">
    <link rel="stylesheet" href="style/style.scss">
    <title>Document</title>
</head>

<body>
    <header>
        <?php
        include __DIR__ . "/menu.php";
        afficherMenu($menu);
        ?>

    </header>

    <h1> <i class="fa-solid fa-gavel"></i> Nos annonces</h1>

    <div class="tri">

        <form action="index.php" method="post">

            <input class="choix" type="submit" name="submitTri" value="Tout">
            <input class="choix" type="submit" name="submitTri" value="Enchères terminées">
            <input class="choix" type="submit" name="submitTri" value="Enchères en cours">
        </form>

    </div>

    <div class="container">


        <?php showAnnonce($pdo);?>
    </div>


</body>

</html>