AppInfo/traitementRA.php at master · ErwanLP/AppInfo · 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
<?php
$bdd = new PDO('mysql:host=localhost;dbname=appinfo', 'root', '');
$bdd->exec('SET NAMES utf8');
//connection à la base de données

$theme = $_POST['genre'];
$date = $_POST['date'];
//$note = $_POST['note'];
//$prix = $_POST['prix'];
$ville = $_POST['ville'];

//SELECT * FROM `event` WHERE theme = "spectacle" and lieu = "Sanssat"

$result = $bdd->query('SELECT * FROM event WHERE theme = "' . $theme . '" AND lieu = "' . $ville . '"');
//echo 'SELECT * FROM event WHERE theme = "' . $theme . '" AND lieu = "' . $ville .'"'
//   SELECT * FROM event WHERE theme = concert AND date = 2012-11-28 AND lieu = paris
//envois de la requete sql
// on ferme le curseur
?>


<!--if (($pieces[$i] != "le") || ($pieces[$i] != "la") || ($pieces[$i] != "les") || ($pieces[$i] != " ") || ($pieces[$i] != "de") || ($pieces[$i] != "du") || ($pieces[$i] != "des") || ($pieces[$i] != "au") || ($pieces[$i] != "evenement") || ($pieces[$i] != "soiree")) { // faire un fichier php avec un tableau avec tout les mot bidon


// faire un fichier php avec un tableau avec tout les mots non voulus

-->


<?php session_start(); ?>
    <?php include("start.php"); ?>


        <?php include("header.php"); ?>

        <?php include("nav.php"); ?>


        <section>
            <aside class ="navg">
                <?php include ("arbre.php"); ?>
            </aside>

            <aside class ="new">
                <?php include('nouveauteEvenement.php'); ?>

                <?php
                if (!isset($_SESSION['ID'])) {
                    include("connexion.php");
                }
                if (isset($_SESSION['SWITCH']) AND $_SESSION['SWITCH'] == "organisateur" AND $_SESSION['ID'] != null) {
                    ?>
                    <div class="positionBouton">
                        <a href="creationEvenement.php"><img src ="img/ampouleCreerEvenement.png"/></a>
                    </div>
                    <?php
                }
                ?>
            </aside>

            <article class ="articleevent">
                <?php
                while ($data = $result->fetch()) {
                    include('articleevent.php');
                }

                $result->closeCursor();
                ?>


            </article>
        </section>
 <?php include("footer.php"); ?>