Interprétation de variable
bien le bonjour, je travail sur un petit site et j'ai un souci quand a l'interprétation d'une variable voila mon code:
Code:
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
| <?php
include "config.php";
// Include ezSQL core
include_once "./shared/ez_sql_core.php";
// Include ezSQL database specific component
include_once "ez_sql_mysql.php";
$article = 'acceuil';
if ( isset($HTTP_POST_VARS['article']) || isset($HTTP_GET_VARS['article']) )
{
$article = ( isset($HTTP_POST_VARS['article'])) ? $HTTP_POST_VARS['article'] : $HTTP_GET_VARS['article']; //on assigne $article
}
$key = $article;
if(isset($_REQUEST['Nom']) || isset($_REQUEST['e-mail'])){
$Nom = $_POST['Nom'];
$mail = $_POST['e-mail'];
$comm = $_POST['body'];
$db = new ezSQL_mysql($user, $pass, $database, $host);
$sql_comm = "INSERT INTO `commentaires` (`article` ,`Nom` ,`e-mail` ,`commentaire`)VALUES ('$key', '$Nom', '$mail', '$comm');";
$db->query($sql_comm);
echo ($sql_comm);
//header ('Location: comm_aff.php?article='.$article);
} else{
echo ('<html><body>');
echo ('<form action="comm_post.php?article=$article" method="post" name="comm">');
echo ('Nom:<input type="text" name="Nom" size="15" /><br>');
echo ('Mail:<input type="text" name="e-mail" size="15" /><br>');
echo ('Ton texte<br><textarea id="body" name="body" cols="50" rows="5"></textarea><br>');
echo ('<input type="submit" name="sub" value="Envoyer">');
echo ('</form>');
}
echo (' </body>
</html>');
?> |
en exécutant, il me mais dans ma requête (comm_post?article=maroro):
Citation:
INSERT INTO `commentaires` (`article` ,`Nom` ,`e-mail` ,`commentaire`)VALUES ('$article', 'Nom', 'mail', 'mon comm');
Que faire, ou est la faute s'il vous plait?
bien apres quleque recherche suplementaire sa marche, la solution pour les interesser:
Code:
1 2 3 4 5 6 7 8 9 10 11 12
| ...} else{
echo ('<html><body>');
echo ('<form action="comm_post.php?article='.$article.'" method="post" name="comm">');
echo ('Nom:<input type="text" name="Nom" size="15" /><br>');
echo ('Mail:<input type="text" name="e-mail" size="15" /><br>');
echo ('Ton texte<br><textarea id="body" name="body" cols="50" rows="5"></textarea><br>');
echo ('<input type="submit" name="sub" value="Envoyer">');
echo ('</form>');
}
echo (' </body>
</html>');
?> |