Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- include('../pages/connexion_bdd.php');
- //Champs du formulaire
- $nom = $_POST['nom_conducteur'];
- $prenom = $_POST['prenom_conducteur'];
- //Pas d'image par défaut
- $fileName = null;
- $tmpName = null;
- $fileSize = null;
- $fileType = null;
- $content = null;
- //Récupération du fichier uploadé
- if(isset($_FILES['userfile']) && isset($_FILES['userfile']['tmp_name']) && !empty($_FILES['userfile']['tmp_name'])) {
- //exit;
- $tmpName = $_FILES['userfile']['tmp_name'];
- $fp = fopen($tmpName, 'r');
- $content = fread($fp, filesize($tmpName));
- $content = addslashes($content);
- fclose($fp);
- $fileName = $_FILES['userfile']['name'];
- $fileSize = $_FILES['userfile']['size'];
- $fileType = $_FILES['userfile']['type'];
- if(!get_magic_quotes_gpc())
- $fileName = addslashes($fileName);
- }
- $id = $_POST['modif_hidden'];
- // $id = 0;
- if(isset($id))
- {
- $extraSQL = "";
- $extraArray = array ();
- $updateArray = array (
- ':nom' => $nom,
- ':prenom' => $prenom
- );
- if($fileSize > 0) {
- $extraSQL = $connection->prepare("UPDATE fichiers_interventions SET fic_name = :name, fic_size = :size, fic_type = :type, fic_content = :content WHERE ID_conducteur = '{$id}'");
- $extraArray = array (
- ':name' => $fileName,
- ':size' => $fileSize,
- ':type' => $fileType,
- ':content' => $content
- );
- $updateArray = array_merge($updateArray, $extraArray);
- }
- $sql = $connection->prepare("UPDATE conducteurs SET nom = :nom, prenom = :prenom, date_maj = NOW() WHERE ID_conducteur = '{$id}'");
- $sql->execute($updateArray);
- } else {
- //Préparation de la requête avant exécution
- $req = $connection->prepare('INSERT INTO conducteurs(nom, prenom, date_creation) VALUES (:nom, :prenom, NOW())') or exit(print_r($bdd->errorInfo()));
- $req->execute(array(
- 'nom' => $nom,
- 'prenom' => $prenom,
- ));
- $lastID = $connection->lastInsertId();
- $req_fic = $connection->prepare('INSERT INTO fichiers_interventions(ID_inter, ID_conducteur, fic_name, fic_size, fic_type, fic_content, type_fic) VALUES (:idI, :idC, :ficN, :ficS, :ficT, :ficC, :typeC)');
- $req_fic->execute(array(
- 'idI' => 0,
- 'idC' => $lastID,
- 'ficN' => $fileName,
- 'ficS' => $fileSize,
- 'ficT' => $fileType,
- 'ficC' => $content,
- 'typeC' => 1
- ));
- }
- $deleteTable = $connection->exec("DELETE FROM vehicules_conducteurs WHERE ID_conducteur = '{$lastID}'");
- // On récupère les conducteurs selectionnés dans la liste déroulante
- foreach ($_POST['vehicules'] as $choix) {
- # code...
- $ins_conduc = $connection->prepare ('INSERT INTO vehicules_conducteurs (ID_vehicule, ID_conducteur)
- VALUES
- (:IDvehi, :IDcondu)
- ')
- or exit(print_r($bdd->errorInfo()));
- $ins_conduc->execute(array(
- 'IDvehi' => $choix,
- 'IDcondu' => $lastID,
- ));
- }
- header('Location: ../pages/conducteurs.php');
- exit();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement