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
| <?php
try{
$pdo_options[PDO::ATTR_ERRMODE] = PDO::ERRMODE_EXCEPTION;
$bdd = new PDO('mysql:host=localhost;dbname=pravin;charset=utf8', 'root', 'root', $pdo_options);
?>
<!DOCTYPE html>
<html lang="fr">
<head>
<?php
session_start();
?>
<meta charset="utf-8" />
<link rel="apple-touch-icon" sizes="76x76" href="./assets/img/images/logo_s.png"">
<link rel="icon" type="image/png" href="./assets/img/images/logo_s.png">
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1" />
<title>
Projet Poster
</title>
<meta content='width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=0, shrink-to-fit=no' name='viewport' />
<!-- Fonts and icons -->
<link rel="stylesheet" type="text/css" href="https://fonts.googleapis.com/css?family=Roboto:300,400,500,700|Roboto+Slab:400,700|Material+Icons" />
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/font-awesome/latest/css/font-awesome.min.css">
<!-- CSS Files -->
<link href="./assets/css/material-kit.css?v=2.0.6" rel="stylesheet" />
<link href="./assets/poster/poster.css" rel="stylesheet" />
</head>
<body class="index-page sidebar-collapse">
<?php include "header.php" ?>
<div class="page-header header-filter clear-filter purple-filter" data-parallax="true" style="background-image: url('./assets/img/images/esigelec_bandeau.png');">
<div class="container">
<div class="row">
<div class="col-md-8 ml-auto mr-auto">
<div class="brand">
</div>
</div>
</div>
</div>
</div>
<div class="main main-raised">
<div class="section section-basic">
<div class="container">
<div class="title">
<!-- contenu fichier -->
<div id="carouselExampleIndicators" class="carousel slide" data-ride="carousel">
<ol class="carousel-indicators">
<li data-target="#carouselExampleIndicators" data-slide-to="0" class="active"></li>
<li data-target="#carouselExampleIndicators" data-slide-to="1"></li>
<li data-target="#carouselExampleIndicators" data-slide-to="2"></li>
</ol>
<div class="carousel-inner">
<?php
// On récupère tout le contenu de la table ping
$reponse = $bdd->query('SELECT * FROM ping');
// On affiche chaque entrée une à une
while ($donnees = $reponse->fetch()){?>
<div class="carousel-item active">
<img class="d-block w-100" src="<?php echo $donnees['pjt_poster'];?>" alt="First slide">
</div>
</div>
<a class="carousel-control-prev" href="#carouselExampleIndicators" role="button" data-slide="prev">
<span class="carousel-control-prev-icon" aria-hidden="true"></span>
<span class="sr-only">Previous</span>
</a>
<a class="carousel-control-next" href="#carouselExampleIndicators" role="button" data-slide="next">
<span class="carousel-control-next-icon" aria-hidden="true"></span>
<span class="sr-only">Next</span>
</a>
</div>
<?php
}
?>
<div clas="container-fluid">
<div class="container">
<div class="album py-5 bg-light">
<div class="container">
<?php
// On récupère tout le contenu de la table ping
$reponse = $bdd->query('SELECT * FROM ping');
// On affiche chaque entrée une à une
while ($donnees = $reponse->fetch()){?>
<section class="col-md-4">
<div class="card mb-4 shadow-sm">
<img class="bd-placeholder-img card-img-top" width="100%" height="225" src="<?php echo $donnees['pjt_poster'];?>" preserveAspectRatio="xMidYMid slice" focusable="false" role="img" aria-label="Placeholder: Thumbnail" alt="<?php echo $donnees['pjt_nom'];?>"/>
<div class="card-body">
<p class="card-text"><?php echo $donnees['pjt_description']; ?> </p>
</div>
</section>
<?php
}
?>
<?php
$reponse->closeCursor();
}
catch (Exception $e){
die('Erreur de connexion !!! ' . $e->getMessage());
}
?>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<footer class="footer" data-background-color="black">
<div class="container">
<nav class="float-left">
</nav>
<div class="copyright float-right">
©
<script>
document.write(new Date().getFullYear())
</script>, made with <i class="material-icons">favorite</i> by
<a href="https://www.creative-tim.com" target="_blank">Creative Tim</a> for a better web.
</div>
</div>
</footer>
<!-- Core JS Files -->
<script src="./assets/js/core/jquery.min.js" type="text/javascript"></script>
<script src="./assets/js/core/popper.min.js" type="text/javascript"></script>
<script src="./assets/js/core/bootstrap-material-design.min.js" type="text/javascript"></script>
<script src="./assets/js/plugins/moment.min.js"></script>
<!-- Plugin for the Datepicker, full documentation here: https://github.com/Eonasdan/bootstrap-datetimepicker -->
<script src="./assets/js/plugins/bootstrap-datetimepicker.js" type="text/javascript"></script>
<!-- Plugin for the Sliders, full documentation here: http://refreshless.com/nouislider/ -->
<script src="./assets/js/plugins/nouislider.min.js" type="text/javascript"></script>
<!-- Google Maps Plugin -->
<script src="https://maps.googleapis.com/maps/api/js?key=YOUR_KEY_HERE"></script>
<!-- Control Center for Material Kit: parallax effects, scripts for the example pages etc -->
<script src="./assets/js/material-kit.js?v=2.0.6" type="text/javascript"></script>
</body>
</html> |
Partager