j'ai recupéré un code que j'ai adapté a mon site, cependant et malgré mon acharnement je ne parviens pas a convertir a afficher la date au format jour mois année
voici donc mon code
<?php
$servername = "localhost";
$dbname = "db608832558";
$dbusername = "root";
$dbpassword = "";
$error = FALSE;
$result = FALSE;
try {
$conn = new PDO("mysql:host=$servername;dbname=$dbname", $dbusername, $dbpassword, array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"));
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$total = $conn->query("SELECT COUNT(id) as rows FROM livre")
->fetch(PDO::FETCH_OBJ);
$perpage = 5; # nb de message par pages
$posts = $total->rows;
$pages = ceil($posts / $perpage);
# default
$get_pages = isset($_GET['page']) ? $_GET['page'] : 1;
$data = array(
'options' => array(
'default' => 1,
'min_range' => 1,
'max_range' => $pages
)
);
$number = trim($get_pages);
$number = filter_var($number, FILTER_VALIDATE_INT, $data);
$range = $perpage * ($number - 1);
$prev = $number - 1;
$next = $number + 1;
$stmt = $conn->prepare("SELECT ID, pseudo, message, temps, tps FROM livre ORDER BY tps DESC LIMIT :limit, :perpage");
$stmt->bindParam(':perpage', $perpage, PDO::PARAM_INT);
$stmt->bindParam(':limit', $range, PDO::PARAM_INT);
$stmt->execute();
$result = $stmt->fetchAll();
} catch(PDOException $e) {
$error = $e->getMessage();
}
$conn = null;
?>
<!doctype html>
<html lang="fr">
<head>
<title>Boulangerie Brisse</title>
<?php include ('include/head.php'); ?>
</head>
<body>
<?php include ('include/en-tete.php'); ?>
<?php include ('include/menu.php'); ?>
</br>
<h3> Laissez nous un message ! </h3></br>
<div id="wrap">
<?php
if($error)
{
echo "
<div class=\"error\">
<p><strong>Database Error:</strong> $error</p>
<p><a href=\"index.php\">retour à la page d'acceuil</a></p>
</div>";
}
?>
<div class="navigation">
<?php
if($result && count($result) > 0)
{
echo "<h3>Total messages ($posts)</h3>";
# first page
if($number <= 1)
echo "<span>« prev</span> | <a href=\"?page=$next\">next »</a>";
# last page
elseif($number >= $pages)
echo "<a href=\"?page=$prev\">« prev</a> | <span>next »</span>";
# in range
else
echo "<a href=\"?page=$prev\">« prev</a> | <a href=\"?page=$next\">next »</a>";
}
else
{
echo "<p>No results found.</p>";
}
?>
</div>
<?php
if($result && count($result) > 0)
{
foreach($result as $key => $row)
{
echo "
</br>
<div>
<div style=width:auto;border:solid 1px black; background-color: yellow;>
le $row[temps], $row[pseudo] à écrit </div>
<div>
$row[message]
</div>
$row[tps]
</br>
</div>
";
}
echo '
</table>
</div>
';
}
?>
</div>
</br>
<?php include('include/footer.php'); ?>
</div>
</body>
</html>