Bonjour
Je semble me heurter a cette erreur plusieurs fois sans trop savoir d'ou elle vient.
Pouvez-vous m'aider?
<!-- ADD COMMENT FORM -->
<form action="model/add_comment.php" method="post" class="form-example">
<div class="form-example">
<div>
<input type="text" name="PostId" id="PostId" value="{POST_ID}" disabled>
</div>
<div>
<label for="name">Commentaires: </label>
</div>
<div class="form-example">
<label for="name">User Name: </label>
<input type="text" name="UserName" id="UserName" required>
</div>
<div class="form-example input_text">
<textarea name="Comment" id="textarea" required></textarea>
</div>
</div>
<div class="form-example validate">
<input type="submit" value="Ajouter Commentaire: ">
</div>
</form>
<!-- add_comment.php -->
<?php
require "../config.php";
// DEFINE DATABASE CONNECTION - PDO
try {
$bdd = new PDO('mysql:host=localhost;dbname=' . $Database_Name, $Database_User, $Database_Password);
} catch (\Throwable $e) {
die('Erreur : ' . $e->getMessage());
}
// BOUTON - INSERT TO DATABASE
if ($_SERVER['REQUEST_METHOD'] == "POST" and isset($_POST["UserName"])) {
$UserName = $_POST["UserName"];
$Comment = $_POST["Comment"];
$Valide = "TRUE";
$Post_ID = $_POST["PostId"];
// PREPARE QUERY - use prepare pour les accents sur les lettres
$req = $bdd->prepare("INSERT INTO comments(username, contenu, valide, post_id, date_creation) values (?, ?, ?, ?, NOW()) ");
$req->execute(array($UserName, $Comment, $Valide, $Post_ID));
header('Location: ../index.php?action=acces_admin');
exit();
}
Bonjour
Je semble me heurter a cette erreur plusieurs fois sans trop savoir d'ou elle vient.
Pouvez-vous m'aider?
[PHP]
<!-- ADD COMMENT FORM -->
<form action="model/add_comment.php" method="post" class="form-example">
<div class="form-example">
<div>
<input type="text" name="PostId" id="PostId" value="{POST_ID}" disabled>
</div>
<div>
<label for="name">Commentaires: </label>
</div>
<div class="form-example">
<label for="name">User Name: </label>
<input type="text" name="UserName" id="UserName" required>
</div>
<div class="form-example input_text">
<textarea name="Comment" id="textarea" required></textarea>
</div>
</div>
<div class="form-example validate">
<input type="submit" value="Ajouter Commentaire: ">
</div>
</form>
[/PHP]
[PHP]
<!-- add_comment.php -->
<?php
require "../config.php";
// DEFINE DATABASE CONNECTION - PDO
try {
$bdd = new PDO('mysql:host=localhost;dbname=' . $Database_Name, $Database_User, $Database_Password);
} catch (\Throwable $e) {
die('Erreur : ' . $e->getMessage());
}
// BOUTON - INSERT TO DATABASE
if ($_SERVER['REQUEST_METHOD'] == "POST" and isset($_POST["UserName"])) {
$UserName = $_POST["UserName"];
$Comment = $_POST["Comment"];
$Valide = "TRUE";
$Post_ID = $_POST["PostId"];
// PREPARE QUERY - use prepare pour les accents sur les lettres
$req = $bdd->prepare("INSERT INTO comments(username, contenu, valide, post_id, date_creation) values (?, ?, ?, ?, NOW()) ");
$req->execute(array($UserName, $Comment, $Valide, $Post_ID));
header('Location: ../index.php?action=acces_admin');
exit();
}
[/PHP]
