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 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80
| <?php
session_start();
// Fichier contenant la liaison entre PHP et MYSQL
include_once 'connexion_database.php';
if( isset($_POST['ref'] , $_POST['type'] ,$_POST['objetd'] ,$_POST['datedepot'] ,$_POST['nomdep'] ,$_POST['agent'] ,
$_POST['statue'] ,$_POST['doc1'],$_POST['doc2'], $_POST['doc3'] ) && !empty($_POST['ref']) && !empty($_POST['type'])
&& !empty($_POST['objetd']) && !empty($_POST['datedepot']) && !empty($_POST['nomdep']) && !empty($_POST['agent'])
&& !empty($_POST['statue']) && !empty($_POST['doc1']) && !empty($_POST['doc2']) && !empty($_POST['doc3']) )
{
try
{
$bdd = new PDO('mysql:host=localhost;dbname=controle', 'root', '');
}
catch(Exception $e)
{
die('Erreur : '.$e->getMessage());
}
$ref = htmlspecialchars(trim($_POST['ref']));
$type = htmlspecialchars(trim($_POST['type']));
$objet = htmlspecialchars(trim($_POST['objetd']));
$datedepot = htmlspecialchars(trim($_POST['datedepot']));
$nomdep = htmlspecialchars(trim($_POST['nomdep']));
$agent = htmlspecialchars(trim($_POST['agent']));
$statue = htmlspecialchars(trim($_POST['statue']));
$doc1 = $_files ['doc1'] ['name'];
$_files_tmp_name = $_files['doc1']['tmp_name'];
move_uploaded_file($_files_tmp_name, "./images/$doc1");
$doc2 = $_files ['doc2'] ['name1'];
$_files_tmp_name = $_files['doc2']['tmp_name1'];
move_uploaded_file($_files_tmp_name, "./images/$doc2");
$doc3 = $_files ['doc3'] ['name2'];
$_files_tmp_name = $_files['doc3']['tmp_name2'];
move_uploaded_file($_files_tmp_name, "./images/$doc3");
$objetPDO->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
$requete = $bdd -> prepare('INSERT INTO dossier (ref, type, objet, daten, nomdeposant, statue, Agent, pj1, pj2, pj3) VALUES ("","$ref", "$type", "$objet", "$datedepot", "$nomdep", "$statue", "$agent", $doc1, $doc2, $doc3)');
// $requete = $objetPDO -> prepare('INSERT INTO dossier SET ref =?, type=?, objet=?, daten=?, nomdeposant=?, statue=?, Agent=?, pj1=?, pj2=?, pj3=?');
$insertisok = $requete->execute(
array('ref' => $ref,
'type' => $type,
'objetd' =>$objet,
'datedepot' => $datedepot,
'nomdep' => $nomdep,
'agent'=> $agent,
'statue'=>$statue,
)
);
if($requete)
{
$requete->closeCursor();
header('Location:liste.php');
}
}
else
{
$_SESSION['existe'] = " Veuillez renseigner tous les champs " ;
header('Location:accueil.php');
}
?> |
Partager