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
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
|
<?php
session_start();
require_once 'class.user.php';
$user_home = new USER();
if(!$user_home->is_logged_in())
{
$user_home->redirect('index.php');
}
$stmt = $user_home->runQuery("SELECT * FROM tbl_users WHERE userID=:uid");
$stmt->execute(array(":uid"=>$_SESSION['userSession']));
$row = $stmt->fetch(PDO::FETCH_ASSOC);
$id_user=$row['userID'];
// DEBU PAGINATION
$bdd = new PDO("mysql:host=127.0.0.1;dbname=dbtest;charset=utf8", "root", "");
$annoncesParPage = 3;
$annoncesTotalesReq = $bdd->query('SELECT annonce_id FROM annonce');
$annoncesTotales = $annoncesTotalesReq->rowCount();
$pagesTotales = ceil($annoncesTotales/$annoncesParPage);
if(isset($_GET['page']) AND !empty($_GET['page']) AND $_GET['page'] > 0 AND $_GET['page'] <= $pagesTotales) {
$_GET['page'] = intval($_GET['page']);
$pageCourante = $_GET['page'];
} else {
$pageCourante = 1;
}
$depart = ($pageCourante-1)*$annoncesParPage;
// FIN PAGINATION
//DEBUT BARRE DE RECHERCHE
$bdd = new PDO('mysql:host=127.0.0.1;dbname=dbtest;charset=utf8', 'root', '');
$stmt = $bdd->query("SELECT tbl_users.userID, tbl_users.userType, annonce.*, categorie.id_categorie, typecat.* FROM annonce INNER JOIN tbl_users ON annonce.user_id = tbl_users.userID INNER JOIN categorie ON categorie.id_categorie = annonce.categorie_id INNER JOIN typecat ON typecat.categorie_id = categorie.id_categorie ORDER BY annonce.date_annonce DESC LIMIT ".$depart.','.$annoncesParPage);
if(isset($_POST['titre']) && $_POST['titre'] != ""){
$titre = htmlspecialchars($_POST['titre']);
$stmt = $bdd->query('SELECT tbl_users.userID, tbl_users.userType, annonce.*, categorie.*, typecat.* FROM annonce INNER JOIN tbl_users ON annonce.user_id = tbl_users.userID INNER JOIN categorie ON categorie.id_categorie = annonce.categorie_id INNER JOIN typecat ON typecat.categorie_id = categorie.id_categorie WHERE CONCAT(titre_annonce, commentaire) LIKE "%'.$titre.'%" ORDER BY annonce.date_annonce DESC LIMIT '.$depart.','.$annoncesParPage);
}
if(isset($_POST['cat'])){
$stmt = $bdd->query('SELECT tbl_users.userID, tbl_users.userType, annonce.*, categorie.*, typecat.* FROM annonce INNER JOIN tbl_users ON annonce.user_id = tbl_users.userID INNER JOIN categorie ON categorie.id_categorie = annonce.categorie_id INNER JOIN typecat ON typecat.categorie_id = categorie.id_categorie WHERE categorie.libele_cat='.$_POST['cat'].' ORDER BY annonce.date_annonce DESC LIMIT '.$depart.','.$annoncesParPage);
}
if(isset($_POST['ville_ad'])){
$stmt = $bdd->query('SELECT tbl_users.userID, tbl_users.userType, annonce.*, categorie.*, typecat.* FROM annonce INNER JOIN tbl_users ON annonce.user_id = tbl_users.userID INNER JOIN categorie ON categorie.id_categorie = annonce.categorie_id INNER JOIN typecat ON typecat.categorie_id = categorie.id_categorie WHERE annonce.ville_annonce='.$_POST['ville_ad'].' ORDER BY annonce.date_annonce DESC LIMIT '.$depart.','.$annoncesParPage);
}
//FIN BARRE DE RECHERHCE
?>
<!DOCTYPE html>
<html class="no-js">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title><?php echo $row['userEmail']; ?></title>
<!-- Bootstrap -->
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.6.3/css/font-awesome.min.css">
<link href="bootstrap/css/bootstrap.min.css" rel="stylesheet" media="screen">
<link href="bootstrap/css/bootstrap-responsive.min.css" rel="stylesheet" media="screen">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.4/css/bootstrap.min.css">
<link href="assets/styles.css" rel="stylesheet" media="screen">
<link rel="stylesheet" type="text/css" href="css/DT_bootstrap.css">
<!-- HTML5 shim, for IE6-8 support of HTML5 elements -->
<!--[if lt IE 9]>
<script src="http://html5shim.googlecode.com/svn/trunk/html5.js"></script>
<![endif]-->
<script src="js/vendor/modernizr-2.6.2-respond-1.1.0.min.js"></script>
<script type="text/javascript" src="javascript/script.js"></script>
<script src="js/jquery.js" type="text/javascript"></script>
<script src="js/bootstrap.js" type="text/javascript"></script>
<script type="text/javascript" charset="utf-8" language="javascript" src="js/jquery.dataTables.js"></script>
<script type="text/javascript" charset="utf-8" language="javascript" src="js/DT_bootstrap.js"></script>
</head>
<body>
<?php include("topbar.php"); ?>
<div class="clearfix"></div>
<div class="container-fluid" style="margin-top:80px;">
<div class="row-fluid">
<div class="span12">
<div class="container">
<h4>
<a href="index.php"><i class="fa fa-home" aria-hidden="true"></i> Accueil</a>
<a href="account.php"><i class="fa fa-user" aria-hidden="true"></i> Profile</a>
<a href="mes-annonces.php"><i class="fa fa-bullhorn" aria-hidden="true"></i> Mes annonces</a></h4>
<hr />
<div class="search" style="text-align: center;">
<?php
?>
<form method="POST">
<input type="text" name="titre" placeholder="Que recherchez-vous?" style="height: 40px; margin-top: 10px;">
<select style="height: 40px;" name="cat">
<option value="toutes-categories" disabled="disabled" selected="selected">Toutes les catégories</option>
<option value="informatique-et-multimedia" style="" >Informatique et Multimedia</option>
<option value="vehicule" style="" >Véhicules</option>
<option value="immobilier" style="" >Immobilier</option>
<option value="maison-et-jardin" style="" >Pour la maison et Jardin</option>
<option value="habillement-et-bien-etre" style="" >Habillement et Bien Etre</option>
<option value="loisirs-et-divertissement" style="" >Loisirs et Divertissement</option>
<option value="emploi-et-service" style="" >Emploi et Services</option>
<option value="entreprise" style="" >Entreprises</option>
<option value="autres" style="" >Autres</option>
</select>
<select style="height: 40px;" name="ville_ad">
<option disabled="disabled" value="" selected="selected">Toutes les villes</option>
<option value="Chaouia-Ouardigha">Chaouia-Ouardigha</option>
<option value="Doukkala-Abda">Doukkala-Abda</option>
<option value="Fes-Boulemane">Fes Boulemane</option>
<option value="Gharb-Chrarda">Gharb-Chrarda</option>
<option value="Casablanca">Casablanca</option>
<option value="Guelmim-Es-Semara">Guelmim-Es Semara</option>
<option value="Laayoune-Boujdour">Laayoune-Boujdour</option>
<option value="Marrakech">Marrakech</option>
<option value="Meknes">Meknès</option>
<option value="Loriental">L'oriental</option>
<option value="Oued-ed-Dahab-Lagouira">Oued ed Dahab-Lagouira</option>
<option value="Rabat">Rabat</option>
<option value="Sale">Salé</option>
<option value="Souss-Massa-Draa">Souss-Massa-Draa</option>
<option value="Tadla-Azilal">Tadla-Azilal</option>
<option value="Tanger-Tetouan">Tanger-Tetouan</option>
<option value="Taza-Al-Taounate">Taza-Al-Taounate</option>
<option value="Zaer-Zemmour">Zaer-Zemmour</option>
</select>
<button class="btn btn-default" type="submit" style="height: 40px;"><i class="glyphicon glyphicon-search"></i></button>
</form>
</div>
<!-- DEBUT AFFICHAGE RECHERCHE-->
<?php
if($stmt->rowCount() > 0) {
while($row = $stmt->fetch()){
$id_date=$row['date_annonce'];
?>
<table class="table table-striped table-bordered" id="example">
<tr>
<td style="text-align:center; height:150px; width:150px;"><?php if($row['photo_annonce'] != ""): ?>
<a href="viewad.php?ad=<?php echo $row['annonce_id']; ?>"><img src="images/annonces/<?php echo $row['photo_annonce']; ?>" width="100px" height="100px"><br><span>1 Photo</span></a>
<?php else: ?>
<a href="viewad.php?ad=<?php echo $row['annonce_id']; ?>"><img src="images/upimag.png" width="100px" height="100px"><br><span>0 Photo</span></a>
<?php endif; ?>
</td>
<td style="padding-left:10px;">
<a href="viewad.php?ad=<?php echo $row['annonce_id']; ?>"><?php echo $row ['titre_annonce']; ?></a>
<table style="margin-top:30px;">
<td style=" width:100px;"><?php echo $row ['prix_annonce']; ?><BR><?php echo $row ['ville_annonce']; ?></td>
<td style="padding-left:30px;width:500px;"><?php echo $row ['commentaire']; ?><br><?php echo $row ['type_annonce']; ?> publiée dans annonce: <?php echo $row ['libele_typecat']; ?> le <?php echo $id_date; ?></td>
<td style="padding-left: 20px; padding-bottom:50px;width:100px;"><?php echo $row ['userType']; ?></td>
</table>
</td>
</tr>
<hr>
</table>
<?php } }
else{?> Aucun résultat trouvé...
<!-- FIN AFFICHAGE RECHERCHE-->
<!-- DEBUT AFFICHAGE PAGINATION-->
<?php }?>
<p style="text-align:center;">
<?php
for($i=1;$i<=$pagesTotales;$i++) {
if($i == $pageCourante) {
echo $i.' ';
} else {?>
<?php echo '<a href="TESTMYADS.php?page='.$i.'">'.$i.'</a> ';?>
<?php }
}
?>
</p>
<!-- FIN AFFICHAGE RECHERCHE-->
</div>
</div>
</div>
</div>
</div >
<!--/.fluid-container-->
<script src="bootstrap/js/jquery-1.9.1.min.js"></script>
<script src="bootstrap/js/bootstrap.min.js"></script>
<script src="assets/scripts.js"></script>
<!--HERE IS THE FOOTER-->
<?php include("footer.php"); ?>
</body>
</html> |
Problème avec ma Barre de Recherche PHP
Répondre avec citation
Partager