Problème transfert donnees entre 2 formulaires php.
Formulaire entree : testentree.php
Formulaire sortie : testresult.php
<b>testentree.php : </b>
----------------------------
<HTML>
<HEAD>
<TITLE> Entree requete MySQL sous PHP </TITLE>
<META http-equiv="content-type" content="text/html; charset=iso-8859-1" />
</HEAD>
<BODY>
<!-- testentree.php -->
<?php
$serveur="localhost";
$login="pgil";
$pass="aip";
?>
<FORM ACTION= "testresult.php" METHOD=POST>
CHOISIR LA BASE POUR LA REQUETE SQL :
<BR><BR>
<SELECT NAME="database" SIZE=1 >
<?php
echo ("boucle test entree");
mysql_connect($serveur,$login,$pass);
$db_table = mysql_list_dbs();
for ($i = 0; $i < mysql_num_rows($db_table);$i++)
{
echo ("<OPTION>" . mysql_tablename($db_table,$i));
}
?>
</SELECT>
<BR><HR>
ENTRER LA REQUETE A EXECUTER :
<BR><BR>
<TEXTAREA NAME="req" COLS=50 ROWS=10> </TEXTAREA>
<BR><BR>
<INPUT TYPE=SUBMIT VALUE="LANCER LA REQUETE" NAME="param">
</FORM>
</BODY>
</HTML>
---
<b>testresult.php : </b>
----------------------------
<HTML>
<HEAD>
<TITLE> Resultat de Entree requete MySQL sous PHP </TITLE>
<META http-equiv="content-type" content="text/html; charset=iso-8859-1" />
</HEAD>
<BODY>
<!-- testresult.php -->
<?php
$serveur="localhost";
$login="pgil";
$pass="aip";
// Recuperer parametres passes par Action = POST
$recup = $_POST["param"];
if (!empty($recup)) {
echo ($recup);
$database = trim($_POST["database"]);
$req = trim($_POST["req"]);
echo ("Database = " . $database);
echo ("Requete = " . $req);
}
echo (" TEST AFF. TestResult 1");
echo ("<BR><BR>");
echo (" TEST AFF. TestResult 2");
mysql_connect($serveur,$login,$pass);
echo ("Database = " . $database);
mysql_select_db($database);
echo ("<BR><BR>");
echo (" TEST AFF. TestResult 3");
echo ("Requete = " . $req);
$result = mysql_query($req);
echo ("<BR><BR>");
echo (" TEST AFF. TestResult 4");
?>
<HR><BR>
<FORM ACTION= "testentree.php" METHOD=POST>
<INPUT TYPE=SUBMIT VALUE="NOUVELLE REQUETE">
</FORM>
</BODY>
</HTML>
---------
<b>Environnement travail : </b>
--------------------------------------
Register_Globals = On
Utilisation methode POST
2 parametres passes database et req via variable param.
Tester via php -q fichier php
<b>Questions : </b>
------------------------
Undefined index sur $_POST["variable] , surprenant !!!
Variables database et req non definis dans testresult !!!
Merci d'avance pour reponses.
