Voilà mon code principal:
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<DIV ID="divHaut" STYLE="position: absolute; z-index: 10; visibility: visible; left: 200px; top: 90px;">
<body bgcolor="#FFFFFF" text="#FFFFFF" background="fond_d_ecran.jpg" bgproperties="fixed">
<br><br><br>
<? include ("fonction.php"); ?>
<? if (!empty($btn_recherche))
$var = "0";
//else (empty($btn_rechercher))
//$var = "1";
?>
<form method="post" action="form_eleves.php">
<center> <table cellpadding=20> </center>
<tr>
<td>
<table>
<tr>
<td> <p>Nom :</p></td>
<td> <input type="text" name="Valeur_input[1]" size="30"> </td>
</tr>
<tr>
<td> <p>Prénom :</p> </td>
<td> <input type="text" name="Valeur_input[2]" size="30"> </td>
</tr>
<tr>
<td> <p>Adresse :</p> </td>
<td> <input type="text" name="Valeur_input[3]" size="30"> </td>
</tr>
<tr>
<td> <p>NPA :</p> </td>
<td> <input type="text" name="Valeur_input[4]" size="30"> </td>
</tr>
<tr>
<td> <p>Lieu :</p> </td>
<td> <input type="text" name="Valeur_input[5]" size="30"> </td>
</tr>
<tr>
<td> <p>Métier :</p> </td>
<td> <input type="text" name="Valeur_input[6]" size="30"> </td>
</tr>
<tr>
<td> <p>Ecole :</p> </td>
<td> <input type="text" name="Valeur_input[7]" size="30"> </td>
</tr>
<tr>
<td> <p>Classe :</p> </td>
<td> <input type="text" name="Valeur_input[8]" size="30"> </td>
</tr>
<tr>
<td> <p>Salle :</p> </td>
<td> <input type="text" name="Valeur_input[9]" size="30"> </td>
</tr>
<tr>
<td> <p>Bâtiment :</p> </td>
<td> <input type="text" name="Valeur_input[10]" size="30"> </td>
</tr>
<tr>
<td> <p>Responsable :</p> </td>
<td> <input type="text" name="Valeur_input[11]" size="30"> </td>
</tr>
<tr>
<td> <p>Durée d'apprentissage :</p> </td>
<td> <input type="text" name="Valeur_input[12]" size="30"> </td>
<tr>
<td> </td>
<td align=center>
<input type="submit" value="Rechercher" name="btn_recherche">
<input type="submit" value="Modifier" name="btn_modifie">
</td>
</tr>
<tr>
<td>
</td>
<td align=center>
<input type="reset" value="Effacer" name="btn_efface">
</td>
</tr>
</table>
</td>
<td>
<?
if ($var == "0")
{
include ("code.php");
}
?>
</td>
</tr>
</table>
</form>
</DIV>
</body>
</html>
mon code code.php:
<?
if (isset($Valeur_input[1]))
{
$query = "SELECT bd_eleve.*, bd_eleve_1.Nom, bd_eleve_1.Prenom FROM bd_eleve LEFT JOIN bd_eleve AS bd_eleve_1 ON bd_eleve.Responsable = bd_eleve_1.Initial " ;
$query_where = "";
$Nom_input[1] = "Nom";
$Nom_input[2] = "Prenom";
$Nom_input[3] = "Adresse";
$Nom_input[4] = "NPA";
$Nom_input[5] = "Lieu";
$Nom_input[6] = "Metier";
$Nom_input[8] = "Classe";
$Nom_input[7] = "Ecole";
$Nom_input[9] = "Salle";
$Nom_input[10] = "Batiment";
$Nom_input[11] = "Responsable";
$Nom_input[12] = "Duree_apprentissage";
$filter_on= FALSE;
for ($i=1; $i<13; $i++)
{
if (strlen($Valeur_input[$i])!=0)
{
$donnee_intermediaire = "bd_eleve.".$Nom_input[$i];
$query_where .= "and ($donnee_intermediaire like '".$Valeur_input[$i]."%')";
}
}
if (strlen($query_where)!=0)
{
$filter_on= TRUE;
}
if ($filter_on)
{
$query_where=substr($query_where,4,300);
$query .= "WHERE ".$query_where . " ORDER BY bd_eleve.Nom, bd_eleve.Prenom;";
$connection = odbc_connect("bd_eleve", "ltsi" ,"ltsi");
$result = odbc_do($connection,$query);
echo "<center> <b> <font size=5 face=Arial> Résultat de la recherche </font> </b> </center> <br> <br>";
while(odbc_fetch_into($result, &$fields))
{
echo "<table>";
echo "<tr>";
echo "<td> <p align=left> Nom :</p> </td>";
echo "<td> <strong> $fields[6] $fields[7] <br>\n </strong> </td>";
echo "</tr>";
//echo "<tr>";
//echo "<td> <P align=left>Adresse :</p> </td>";
//echo "<td width=200> $fields[8] <br>\n </td>";
//echo "</tr>";
//echo "<tr>";
//echo "<td> <p align=left>Localité :</p> </td>";
//$fields[9]=substr($fields[9],0,4);
//echo "<td width=200> $fields[9] $fields[10] <br>\n </td>";
//echo "</tr>";
//echo "<tr>";
//echo "<td> <p align=left>Métier:</p> </td>";
//echo "<td width=200> $fields[1] <br>\n </td>";
//echo "</tr>";
//echo "<tr>";
//echo "<td> <p align=left>Ecole </p> </td>";
//echo "<td width=200> $fields[3] <br>\n </td>";
//echo "</tr>";
//echo "<tr>";
//echo "<td> <p align=left>Classe :</p> </td>";
//echo "<td width=200> $fields[2] $fields[15] $fields[4] <br>\n </td>";
//echo "</tr>";
//echo "<tr>";
//echo "<td> <p align=left>Salle :</p> </td>";
//echo "<td width=200> $fields[11] <br>\n </td>";
//echo "</tr>";
//echo "<tr>";
//echo "<td> <p align=leftt>Bâtiment :</p> </td>";
//echo "<td width=200> $fields[13] <br>\n </td>";
//echo "</tr>";
//echo "<tr>";
//echo "<td> <p align=left>Responsable :</p> </td>";
//echo "<td width=200> $fields[17] $fields[18] <br>\n </td>";
//echo "</tr>";
//echo "<tr>";
//echo "<td> <p align=left>Durée d'apprentissage :</p> </td>";
//echo "<td width=200> $fields[16] <br>\n </td>";
//echo "</tr>";
echo "</table> <br>";
}
odbc_close($connection);
}
}
?>
et mon code fonction.php:
<?
if (isset($Valeur_input[1]))
{
$query = "SELECT bd_eleve.*, bd_eleve_1.Nom, bd_eleve_1.Prenom FROM bd_eleve LEFT JOIN bd_eleve AS bd_eleve_1 ON bd_eleve.Responsable = bd_eleve_1.Initial " ;
$query_where = "";
$Nom_input[1] = "Nom";
$Nom_input[2] = "Prenom";
$Nom_input[3] = "Adresse";
$Nom_input[4] = "NPA";
$Nom_input[5] = "Lieu";
$Nom_input[6] = "Metier";
$Nom_input[8] = "Classe";
$Nom_input[7] = "Ecole";
$Nom_input[9] = "Salle";
$Nom_input[10] = "Batiment";
$Nom_input[11] = "Responsable";
$Nom_input[12] = "Duree_apprentissage";
$filter_on= FALSE;
for ($i=1; $i<13; $i++)
{
if (strlen($Valeur_input[$i])!=0)
{
$donnee_intermediaire = "bd_eleve.".$Nom_input[$i];
$query_where .= "and ($donnee_intermediaire like '".$Valeur_input[$i]."%')";
}
}
if (strlen($query_where)!=0)
{
$filter_on= TRUE;
}
if ($filter_on)
{
$query_where=substr($query_where,4,300);
$query .= "WHERE ".$query_where . " ORDER BY bd_eleve.Nom, bd_eleve.Prenom;";
$connection = odbc_connect("bd_eleve", "ltsi" ,"ltsi");
$result = odbc_do($connection,$query);
while(odbc_fetch_into($result, &$fields))
{
$Valeur_input[1]=$fields[6];
$Valeur_input[2]=$fields[7];
$Valeur_input[3]=$fields[8];
$fields[9]=substr($fields[9],0,4);
$Valeur_input[4]=$fields[9];
$Valeur_input[5]=$fields[10];
$Valeur_input[6]=$fields[1];
$Valeur_input[7]=$fields[2] $fields[3];
$Valeur_input[8]=$fields[2] $fields[15] $fields[4];
$Valeur_input[9]=$fields[11];
$Valeur_input[10]=$fields[13];
$Valeur_input[11]=$fields[17] $fields[18];
$Valeur_input[12]=$fields[16];
}
odbc_close($connection);
}
}
?>
kesk'y ne joue pas??
Css input type est
