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 34 35 36 37 38 39 40 41 42 43 44 45 46 47
|
echo "<br>";
echo "<br>";
echo "<table><tr><td valign=top>";
echo "Choisir une table : ";
echo"</td><td valign=top>";
echo "<form method=post name=form1>";
echo "<select name=liste1>";
echo "<option value=administrateur>administrateur</option>";
echo "<option value=agent>agent</option>";
echo "<option value=materiel>materiel</option>";
echo "<option value=logiciels>logiciels</option>";
echo "</select>";
echo "</td></tr>";
echo "<tr><td>";
echo "Nom du nouveau champ";
echo"</td><td valign=top>";
echo "<input type=text name=champ>";
echo "</td></tr>";
echo "<tr><td>";
echo "choisir le caractère :";
echo"</td><td valign=top>";
echo "<select name=liste2>";
echo "<option value=varchar(25)>Varchar(25)</option>";
echo "<option value=int>int</option>";
echo "<option value=date>Date</option>";
echo "</select>";
echo "</td></tr>";
echo "<tr><td>";
echo "choisir le \"NULL\" :";
echo"</td><td valign=top>";
echo "<select name=liste3>";
echo "<option value=notnull>NOTNULL</option>";
echo "<option value=nul>null</option>";
echo "</select>";
echo "</td></tr>";
echo "<tr><td colspan=2>";
echo "<input type=submit name=Envoyer>";
echo "</tr>";
echo "</form>";
echo"</table>";
$table = $_POST['liste1'];
$champ = $_POST['champ'];
$caractere = $_POST['liste2'];
$null = $_POST['liste3'];
$rsql6 =" alter table $table ADD $champ $caractere $null";
$req6 = mysql_query($rsql6) or die('Erreur SQL !'.$rsql6.'<br>'.mysql_error()); |
Partager