esse que ceci est bien ecrit :
if(isset($_POST['pseudo']) and isset($_POST['mess']))
Voila le code en entier
<html>
<head>
<title> testp </title>
<link rel="stylesheet" media="screen" type="text/css" title="blue" href="sombre.css"/>
</head>
<body>
<form action="testmysql.php" method="POST"><p>
Pseudo <input type="text" name="pseudo"/></br>
Message <input type="text" name="mess"/></P>
</form>
<?
if(isset($_POST['pseudo']) and isset($_POST['mess']))
{
$pseudo=$_post['pseudo'];
$mess=$_post['mess'];
mysql_connect("localhost","root");
mysql_select_db("exercice");
mysql_query(Insert into chat value("";"$mess";"$pseudo")
}
else
{
echo "entrer votre pseudo et votre message";
}
mysql_close();
?>
<p>t'chat</p>
<?
mysql_connect("localhost","root");
mysql_select_db("exercice");
$chat=mysql_query(select * from chat order by id);
while($text=mysql_fetch_array($chat))
{
echo $text['pseudo'] ."ecrit". $text['mess'];
}
Mysql_close();
?>
</body>
<html>
la communauté d'entraide francophone dédiée au PHP
si variable existe...
Tu y étais presque: fais attention quand tu envoies du SQL à séparer le SQL du PHP : voici un corrigé express:
<html>
<head>
<title> testp </title>
<link rel="stylesheet" media="screen" type="text/css" title="blue" href="sombre.css"/>
</head>
<body>
<form action="testmysql.php" method="POST"><p>
Pseudo <input type="text" name="pseudo"/></br>
Message <input type="text" name="mess"/></P>
</form>
<?
if(isset($_POST['pseudo']) and isset($_POST['mess']))
{
$pseudo=$_post['pseudo'];
$mess=$_post['mess'];
mysql_connect("localhost","root");
mysql_select_db("exercice");
mysql_query("Insert into chat value('','". $mess ."','". $pseudo .";");
}
else
{
echo "entrer votre pseudo et votre message";
}
mysql_close();
?>
<p>t'chat</p>
<?
mysql_connect("localhost","root");
mysql_select_db("exercice");
$chat=mysql_query("select * from chat order by id");
while($text=mysql_fetch_array($chat))
{
echo $text['pseudo'] ."ecrit". $text['mess'];
}
mysql_close();
?>
</body>
<html>Codez en pensant que celui qui maintiendra votre code est un psychopathe qui connait votre adresse 
cela ne marche tjr pas :|
j ai réusie a coriger avan de lire ton message pour le s1er et voissie une nouvel erreur! erreur ligne: 29 : $chat=mysql_query(select * from chat
order by id limit 0,9);
---------------------------------
code:
<html>
<head>
<title> testp </title>
<link rel="stylesheet" media="screen" type="text/css" title="blue" href="sombre.css"/>
</head>
<body>
<form action="testmysql.php" method="POST"><p>
Pseudo <input type="text" name="pseudo"/></br>
Message <input type="text" name="mess"/></P>
</form>
<?
if(isset($_POST['pseudo']) and isset($_POST['mess']))
{
if($_POST['pseudo'] != null and $_POST['mess'] != null)
{
mysql_connect("localhost","root");
mysql_select_db("exercice");
$pseudo=htmlentities($_post['pseudo']);
$mess=htmlentities($_post['mess']);
mysql_query("Insert into chat value('','$mess','$pseudo'");
mysql_close();
}
}
?>
<p>t'chat</p>
<?
mysql_connect("localhost","root");
mysql_select_db("exercice");
$chat=mysql_query(select * from chat order by id limit 0,9);
while($text=mysql_fetch_array($chat))
{
?><p><?echo $text['pseudo'];?> ecrit <?echo $text['mess'];?><?
}
Mysql_close();
?>
</body>
<html>
j ai réusie a coriger avan de lire ton message pour le s1er et voissie une nouvel erreur! erreur ligne: 29 : $chat=mysql_query(select * from chat
order by id limit 0,9);
---------------------------------
code:
<html>
<head>
<title> testp </title>
<link rel="stylesheet" media="screen" type="text/css" title="blue" href="sombre.css"/>
</head>
<body>
<form action="testmysql.php" method="POST"><p>
Pseudo <input type="text" name="pseudo"/></br>
Message <input type="text" name="mess"/></P>
</form>
<?
if(isset($_POST['pseudo']) and isset($_POST['mess']))
{
if($_POST['pseudo'] != null and $_POST['mess'] != null)
{
mysql_connect("localhost","root");
mysql_select_db("exercice");
$pseudo=htmlentities($_post['pseudo']);
$mess=htmlentities($_post['mess']);
mysql_query("Insert into chat value('','$mess','$pseudo'");
mysql_close();
}
}
?>
<p>t'chat</p>
<?
mysql_connect("localhost","root");
mysql_select_db("exercice");
$chat=mysql_query(select * from chat order by id limit 0,9);
while($text=mysql_fetch_array($chat))
{
?><p><?echo $text['pseudo'];?> ecrit <?echo $text['mess'];?><?
}
Mysql_close();
?>
</body>
<html>
Tu as toujours la même erreur dans cette ligne: compare ton fichier et ce que j'ai envoyé tout à l'heure pour cette ligne: tu n'as pas isolé le PHP du SQL. Donc tu as une erreur parce que PHP ne reconnait pas le langage SQL
Codez en pensant que celui qui maintiendra votre code est un psychopathe qui connait votre adresse
comme ceci
<html>
<head>
<title> testp </title>
<link rel="stylesheet" media="screen" type="text/css" title="blue" href="sombre.css"/>
</head>
<body>
<form action="testmysql.php" method="POST"><p>
Pseudo <input type="text" name="pseudo"/></br>
Message <input type="text" name="mess"/>
<input type="submit"/></P>
</form>
<?
if(isset($_POST['pseudo']) and isset($_POST['mess']))
{
if($_POST['pseudo'] != null and $_POST['mess'] != null)
{
$pseudo=htmlentities($_post['pseudo']);
$mess=htmlentities($_post['mess']);
mysql_connect("localhost","root");
mysql_select_db("exercice");
mysql_query("Insert into chat value('','$mess','$pseudo'");
mysql_close();
}
}
?>
<p>t'chat</p>
<?
mysql_connect("localhost","root");
mysql_select_db("exercice");
$chat=mysql_query("select * from chat order by id limit 0,9");
Mysql_close();
while($text=mysql_fetch_array($chat))
{
?><p><?echo $text['pseudo'];?> ecrit <?echo $text['mess'];?><?
}
?>
</body>
<html>
<html>
<head>
<title> testp </title>
<link rel="stylesheet" media="screen" type="text/css" title="blue" href="sombre.css"/>
</head>
<body>
<form action="testmysql.php" method="POST"><p>
Pseudo <input type="text" name="pseudo"/></br>
Message <input type="text" name="mess"/>
<input type="submit"/></P>
</form>
<?
if(isset($_POST['pseudo']) and isset($_POST['mess']))
{
if($_POST['pseudo'] != null and $_POST['mess'] != null)
{
$pseudo=htmlentities($_post['pseudo']);
$mess=htmlentities($_post['mess']);
mysql_connect("localhost","root");
mysql_select_db("exercice");
mysql_query("Insert into chat value('','$mess','$pseudo'");
mysql_close();
}
}
?>
<p>t'chat</p>
<?
mysql_connect("localhost","root");
mysql_select_db("exercice");
$chat=mysql_query("select * from chat order by id limit 0,9");
Mysql_close();
while($text=mysql_fetch_array($chat))
{
?><p><?echo $text['pseudo'];?> ecrit <?echo $text['mess'];?><?
}
?>
</body>
<html>
c'est bon mais il rest un problem !
dans mon t chat tout les mesages avec un ' un . ou des signe bizare n'aparai pas
que fair?
voila le code
<html>
<head>
<title> testp </title>
<link rel="stylesheet" media="screen" type="text/css" title="blue" href="sombre.css"/>
</head>
<body>
<form action="testmysql.php" method="POST"><p>
Pseudo <input type="text" name="pseudo"/></br>
Message <input type="text" name="mess"/>
<input type="submit"/></P>
</form>
<?
if(isset($_POST['pseudo']) and isset($_POST['mess']))
{
if($_POST['pseudo'] != null and $_POST['mess'] != null)
{
$pseudo=htmlentities($_POST['pseudo']);
$mess=htmlentities($_POST['mess']);
mysql_connect("localhost","root");
mysql_select_db("exercice");
mysql_query("Insert into chat value('','". $mess ."','". $pseudo ."')");
mysql_close();
}
}
?>
<p>t'chat</p>
<?
mysql_connect("localhost","root");
mysql_select_db("exercice");
$chat=mysql_query("select * from chat order by id desc limit 0,9");
Mysql_close();
while($text=mysql_fetch_array($chat))
{
?><p><?echo $text['pseudo'];?> ecrit <?echo $text['mess'];?><?
}
?>
</body>
<html>
dans mon t chat tout les mesages avec un ' un . ou des signe bizare n'aparai pas
que fair?
voila le code
<html>
<head>
<title> testp </title>
<link rel="stylesheet" media="screen" type="text/css" title="blue" href="sombre.css"/>
</head>
<body>
<form action="testmysql.php" method="POST"><p>
Pseudo <input type="text" name="pseudo"/></br>
Message <input type="text" name="mess"/>
<input type="submit"/></P>
</form>
<?
if(isset($_POST['pseudo']) and isset($_POST['mess']))
{
if($_POST['pseudo'] != null and $_POST['mess'] != null)
{
$pseudo=htmlentities($_POST['pseudo']);
$mess=htmlentities($_POST['mess']);
mysql_connect("localhost","root");
mysql_select_db("exercice");
mysql_query("Insert into chat value('','". $mess ."','". $pseudo ."')");
mysql_close();
}
}
?>
<p>t'chat</p>
<?
mysql_connect("localhost","root");
mysql_select_db("exercice");
$chat=mysql_query("select * from chat order by id desc limit 0,9");
Mysql_close();
while($text=mysql_fetch_array($chat))
{
?><p><?echo $text['pseudo'];?> ecrit <?echo $text['mess'];?><?
}
?>
</body>
<html>