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
| <?php
session_start();
$bdd = new PDO('mysql:host=127.0.0.1;dbname=espace_membre', 'root', '');
if(isset($_GET['id']) AND $_GET['id'] > 0)
{
$getid = intval($_GET['id']);
$requser = $bdd->prepare('SELECT * FROM membres WHERE id = ?');
$requser->execute(array($getid));
$userinfo = $requser->fetch();
$pseudo = $userinfo['pseudo'];
$reqproduit = $bdd->prepare('SELECT vendeur, produit, quantite, date_vente, DAY(date_vente) AS jour, MONTH(date_vente) AS mois, YEAR(date_vente) AS annee FROM ventes WHERE vendeur = ?');
$reqproduit->execute(array($pseudo));
$venteinfo = $reqproduit->fetch();
$dernierjour = $bdd->prepare('SELECT date_vente, DAY(date_vente) AS jour, MONTH(date_vente) AS mois, YEAR(date_vente) AS annee FROM ventes WHERE vendeur = ? ORDER BY id DESC LIMIT 1');
$dernierjour->execute(array($pseudo));
$last = $dernierjour->fetch();
$jourvente = $bdd->prepare('SELECT date_vente, DAY(date_vente) AS jour, MONTH(date_vente) AS mois, YEAR(date_vente) AS annee FROM ventes WHERE vendeur = ? ORDER BY id');
$jourvente->execute(array($pseudo));
$jour = $jourvente->fetch();
$reqvente = $bdd->prepare('SELECT produit, quantite FROM ventes WHERE id_vendeur = ? AND date_vente = ? LIMIT 5');
$reqvente->execute(array($_GET['id'], $last['date_vente']));
}else{
header('Location: connexion.php');
}
?>
<html>
<head>
<title>Profil de <?php echo $userinfo['pseudo']; ?></title>
<meta charset="utf-8" />
<link rel="stylesheet" type="text/css" href="../templates/css/profil.css" />
<link rel="stylesheet" type="text/css" href="../templates/css/calendrier.css" />
</head>
<body>
<div id="panel-top">
<h2><?php
if (isset($_SESSION['id']) AND $userinfo['id'] == $_SESSION['id']) {
?> Votre Profil <?php
}elseif (isset($userinfo['pseudo'])){?> Profil de <?php echo $userinfo['pseudo'];}
else{
header('Location: connexion.php');
}
?></h2>
</div>
<?php
if (isset($_SESSION['id']) AND $userinfo['id'] == $_SESSION['id'])
{
?>
<a href="logout.php" id="logout">Déconnexion<img src="../templates/img/CloseRed.png" id="close" /></a>
<?php } ?>
<div align="center" id="content-avatar">
<?php
if(!empty($userinfo['avatar']))
{
?>
<img src="../membres/avatars/<?php echo $userinfo['avatar']; ?>" id="avatar" />
<?php
}else{
?>
<img src="../membres/avatars/Profil<?php echo $userinfo['rand'] ?>.png" id="avatar" />
<?php
}
?>
<?php
if (isset($_SESSION['id']) AND $userinfo['id'] == $_SESSION['id'])
{
?>
<a id="modifier" href="editionprofil.php"><!--Modifier--><img src="../templates/img/Pen.png" id="pencil"></a>
<?php
}
?>
<br /><br />
</div>
</body>
</html> |
Partager