Prob prog php
Bonjour a tous,
Voila j'ai fait une page php qui permet d'inserer des champs dans une table mais quand je fais submit il ne se passe rien ou est l'erreur dans mon programme??
<? session_start();?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Document sans nom</title>
</head>
<body>
<form action="<?php print $_SERVER['PHP_SELF'] ?>" method="post">
<div align="center">
<p> </p>
<p align="center">
<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0" width="483" height="33" title="titre">
<param name="BGCOLOR" value="" />
<param name="movie" value="text5.swf" />
<param name="quality" value="high" />
<embed src="text5.swf" quality="high" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="483" height="33" ></embed>
</object>
</p>
<p> </p>
ID_MISC </strong></em>
<input type="int" name="ID_MISC" </input>
AUTEUR </strong></em>
<input type="text" name="AUTEUR" </input>
TITRE </strong></em>
<input type="text" name="TITRE" </input>
AUTEUR </strong></em>
<input type="text" name="AUTEUR" </input>
ANNEE </strong></em>
<input type="int" name="ANNEE" </input>
<br />
<br />
URL_MISC </strong></em>
<input type="text" name="URL_MISC" </input>
RESUME </strong></em>
<input type="text" name="RESUME" </input>
<div align="center"><br />
<br />
<div align="center">
<input type="submit" value="Envoyer"> <input type="reset" value="Annuler">
</div>
</form>
</html>
<?php
if(empty($HTTP_POST_VARS['ID_MISC']) || empty($HTTP_POST_VARS['AUTEUR']) || empty($HTTP_POST_VARS['TITRE']) || empty($HTTP_POST_VARS['MEDIA']) || empty($HTTP_POST_VARS['ANNEE']) || empty($HTTP_POST_VARS['URL_MISC']) || empty($HTTP_POST_VARS['RESUME']))
{
}
else if(($HTTP_POST_VARS['ID_MISC']!= NULL ) && ($HTTP_POST_VARS['AUTEUR'] != NULL) && ($HTTP_POST_VARS['TITRE'] != NULL) && ($HTTP_POST_VARS['MEDIA'] != NULL) && ($HTTP_POST_VARS['ANNEE'] != NULL) && ($HTTP_POST_VARS['URL_MISC'] != NULL) && ($HTTP_POST_VARS['RESUME'] != NULL))
{
$id_misc=$HTTP_POST_VARS['ID_MISC'];
$auteur=$HTTP_POST_VARS['AUTEUR'];
$titre=$HTTP_POST_VARS['TITRE'];
$media=$HTTP_POST_VARS['MEDIA'];
$annee=$HTTP_POST_VARS['ANNEE'];
$url_misc=$HTTP_POST_VARS['URL_MISC'];
$resume=$HTTP_POST_VARS['resume'];
$login=$HTTP_SESSION_VARS['login'];
$pass=$HTTP_SESSION_VARS['pass'];
$connexion = "dbname=postgres user=".$login." password=".$pass." ";
$res = pg_query($connexion , "insert into misc values ('$ID_MISC','$AUTEUR','$TITRE','$MEDIA',$ANNEE,'$URL_MISC','$RESUME')");
echo"insertion realisee";
}
?>
Merci
--
davy
Voila j'ai fait une page php qui permet d'inserer des champs dans une table mais quand je fais submit il ne se passe rien ou est l'erreur dans mon programme??
<? session_start();?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Document sans nom</title>
</head>
<body>
<form action="<?php print $_SERVER['PHP_SELF'] ?>" method="post">
<div align="center">
<p> </p>
<p align="center">
<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0" width="483" height="33" title="titre">
<param name="BGCOLOR" value="" />
<param name="movie" value="text5.swf" />
<param name="quality" value="high" />
<embed src="text5.swf" quality="high" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="483" height="33" ></embed>
</object>
</p>
<p> </p>
ID_MISC </strong></em>
<input type="int" name="ID_MISC" </input>
AUTEUR </strong></em>
<input type="text" name="AUTEUR" </input>
TITRE </strong></em>
<input type="text" name="TITRE" </input>
AUTEUR </strong></em>
<input type="text" name="AUTEUR" </input>
ANNEE </strong></em>
<input type="int" name="ANNEE" </input>
<br />
<br />
URL_MISC </strong></em>
<input type="text" name="URL_MISC" </input>
RESUME </strong></em>
<input type="text" name="RESUME" </input>
<div align="center"><br />
<br />
<div align="center">
<input type="submit" value="Envoyer"> <input type="reset" value="Annuler">
</div>
</form>
</html>
<?php
if(empty($HTTP_POST_VARS['ID_MISC']) || empty($HTTP_POST_VARS['AUTEUR']) || empty($HTTP_POST_VARS['TITRE']) || empty($HTTP_POST_VARS['MEDIA']) || empty($HTTP_POST_VARS['ANNEE']) || empty($HTTP_POST_VARS['URL_MISC']) || empty($HTTP_POST_VARS['RESUME']))
{
}
else if(($HTTP_POST_VARS['ID_MISC']!= NULL ) && ($HTTP_POST_VARS['AUTEUR'] != NULL) && ($HTTP_POST_VARS['TITRE'] != NULL) && ($HTTP_POST_VARS['MEDIA'] != NULL) && ($HTTP_POST_VARS['ANNEE'] != NULL) && ($HTTP_POST_VARS['URL_MISC'] != NULL) && ($HTTP_POST_VARS['RESUME'] != NULL))
{
$id_misc=$HTTP_POST_VARS['ID_MISC'];
$auteur=$HTTP_POST_VARS['AUTEUR'];
$titre=$HTTP_POST_VARS['TITRE'];
$media=$HTTP_POST_VARS['MEDIA'];
$annee=$HTTP_POST_VARS['ANNEE'];
$url_misc=$HTTP_POST_VARS['URL_MISC'];
$resume=$HTTP_POST_VARS['resume'];
$login=$HTTP_SESSION_VARS['login'];
$pass=$HTTP_SESSION_VARS['pass'];
$connexion = "dbname=postgres user=".$login." password=".$pass." ";
$res = pg_query($connexion , "insert into misc values ('$ID_MISC','$AUTEUR','$TITRE','$MEDIA',$ANNEE,'$URL_MISC','$RESUME')");
echo"insertion realisee";
}
?>
Merci
--
davy