ruyy Posted November 17, 2010 Share Posted November 17, 2010 Hello, I don't really know where to post this, so I am posting this here. This script is in french so I will explain a bit. I want to make a quick blog with comments. I know nothing about PHP and I don't have time to learn because I have to do this to monday. In commentaires.php you can view the blog post you have clicked on with the comments related to it. When you post a comment the page commentaires_post.php inserts the author, comment text and date with time in the phpmyadmin table named "commentaires". I have a problem when I make a post, the id of the comment is not related to the blog post itself. in the table "commentaires" in phpmyadmin: id -> the id of the comment id_billet means the id of the blog post (translation of "billet" is "note" or something like that) auteur -> author commentaire -> comment date_commentaire -> date_comment commentaires.php: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="fr" > <head> <title>Mon blog</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <link href="style.css" rel="stylesheet" type="text/css" /> </head> <body> <h1>Mon super blog !</h1> <p><a href="index.php">Retour à la liste des billets</a></p> <?php // Connexion à la base de données try { $bdd = new PDO('mysql:host=localhost;dbname=test', 'root', ''); } catch(Exception $e) { die('Erreur : '.$e->getMessage()); } // Récupération du billet $req = $bdd->prepare('SELECT id, titre, contenu, DATE_FORMAT(date_creation, \'%d/%m/%Y à %Hh%imin%ss\') AS date_creation_fr FROM billets WHERE id = ?'); $req->execute(array($_GET['billet'])); $donnees = $req->fetch(); ?> <div class="news"> <h3> <?php echo htmlspecialchars($donnees['titre']); ?> <em>le <?php echo $donnees['date_creation_fr']; ?></em> </h3> <p> <?php echo nl2br(htmlspecialchars($donnees['contenu'])); ?> </p> </div> <h2>Commentaires</h2> <?php $req->closeCursor(); // Important : on libère le curseur pour la prochaine requête // Récupération des commentaires $req = $bdd->prepare('SELECT auteur, commentaire, DATE_FORMAT(date_commentaire, \'%d/%m/%Y à %Hh%imin%ss\') AS date_commentaire_fr FROM commentaires WHERE id_billet = ? ORDER BY date_commentaire'); $req->execute(array($_GET['billet'])); while ($donnees = $req->fetch()) { ?> <p><strong><?php echo htmlspecialchars($donnees['auteur']); ?></strong> le <?php echo $donnees['date_commentaire_fr']; ?></p> <p><?php echo nl2br(htmlspecialchars($donnees['commentaire'])); ?></p> <?php } // Fin de la boucle des commentaires $req->closeCursor(); ?> <!-- Ajouter un commentaire / Post a comment --> <form action="commentaires_post.php" method="post"> <p> <label for="auteur">Auteur</label> : <input type="text" name="auteur" id="auteur" /><br /> <label for="commentaire">Commentaire</label> : <input type="text" name="commentaire" id="commentaire" /><br /> <input type="hidden" name="id_billet" value="<?php echo $_GET['billet']; ?>" /> <input type="submit" value="Envoyer" /> </p> </form> </body> </html> commentaires_post.php: <?php // Connexion à la base de données try { $bdd = new PDO('mysql:host=localhost;dbname=test', 'root', ''); } catch(Exception $e) { die('Erreur : '.$e->getMessage()); } // Insertion du commentaire à l'aide d'une requête préparée $req = $bdd->prepare('INSERT INTO commentaires (id_billet, auteur, commentaire, date_commentaire) VALUES(?, ?, ?, NOW())'); $req->execute(array($_POST['id_billet'], $_POST['auteur'], $_POST['commentaire'])); // Redirection du visiteur vers la page de commentaires.php header('Location: commentaires.php'); ?> Quote Link to comment https://forums.phpfreaks.com/topic/218962-blog-and-comment-problem/ Share on other sites More sharing options...
Greeky Posted November 17, 2010 Share Posted November 17, 2010 I suggest you go through this tutorial : http://net.tutsplus.com/tutorials/php/how-to-create-an-object-oriented-blog-using-php/ It's extremely helpful, an easy step by step tutorial with screenshots too! Good luck! Let us know how you get on! - Greeky. Quote Link to comment https://forums.phpfreaks.com/topic/218962-blog-and-comment-problem/#findComment-1135821 Share on other sites More sharing options...
ruyy Posted November 18, 2010 Author Share Posted November 18, 2010 Oh thanks! very nice! But they don't show how to create comments related to the posts and that's where my problem is Quote Link to comment https://forums.phpfreaks.com/topic/218962-blog-and-comment-problem/#findComment-1136069 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.