142 lines
2.8 KiB
HTML
Executable File
142 lines
2.8 KiB
HTML
Executable File
<?php
|
|
session_start();
|
|
?>
|
|
|
|
<html>
|
|
<head>
|
|
<title>
|
|
Ajout des donnees dans la base
|
|
</title>
|
|
</head>
|
|
|
|
<body>
|
|
<div align="center">
|
|
<table>
|
|
<?php
|
|
/*
|
|
require("../connexion.php");
|
|
$conn = mysql_connect($host, $user, $password);
|
|
mysql_select_db($bdd) or die("Impossible d'ouvrir la base de donnee $bdd");
|
|
|
|
$requete = "select idcateg, nomcateg, descriptioncateg,photocateg from categorie";
|
|
$result=mysql_query($requete) or die ("Erreur SQL :$requete<br>".mysql_error()."...");
|
|
$i=0;
|
|
while ($ligne=mysql_fetch_row($result))
|
|
{
|
|
$i++;
|
|
$idcateg=$ligne[0];
|
|
$nom=$ligne[1];
|
|
$desc=$ligne[2];
|
|
$photo=$ligne[3];
|
|
}
|
|
|
|
switch($action)
|
|
{
|
|
case "ajouter":
|
|
|
|
require("../connexion.php");
|
|
$conn = mysql_connect($host, $user, $password);
|
|
mysql_select_db($bdd) or die("Impossible d'ouvrir la base de donnee $bdd");
|
|
|
|
if ($creertable)
|
|
{
|
|
$query = "CREATE TABLE $table( nom varchar(24),prenom varchar(24) )";
|
|
$result= MYSQL_QUERY($query);
|
|
}
|
|
|
|
if (file_exists($fichier))
|
|
{
|
|
$fp = fopen("$fichier", "r");
|
|
}
|
|
else
|
|
{
|
|
echo "Fichier introuvable !<br>Importation stoppée.";
|
|
exit();
|
|
}
|
|
|
|
while (!feof($fp))
|
|
{
|
|
$ligne = fgets($fp,4096); /* On lit une ligne */
|
|
|
|
$liste = explode( ";",$ligne);
|
|
|
|
$nom = $liste[0];
|
|
$prenom = $liste[1];
|
|
|
|
$query = "INSERT INTO $table VALUES('$nom','$prenom')";
|
|
$result= MYSQL_QUERY($query);
|
|
|
|
if(mysql_error())
|
|
{
|
|
print "<br>Importation stoppée.";
|
|
exit();
|
|
}
|
|
else
|
|
print "$nom $prenom <br>";
|
|
}
|
|
|
|
echo "<br>Importation terminée, avec succès.";
|
|
|
|
fclose($fp);
|
|
MYSQL_CLOSE();
|
|
break;
|
|
|
|
|
|
|
|
default:
|
|
?>
|
|
<? echo "<form method=\"post\" action=\"$PHP_SELF\">"; ?>
|
|
Pour ajouter ton serveur il suffit de remplir ce formulaire
|
|
<table border="0" cellspacing="0" cellpadding="3">
|
|
<tr>
|
|
<td>Table :</td>
|
|
<td> <input type="text" name="table"> </td>
|
|
</tr>
|
|
<tr>
|
|
<td>Fichier :</td>
|
|
<td> <input type="text" name="fichier"> </td>
|
|
</tr>
|
|
<tr>
|
|
<td>Créer table ? :</td>
|
|
<td> <input type="checkbox" name="creertable" checked> </td>
|
|
</tr>
|
|
<tr>
|
|
<td></td>
|
|
<td> <input type="submit" name="submit" value="Et HoP !"> </td>
|
|
</tr>
|
|
</table>
|
|
<input type="hidden" name="action" value="ajouter">
|
|
</form>
|
|
<?
|
|
break;
|
|
|
|
}
|
|
|
|
?>
|
|
|
|
</body>
|
|
</html>
|
|
</pre>
|
|
</pre>
|
|
<p>
|
|
</ul>
|
|
<CENTER>
|
|
<IMG SRC="//www.infres.enst.fr/~danzart/images/rainbolg.gif" border=0>
|
|
<P>
|
|
<A href="exempleCD.html ">Un exemple commenté</A>
|
|
<P>
|
|
<IMG SRC="//www.infres.enst.fr/~danzart/images/rainbolg.gif" border=0>
|
|
<P>
|
|
<font size=-1> mai 2000 ©
|
|
<A HREF="mailto:Annie.Danzart@inf.enst.fr">Annie.Danzart</A> pour l'enst<BR>
|
|
</CENTER>
|
|
|
|
</BODY>
|
|
</HTML>
|
|
|
|
|
|
?>
|
|
</body>
|
|
</html>
|
|
|