Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <script language="javascript" src="scripts.js"></script>
- <?php
- require_once("connexion.php");
- function enregistrer(){
- $codeU=$_POST['codeU'];
- $pass=$_POST['pass'];
- $nom=$_POST['nom'];
- $prenom=$_POST['prenom'];
- //Upload de la photo
- $rep="Photos/";
- $tmp = $_FILES['photo']['tmp_name'];
- $fichier= $_FILES['photo']['name'];
- $extension=strrchr($fichier,'.');
- @move_uploaded_file($tmp,$rep.$codeU.$extension);
- // Enlever le fichier temporaire chargé
- @unlink($tmp); //effacer le fichier temporaire
- $photo=$codeU.$extension;
- $req = "INSERT INTO infomembres VALUES ('$codeU','$nom','$prenom','$photo')";
- mysql_query($req) or die("Echec en insertion");
- $req = "INSERT INTO connexion VALUES ('$codeU','$pass')";
- mysql_query($req) or die("Echec en insertion");
- echo "BRAVO membre $prenom,$nom bien enregistre";
- }
- function lister(){
- $req = "SELECT * FROM infomembres ORDER BY nom";
- $res = mysql_query($req) or die("Echec de la requête lister");
- echo "<table border=1>";
- while ($ligne = mysql_fetch_array($res))
- {
- echo "<tr>";
- echo "<td>".$ligne['codeusager']."</td>";
- echo "<td>".$ligne['nom']."</td>";
- echo "<td>".$ligne['prenom']."</td>";
- echo "<td><img onMouseOver=\"redimensionner(this,1)\"; onMouseOut=\"redimensionner(this,2)\";width=\"80\" height=\"80\" src=\"Photos/".$ligne['photo']."\"\/></td>";
- echo "</tr>";
- }
- echo "</table>";
- /* Libération du résultat */
- mysql_free_result($res);
- }
- function enlever(){
- $codeUE=$_POST['codeUE'];
- $req = "DELETE FROM infomembres WHERE codeusager='$codeUE'";
- mysql_query($req) or die("Echec en enlever dans la table infomembres");
- $req = "DELETE FROM connexion WHERE codeusager='$codeUE'";
- mysql_query($req) or die("Echec en enlever dans la table connexion");
- echo "Membre $codeUE est retire avec succes";
- }
- function envoyerForm($res,$resCon){
- $codeusager=$res['codeusager'];
- $nom=$res['nom'];
- $prenom=$res['prenom'];
- $pass=$resCon['pass'];
- echo "<h2>Formulaire membre MISE A JOUR</h2>\n";
- echo "<form id=\"formMembMAJ\" name=\"formMembMAJ\" ENCTYPE=\"multipart/form-data\" action=\"gestionnaire.php\" method=\"post\">\n";
- echo "Code Usager : <input type=\"text\" id=\"codeUMAJ\" name=\"codeUMAJ\" value=\"$codeusager\"/><br><br>\n";
- echo "Mot passe : <input type=\"password\" id=\"passMAJ\" name=\"passMAJ\" value=\"$pass\"/><br><br>\n";
- echo "Confirmer passe : <input type=\"password\" id=\"cpassMAJ\" name=\"cpassMAJ\"value=\"$pass\"/><br><br>\n";
- echo "Nom : <input type=\"text\" id=\"nomMAJ\" name=\"nomMAJ\" value=\"$nom\"/><br><br>\n";
- echo "Prenom : <input type=\"text\" id=\"prenomMAJ\" name=\"prenomMAJ\"value=\"$prenom\"/><br><br>\n";
- echo "Photo : <input type=\"file\" id=\"photo\" name=\"photo\"/><br><br>";
- echo "<input type=\"hidden\" id=\"action\" name=\"action\" value=\"modifier\"/>\n";
- echo "<input type=\"hidden\" id=\"option\" name=\"option\" value=\"miseAjour\"/>\n";
- echo "<input type=\"button\" value=\"Valider\" onClick=\"validerMAJ()\"/> \n";
- echo "</form>\n";
- }
- function trouver(){
- $codeUM=$_POST['codeUM'];
- $req = "SELECT * FROM infomembres WHERE codeusager='$codeUM'";
- $res = mysql_query($req) or die("Echec de la requête trouver");
- $ligne = mysql_fetch_array($res);
- if (mysql_num_rows($res)>0){
- $req = "SELECT * FROM connexion WHERE codeusager='$codeUM'";
- $resCon = mysql_query($req) or die("Echec de la requête trouver");
- $ligneCon = mysql_fetch_array($resCon);
- envoyerForm($ligne,$ligneCon);
- }
- }
- function mettreAjour(){
- $codeU=$_POST['codeUMAJ'];
- $pass=$_POST['passMAJ'];
- $nom=$_POST['nomMAJ']; echo "LE NOM =".$nom;
- $prenom=$_POST['prenomMAJ'];
- //Upload de la photo
- $rep="Photos/";
- $upPhoto=false;
- if (isset($_FILES['photo']['tmp_name'])){
- //Récuperer ancienne photo et l'effacer
- $req="SELECT * FROM infomembres WHERE codeusager='$codeU'"; //recherche de l'étudiant
- $liste=mysql_query($req) or die("Echec modifier");
- $ligne = mysql_fetch_array($liste);
- if (file_exists($rep.$ligne['photo']))
- @unlink($rep.$ligne['photo']); //effacer photo
- //Upload de la nouvelle photo
- $tmp = $_FILES['photo']['tmp_name'];
- $fichier= $_FILES['photo']['name'];
- $extension=strrchr($fichier,'.');
- @move_uploaded_file($tmp,$rep.$codeU.$extension);
- // Enlever le fichier temporaire chargé
- @unlink($tmp); //effacer le fichier temporaire
- $photo=$codeU.$extension;
- $upPhoto=true;
- }
- if ($upPhoto==true)
- $req="UPDATE infomembres SET codeusager='$codeU',nom='$nom',prenom='$prenom',photo='$photo' WHERE codeusager='$codeU'";
- else
- $req="UPDATE infomembres SET codeusager='$codeU',nom='$nom',prenom='$prenom' WHERE codeusager='$codeU'";
- mysql_query($req) or die("Echec de la requête MAJ");
- $req="UPDATE connexion SET codeusager='$codeU',pass='$pass' WHERE codeusager='$codeU'";
- mysql_query($req) or die("Echec de la requête MAJ");
- }
- function connexion(){
- $code=$_POST['codeC'];
- $pass=$_POST['passC'];
- $req = "SELECT * FROM connexion WHERE codeusager='$code' AND pass='$pass'";
- $res = mysql_query($req) or die("Echec de la requête lister");
- if (mysql_num_rows($res) > 0)
- header('Location: pageMembre.html');
- else
- echo "Probleme de connexion pour $code";
- }
- //Notre controleur
- $action=$_POST['action'];
- switch($action){
- case "enregistrer" :
- enregistrer();
- break;
- case "connexion" :
- connexion();
- break;
- case "lister" :
- lister();
- break;
- case "enlever" :
- enlever();
- break;
- case "modifier" :
- $option=$_POST['option'];
- if ($option=="trouver")
- trouver();
- else //option == miseAjour
- mettreAjour();
- break;
- }//fin du switch
- mysql_close($con);
- echo "<br><br><a href='gestionMembre.html'>Retour au formulaire</a>";
- ?>
- <div id="divPhoto" style="visibility:hidden;position:absolute;top:20%;left:50%">
- <img id="photoDiv" src="" width="400" height="400"/>
- </div>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement