Bonjour,
J'ai un code qui permet d'insérer un personnel dans ma base, j'ai tout vérifié, tous semble bien mise au point mais quand je remplie les informations et valider un enregistrement dans la base alors il n'y aucun enregistrement stocké dans la base. Pouvez vous m'aider s'il vous plaît:
voici mon code php:
<?php
require_once ( "header.php" );
require_once ( "connexion.php" );
if ( isset ( $_POST [ 'date_emb' ]) and isset ( $_POST [ 'matricule' ])
and isset ( $_POST [ 'service' ]) and isset ( $_POST [ 'fonction' ])
and isset ( $_POST [ 'nom' ]) and isset ( $_POST [ 'prenom' ])
and isset ( $_POST [ 'pers_datnais' ]) and isset ( $_POST [ 'adresse' ])
and isset ( $_POST [ 'tel' ]) and isset ( $_POST [ 'cin' ])
and isset ( $_POST [ 'datecin' ]) and isset ( $_POST [ 'lieucin' ])
and isset ( $_POST [ 'num_cnaps' ]) and isset ( $_POST [ 'nom_banque' ])
and isset ( $_POST [ 'num_banque' ]) and isset ( $_POST [ 'rib' ])
and isset ( $_POST [ 'vady' ]) and isset ( $_FILES [ 'photo' ]) and isset ( $_FILES [ 'salaire' ]))
{
if ( $_FILES [ 'photo' ][ 'size' ]< 1000000000000 )
{
$infofichier = pathinfo ( $_FILES [ 'photo' ][ 'name' ]);
$extension_uploads = $infofichier [ 'extension' ];
$extension_autorised = array ( 'jpg' , 'png' , 'gif' , 'jpeg' );
if ( in_array ( $extension_uploads , $extension_autorised ))
{
move_uploaded_file ( $_FILES [ 'photo' ][ 'tmp_name' ], 'uploads/' . basename ( $_FILES [ 'photo' ][ 'name' ]));
$nomphoto = $_FILES [ 'photo' ][ 'name' ];
$file_tmp_name = $_FILES [ 'photo' ][ 'tmp_name' ];
$date_emb = $_POST [ 'date_emb' ];
$mat = $_POST [ 'matricule' ];
$service = $_POST [ 'service' ];
$fonction = $_POST [ 'fonction' ];
$nom = $_POST [ 'nom' ];
$prenom = $_POST [ 'prenom' ];
$pers_datnais = $_POST [ 'pers_datnais' ];
$adresse = $_POST [ 'adresse' ];
$tel = $_POST [ 'tel' ];
$cin = $_POST [ 'cin' ];
$datecin = $_POST [ 'datecin' ];
$lieucin = $_POST [ 'lieucin' ];
$num_cnaps = $_POST [ 'num_cnaps' ];
$nom_banque = $_POST [ 'nom_banque' ];
$num_banque = $_POST [ 'num_banque' ];
$rib = $_POST [ 'rib' ];
$vady = $_POST [ 'vady' ];
$salaire = $_POST [ 'salaire' ];
$req = $bdd -> prepare ( "INSERT INTO personnel (
date_emb, matricule,service,fonction,nom,prenom,
pers_datnais,adresse,tel,cin,date_cin,lieu_cin,
num_cnaps,nom_banque,num_banque,rib,vady,photo,salaire)
VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,?,?,?,?,?,?)" );
$req -> execute ( array ( $date_emb , $mat , $service , $fonction , $nom ,
$prenom , $pers_datnais , $adresse , $tel , $cin , $datecin , $lieucin ,
$num_cnaps , $nom_banque , $num_banque , $rib , $vady , $nomphoto , $salaire ));
header ( 'location:ajout_personnel.php' );
}
}
}
?>
< div class = "container" >
< h3> Coordonées du personnel </ h3>< hr>
< form action= "ajout_personnel.php" method= "post" enctype= "multipart/form-data" >
< div class = "row" >
< div class = "col-md-5" >
< div class = "form-group" >
< input type= "file" name= "photo" placeholder= "Photo" >
</ div>
< div class = "form-group" >
< input type= "date" name= "date_emb" class = "form-control" placeholder= "Date d'embauche" >
</ div>
< div class = "form-group" >
< input type= "text" name= "matricule" class = "form-control" placeholder= "Matricule" >
</ div>
< div class = "form-group" >
< select name= "service" selected= "selected" class = "form-control" >
<?php
global $bdd ;
$req = $bdd -> query ( 'SELECT * FROM service' );
while ( $service = $req -> fetch ()) {
?>
< option><?php echo $service [ 'nom_service' ];?></ option>
<?php } ?>
</ select>
</ div>
< div class = "form-group" >
< select name= "fonction" selected= "selected" class = "form-control" >
<?php
global $bdd ;
$req = $bdd -> query ( 'SELECT * FROM fonction' );
while ( $donnees = $req -> fetch ()) {
$fonction []= $donnees ;
}
foreach ( $fonction as $n ) {
?>
< option><?php echo $n [ 'nom_fonction' ]; ?></ option>
<?php } ?>
</ select>
</ div>
< div class = "form-group" >
< input type= "text" name= "nom" class = "form-control" placeholder= "Nom" >
</ div>
< div class = "form-group" >
< input type= "text" name= "prenom" class = "form-control" placeholder= "Prénom(s)" >
</ div>
< div class = "form-group" >
< input type= "date" name= "pers_datnais" class = "form-control" placeholder= "Date de naissance" >
</ div>
</ div>
< div class = "col-md-5" >
< div class = "form-group" >
< input type= "text" name= "adresse" class = "form-control" placeholder= "Adresse" >
</ div>
< div class = "form-group" >
< input type= "text" name= "tel" class = "form-control" placeholder= "Téléphone" >
</ div>
< div class = "form-group" >
< input type= "text" name= "cin" class = "form-control" placeholder= "CIN" >
</ div>
< div class = "form-group" >
< input type= "date" name= "datecin" class = "form-control" placeholder= "DELIVRE LE" >
</ div>
< div class = "form-group" >
< input type= "text" name= "lieucin" class = "form-control" placeholder= "à" >
</ div>
< div class = "form-group" >
< input type= "text" name= "num_cnaps" class = "form-control" placeholder= "Numéro Cnaps" >
</ div>
< div class = "form-group" >
< select name= "nom_banque" selected= "selected" class = "form-control" >
< option > BOA</ option>
< option > BNI</ option>
< option > BFV- SG</ option>
< option > Acces banque</ option>
< option> BMOI </ option>
< OPTION> SBM </ option>
< OPTION> ACCESS BANQUE </ option>
< OPTION> BGFI- BANK </ option>
< OPTION> MICROCRED </ option>
< OPTION> SIPEM </ option>
< OPTION> BM- MADAGASCAR </ option>
< OPTION> MAURITUS COMMERCIAL BANK </ option>
</ select>
</ div>
< div class = "form-group" >
< input type= "text" name= "num_banque" class = "form-control" placeholder= "Numéro Bancaire" >
</ div>
< div class = "form-group" >
< input type= "text" name= "rib" class = "form-control" placeholder= "RIB" >
</ div>
< div class = "form-group" >
< input type= "text" name= "vady" class = "form-control" placeholder= "Epoux(se)" >
</ div>
< div class = "form-group" >
< input type= "text" name= "salaire" class = "form-control" placeholder= "salaire" >
</ div>
<!--< p>< a href= "#" class = "btn btn-primary" role= "button" > Enregistrer</ a></ p> -->
< input class = "btn btn-primary" type= "submit" value= "Enregistrer" />
</ div>
</ div>
</ div>
</ form>
</ div>
<?php
require_once ( 'footer.php' );
?>
Et voici ma base de donnée:
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO" ;
SET AUTOCOMMIT = 0 ;
START TRANSACTION;
SET time_zone = "+00:00" ;
;
;
;
;
CREATE TABLE `conge` (
`id_conge` int ( 11 ) NOT NULL ,
`matricule` int ( 5 ) NOT NULL ,
`annee` text NOT NULL ,
`nbrajout` double NOT NULL ,
`type` text NOT NULL
) ENGINE= InnoDB DEFAULT CHARSET= latin1;
INSERT INTO `conge` ( `id_conge` , `matricule` , `annee` , `nbrajout` , `type` ) VALUES
( 1 , 1024 , '2017' , 30 , 'Congé' ),
( 2 , 1024 , '2018' , 30 , 'Congé' ),
( 3 , 178 , '2018' , 16 , 'Congé' ),
( 4 , 178 , '2018' , 10 , 'Permission' ),
( 5 , 178 , '2017' , 30 , 'Congé' ),
( 6 , 178 , '2020' , 20 , 'Congé' ),
( 7 , 178 , '2021' , 21 , 'Congé' ),
( 8 , 178 , '2022' , 22 , 'Permission' ),
( 9 , 999 , '2017' , 24 , 'Congé' );
CREATE TABLE `detail_mission` (
`num_mission` varchar ( 10 ) NOT NULL ,
`nom` varchar ( 150 ) NOT NULL
) ENGINE= InnoDB DEFAULT CHARSET= latin1;
INSERT INTO `detail_mission` ( `num_mission` , `nom` ) VALUES
( '54/2018' , '178' ),
( '54/2018' , '75 RAMAKA Permission' ),
( '54/2018' , '178 RANDRIAMANANA Befaritra Zoelihery Tiana' ),
( '54/2018' , '211 Listes Listes' ),
( '456' , '178 RANDRIAMANANA Befaritra Zoelihery Tiana' ),
( '456' , '1024 Ando kely' ),
( '456' , '225 RAKOTO Ohatra' ),
( '456' , '211 Listes Listes' ),
( '8182' , '178 RANDRIAMANANA Befaritra Zoelihery Tiana' ),
( '8182' , '75 RAMAKA Permission' );
CREATE TABLE `enfant` (
`id_enfant` int ( 5 ) NOT NULL ,
`matricule` int ( 5 ) DEFAULT NULL ,
`nom_enfant` varchar ( 20 ) DEFAULT NULL ,
`prenom_enfant` varchar ( 20 ) DEFAULT NULL ,
`date_naissance` date DEFAULT NULL
) ENGINE= MyISAM DEFAULT CHARSET= latin1;
INSERT INTO `enfant` ( `id_enfant` , `matricule` , `nom_enfant` , `prenom_enfant` , `date_naissance` ) VALUES
( 1 , NULL , 'Entsoa' , NULL , '2006-05-23' ),
( 2 , 1024 , 'ras' , 'ras' , '2006-05-23' ),
( 3 , 1024 , 'ras' , 'ras' , '2006-05-23' ),
( 4 , 1024 , 'ras' , 'ras' , '2006-05-23' ),
( 5 , 1024 , 'ras' , 'ras' , '2006-05-23' ),
( 6 , 1025 , 'ras' , 'ras' , '2006-05-23' ),
( 7 , 1024 , 'ras' , 'ras' , '2006-05-23' ),
( 8 , 1024 , 'ras' , 'ras' , '2006-05-23' ),
( 9 , 1000 , 'ras' , 'ras' , '2006-05-23' ),
( 10 , 1012 , 'Enitsoa' , 'Fleurit kely' , '2006-05-23' ),
( 11 , 1012 , 'ras' , 'ras test' , '2006-05-23' ),
( 12 , 178 , 'RANDRIA' , 'Manana' , '2020-04-23' ),
( 13 , 143 , 'KOTO' , 'Mandeha' , '2018-09-20' ),
( 14 , 143 , 'Koto' , 'Tsy mety Disable' , '2015-06-24' ),
( 15 , 999 , 'KALINA99' , 'Kalina99' , '2018-09-12' ),
( 16 , 999 , 'gegegegee' , 'hehehehehehe' , '1997-10-14' ),
( 17 , 143 , 'RANDRIAMANANA' , 'Kely' , '2016-12-25' ),
( 18 , 178 , 'test' , 'andrana' , '1989-02-24' ),
( 19 , 178 , 'GE' , 'RH' , '2018-10-08' ),
( 20 , 178 , 'GE' , 'RH' , '2018-10-08' ),
( 21 , 178 , 'GE' , 'RH' , '2018-10-08' ),
( 22 , 468 , 'RAKOTOSARY' , 'Zanany' , '1988-04-23' ),
( 23 , 468 , 'RABESARY' , 'Zanan-tsary' , '2002-06-19' );
CREATE TABLE `fiche_conge` (
`idfiche` int ( 11 ) NOT NULL ,
`nfiche` varchar ( 10 ) NOT NULL ,
`datefiche` date NOT NULL ,
`datedep` date NOT NULL ,
`heuredep` time NOT NULL ,
`motif` text NOT NULL ,
`datefin` date NOT NULL ,
`heurefin` time NOT NULL ,
`datereprise` date NOT NULL ,
`heurereprise` time NOT NULL ,
`matricule` int ( 5 ) NOT NULL
) ENGINE= InnoDB DEFAULT CHARSET= latin1;
INSERT INTO `fiche_conge` ( `idfiche` , `nfiche` , `datefiche` , `datedep` , `heuredep` , `motif` , `datefin` , `heurefin` , `datereprise` , `heurereprise` , `matricule` ) VALUES
( 1 , '1' , '2018-09-04' , '2018-09-05' , '21:15:00' , '' , '0000-00-00' , '00:00:00' , '0000-00-00' , '00:00:00' , 0 ),
( 2 , '123' , '2018-09-11' , '2018-09-11' , '08:00:00' , '' , '0000-00-00' , '00:00:00' , '0000-00-00' , '00:00:00' , 0 ),
( 3 , '178' , '2018-09-11' , '2018-09-11' , '17:00:00' , 'Motif mody @zay fa efa hariva ny andro' , '0000-00-00' , '00:00:00' , '0000-00-00' , '00:00:00' , 0 ),
( 4 , '169' , '2018-09-11' , '2018-09-11' , '17:00:00' , 'Ande hamelona moto fa efa hariva ka maika hody' , '0000-00-00' , '00:00:00' , '0000-00-00' , '00:00:00' , 0 ),
( 5 , '888' , '0000-00-00' , '0000-00-00' , '00:00:00' , 'date fin' , '2018-09-11' , '00:00:00' , '0000-00-00' , '00:00:00' , 0 ),
( 6 , '12345678' , '0000-00-00' , '0000-00-00' , '00:00:00' , 'Motif d \' absence' , '0000-00-00' , '00:00:00' , '0000-00-00' , '00:00:00' , 0 ),
( 7 , '11111111' , '0000-00-00' , '0000-00-00' , '00:00:00' , 'Motif d \' absence' , '0000-00-00' , '00:00:00' , '0000-00-00' , '00:00:00' , 0 ),
( 8 , '123456789' , '0000-00-00' , '0000-00-00' , '00:00:00' , 'Motif d \' absence' , '0000-00-00' , '00:00:00' , '2018-09-21' , '00:00:00' , 0 ),
( 9 , '6464646464' , '2018-09-11' , '2018-09-12' , '00:00:00' , 'Mandeha daholo' , '2018-09-13' , '00:00:00' , '2018-09-14' , '00:00:00' , 178 ),
( 10 , '5757' , '0000-00-00' , '2018-09-11' , '00:00:00' , 'Motif d \' absence' , '2018-09-13' , '00:00:00' , '0000-00-00' , '00:00:00' , 0 ),
( 11 , '95' , '0000-00-00' , '2018-09-12' , '00:00:00' , 'Motif d \' absence' , '2018-09-12' , '00:00:00' , '0000-00-00' , '00:00:00' , 0 ),
( 12 , '95' , '0000-00-00' , '2018-09-12' , '00:00:00' , 'Motif d \' absence' , '2018-09-13' , '00:00:00' , '0000-00-00' , '00:00:00' , 0 ),
( 13 , '69' , '0000-00-00' , '2018-09-11' , '00:00:00' , 'Motif d \' absence' , '2018-09-13' , '00:00:00' , '0000-00-00' , '00:00:00' , 0 ),
( 14 , '12121212' , '0000-00-00' , '2018-09-11' , '00:00:00' , 'Motif d \' absence' , '2018-09-14' , '00:00:00' , '0000-00-00' , '00:00:00' , 0 ),
( 15 , '35' , '0000-00-00' , '2018-09-11' , '00:00:00' , 'Motif d \' absence' , '2018-09-13' , '00:00:00' , '0000-00-00' , '00:00:00' , 0 ),
( 16 , '895' , '2018-09-12' , '2018-09-13' , '00:00:00' , 'Mandeha daholo' , '2018-09-14' , '00:00:00' , '2018-09-14' , '00:00:00' , 178 ),
( 17 , '987' , '2018-09-11' , '2018-09-12' , '00:00:00' , 'Vacance' , '2018-09-13' , '00:00:00' , '2018-09-14' , '13:00:00' , 178 ),
( 18 , '888888' , '2018-09-12' , '2018-09-13' , '00:00:00' , 'aaaaaaaaa' , '2018-09-13' , '00:00:00' , '2018-09-14' , '00:00:00' , 999 ),
( 19 , '7441' , '2018-09-14' , '0000-00-00' , '00:00:00' , 'Test' , '0000-00-00' , '00:00:00' , '0000-00-00' , '00:00:00' , 178 ),
( 20 , '741' , '0000-00-00' , '0000-00-00' , '00:00:00' , 'Tsy mety disabled' , '0000-00-00' , '00:00:00' , '0000-00-00' , '00:00:00' , 178 ),
( 21 , '6969' , '2018-09-17' , '2018-09-17' , '00:00:00' , 'Abs' , '2018-09-17' , '00:00:00' , '2018-09-17' , '00:00:00' , 143 ),
( 22 , '471' , '2018-09-17' , '2018-09-17' , '12:00:00' , 'Malade' , '2018-09-17' , '16:00:00' , '2018-09-18' , '08:00:00' , 999 ),
( 23 , '468/18' , '2018-09-18' , '2018-09-18' , '00:00:00' , 'Repos 3 jours' , '2018-09-20' , '00:00:00' , '2018-09-21' , '08:00:00' , 999 ),
( 24 , '936' , '2018-09-17' , '2018-09-17' , '00:00:00' , 'MAndeha @zay' , '2018-09-17' , '00:00:00' , '2018-09-18' , '00:00:00' , 143 ),
( 25 , '9999/18' , '2018-10-01' , '2018-10-01' , '00:00:00' , 'ytesfgvcgfcgsdd' , '2018-10-01' , '00:00:00' , '2018-10-01' , '00:00:00' , 999 ),
( 26 , '998/18' , '0000-00-00' , '0000-00-00' , '00:00:00' , '56' , '0000-00-00' , '00:00:00' , '0000-00-00' , '00:00:00' , 999 ),
( 27 , '178/18' , '2018-10-01' , '2018-10-02' , '00:00:00' , 'Vacance' , '2018-10-04' , '00:00:00' , '2018-10-05' , '00:00:00' , 178 ),
( 28 , '2121' , '2018-10-09' , '2018-10-11' , '00:00:00' , 'Lasa' , '2018-10-14' , '00:00:00' , '2018-10-15' , '00:00:00' , 178 ),
( 29 , '936' , '2018-10-08' , '2018-10-09' , '00:00:00' , 'Motif d \' absence' , '2018-10-10' , '00:00:00' , '2018-10-11' , '00:00:00' , 178 ),
( 30 , 'test123' , '2018-10-29' , '2018-10-30' , '00:00:00' , 'Motif d \' absence' , '2018-11-02' , '00:00:00' , '2018-11-05' , '00:00:00' , 178 ),
( 31 , '4561' , '2018-10-11' , '2018-10-12' , '00:00:00' , 'Manalazy Zoma' , '2018-10-12' , '00:00:00' , '2018-10-15' , '00:00:00' , 178 ),
( 32 , '548' , '2018-10-22' , '2018-10-23' , '00:00:00' , 'Congé' , '2018-10-26' , '00:00:00' , '2018-10-29' , '00:00:00' , 468 );
CREATE TABLE `fiche_permission` (
`idfiche` int ( 11 ) NOT NULL ,
`nfiche` varchar ( 10 ) NOT NULL ,
`datefiche` date NOT NULL ,
`datedep` date NOT NULL ,
`heuredep` time NOT NULL ,
`motif` text NOT NULL ,
`datefin` date NOT NULL ,
`heurefin` time NOT NULL ,
`nbrjour` double NOT NULL ,
`datereprise` date NOT NULL ,
`heurereprise` time NOT NULL ,
`matricule` int ( 5 ) NOT NULL
) ENGINE= InnoDB DEFAULT CHARSET= latin1;
INSERT INTO `fiche_permission` ( `idfiche` , `nfiche` , `datefiche` , `datedep` , `heuredep` , `motif` , `datefin` , `heurefin` , `nbrjour` , `datereprise` , `heurereprise` , `matricule` ) VALUES
( 1 , '123' , '2018-10-01' , '2018-10-02' , '00:00:00' , 'Kamo' , '2018-10-03' , '00:00:00' , 1 , '2018-10-03' , '00:00:00' , 75 ),
( 2 , '123' , '2018-10-01' , '2018-10-02' , '00:00:00' , 'Kamo' , '2018-10-03' , '00:00:00' , 1 , '2018-10-03' , '00:00:00' , 75 );
CREATE TABLE `fonction` (
`id_fonction` int ( 5 ) NOT NULL ,
`nom_fonction` varchar ( 75 ) DEFAULT NULL ,
`nom_service` varchar ( 30 ) DEFAULT NULL
) ENGINE= MyISAM DEFAULT CHARSET= latin1;
INSERT INTO `fonction` ( `id_fonction` , `nom_fonction` , `nom_service` ) VALUES
( 1 , 'RH' , 'compta' ),
( 2 , 'Comptable' , 'Compta' ),
( 3 , 'Agent comptable' , 'Compta' ),
( 4 , 'TIC' , 'Compta' ),
( 5 , 'Chargé Statistique' , 'Statistique' ),
( 6 , 'Secretaire' , 'Secretariat' ),
( 7 , 'Comptable matière' , 'Logistique' ),
( 8 , 'Chargé Laboratoire' , 'Laboratoire' ),
( 9 , 'CGAF' , 'Compta' ),
( 10 , 'Chargé d \' Agrement' , 'Agrement' ),
( 11 , 'A' , 'Compta' ),
( 14 , 'ASR' , 'Informatique' ),
( 15 , 'Developpeur' , 'Informatique' ),
( 16 , 'Chargé Microbiologie' , 'Microbiologie' ),
( 17 , 'Responsable Microbiologie' , 'Microbiologie' ),
( 18 , 'Chargé Logistique' , 'Logistique' ),
( 19 , 'Agent logistique' , 'Logistique' ),
( 20 , 'Test' , 'TEST TEST' ),
( 21 , 'Chargé Informatique' , 'Informatique' );
CREATE TABLE `mission` (
`id_mission` int ( 11 ) NOT NULL ,
`num_mission` varchar ( 10 ) NOT NULL ,
`objet_mission` varchar ( 50 ) NOT NULL ,
`ref_mission` varchar ( 30 ) NOT NULL ,
`activite_mission` text NOT NULL ,
`resultat_mission` text NOT NULL ,
`itineraire_mission` text NOT NULL ,
`depl_mission` varchar ( 12 ) NOT NULL ,
`observation` text NOT NULL ,
`date_dep` date NOT NULL ,
`date_ret` date NOT NULL
) ENGINE= InnoDB DEFAULT CHARSET= latin1;
INSERT INTO `mission` ( `id_mission` , `num_mission` , `objet_mission` , `ref_mission` , `activite_mission` , `resultat_mission` , `itineraire_mission` , `depl_mission` , `observation` , `date_dep` , `date_ret` ) VALUES
( 4 , '18/2018' , 'KATSAKA MAJUNGA' , 'hghfgdgh' , '45' , '45' , '45' , 'Taxi-brousse' , '4545' , '2018-10-08' , '2018-10-10' ),
( 5 , '456' , '12' , '12' , 'Activité de la mission' , 'Résultat de la mission' , '12' , 'Voiture' , '1312315 WWT' , '2018-10-08' , '2018-10-11' ),
( 6 , '54/2018' , 'Suivi installation Diégo' , 'Convention...' , '-Réception Matériel \r\n -xvxjhvdjv' , '-BR \r\n -jgvjvkk' , 'Tana - Diégo - Tana' , 'Voiture' , '54641 WWT' , '2018-10-08' , '2018-10-10' ),
( 7 , '8182' , 'TEST MANDEHA' , 'skjbbkb' , '-jksbkjahbsa \r\n -skjbasbaksba \r\n -s ajsh aj' , '-ksbdbjkdbzjd \r\n -sjsnkbjsajbsk \r\n -skjbaskasomdd' , 'Tana - Morondava - Tana' , 'Voiture' , '54641 WWT' , '2018-10-30' , '2018-10-31' );
CREATE TABLE `permission` (
`id_conge` int ( 11 ) NOT NULL ,
`matricule` int ( 5 ) NOT NULL ,
`annee` text NOT NULL ,
`nbrajout` double NOT NULL ,
`type` text NOT NULL
) ENGINE= InnoDB DEFAULT CHARSET= latin1;
INSERT INTO `permission` ( `id_conge` , `matricule` , `annee` , `nbrajout` , `type` ) VALUES
( 1 , 75 , '2018' , 10 , 'Permission' ),
( 2 , 10 , '2019' , 10 , 'Permission' ),
( 3 , 75 , '2019' , 10 , 'Permission' ),
( 4 , 143 , '2019' , 10 , 'Permission' ),
( 5 , 178 , '2019' , 10 , 'Permission' ),
( 6 , 211 , '2019' , 10 , 'Permission' ),
( 7 , 225 , '2019' , 10 , 'Permission' ),
( 8 , 457 , '2019' , 10 , 'Permission' ),
( 9 , 468 , '2019' , 10 , 'Permission' ),
( 10 , 999 , '2019' , 10 , 'Permission' ),
( 11 , 1012 , '2019' , 10 , 'Permission' ),
( 12 , 1024 , '2019' , 10 , 'Permission' );
CREATE TABLE `personnel` (
`id_personnel` int ( 5 ) NOT NULL ,
`date_emb` date DEFAULT NULL ,
`matricule` int ( 5 ) DEFAULT NULL ,
`service` varchar ( 30 ) DEFAULT NULL ,
`fonction` varchar ( 75 ) DEFAULT NULL ,
`nom` varchar ( 30 ) DEFAULT NULL ,
`prenom` varchar ( 30 ) DEFAULT NULL ,
`pers_datnais` date NOT NULL ,
`adresse` varchar ( 30 ) DEFAULT NULL ,
`tel` int ( 15 ) DEFAULT NULL ,
`cin` int ( 18 ) DEFAULT NULL ,
`date_cin` date DEFAULT NULL ,
`lieu_cin` varchar ( 20 ) DEFAULT NULL ,
`num_cnaps` int ( 10 ) DEFAULT NULL ,
`nom_banque` varchar ( 25 ) DEFAULT NULL ,
`num_banque` int ( 20 ) DEFAULT NULL ,
`rib` varchar ( 20 ) DEFAULT NULL ,
`vady` varchar ( 150 ) NOT NULL ,
`photo` text NOT NULL ,
`salaire` int ( 7 ) NOT NULL
) ENGINE= MyISAM DEFAULT CHARSET= latin1;
INSERT INTO `personnel` ( `id_personnel` , `date_emb` , `matricule` , `service` , `fonction` , `nom` , `prenom` , `pers_datnais` , `adresse` , `tel` , `cin` , `date_cin` , `lieu_cin` , `num_cnaps` , `nom_banque` , `num_banque` , `rib` , `vady` , `photo` , `salaire` ) VALUES
( 15 , '2006-05-23' , 1024 , NULL , NULL , 'Enitsoa' , 'kely' , '0000-00-00' , 'Isotry' , 75757575 , 0 , '2006-05-23' , 'ryryr' , 12345 , 'boa' , 123456 , '12' , '' , '' , 0 ),
( 14 , NULL , 1012 , NULL , NULL , NULL , NULL , '0000-00-00' , 'Bema renina' , 789456123 , NULL , NULL , NULL , NULL , NULL , NULL , NULL , '' , '' , 0 ),
( 16 , '2006-05-23' , 1024 , NULL , NULL , 'Enitsoa' , 'rtr' , '0000-00-00' , 'Isotry' , 75757575 , 0 , '2006-05-23' , 'ryryr' , 12345 , 'boa' , 123456 , '12' , '' , '' , 0 ),
( 17 , '2006-05-23' , 1024 , NULL , NULL , 'Enitsoa' , 'Fleurit' , '0000-00-00' , 'Isotry' , 75757575 , 0 , '2006-05-23' , 'ryryr' , 12345 , 'boa' , 123456 , '12' , '' , '' , 0 ),
( 18 , '2006-05-23' , 1024 , NULL , NULL , 'Ando' , 'kely' , '0000-00-00' , 'Isotry' , 75757575 , 0 , '2006-05-23' , 'ryryr' , 12345 , 'boa' , 123456 , '12' , '' , '' , 0 ),
( 19 , '2006-05-23' , 1024 , NULL , NULL , 'Ando' , 'kely' , '0000-00-00' , 'Isotry' , 75757575 , 0 , '2006-05-23' , 'ryryr' , 12345 , 'boa' , 123456 , '12' , '' , '' , 0 ),
( 20 , '2006-05-23' , 1024 , NULL , NULL , 'Enitsoa' , 'Fleurit' , '0000-00-00' , 'Isotry' , 75757575 , 0 , '2006-05-23' , 'ryryr' , 12345 , 'boa' , 123456 , '12' , '' , '' , 0 ),
( 21 , '2006-05-23' , 10 , 'Compta' , 'RH' , 'Ando' , 'Fleurit' , '0000-00-00' , 'Ampasampito Mahazo' , 2147483647 , 0 , '2006-05-23' , 'ryryr' , 12345 , 'BNI' , 123456 , '12' , '' , '' , 0 ),
( 22 , '2006-05-23' , 10 , 'Compta' , 'RH' , 'Enitsoa' , 'Fleurit' , '0000-00-00' , 'Ampasampito Mahazo' , 2147483647 , 0 , '2006-05-23' , 'ryryr' , 12345 , 'BNI' , 123456 , '12' , '' , '' , 0 ),
( 23 , '2006-05-23' , 10 , 'Compta' , 'RH' , 'Enitsoa' , 'Fleurit' , '0000-00-00' , 'Ampasampito Mahazo' , 2147483647 , 0 , '2006-05-23' , 'ryryr' , 12345 , 'BNI' , 123456 , '12' , '' , '' , 0 ),
( 24 , '2018-05-14' , 178 , 'Informatique' , 'A' , 'RANDRIAMANANA' , 'Befaritra Zoelihery Tiana' , '1988-04-23' , 'Lot II N 192 FB Besarety' , 340805406 , 101 , '0000-00-00' , 'Antananarivo III' , 312654 , 'BOA' , 2147483647 , '17' , '' , '' , 1075000 ),
( 25 , '2018-09-10' , 225 , 'Compta' , 'RH' , 'RAKOTO' , 'Ohatra' , '0000-00-00' , 'tsy fantatra' , 77777771 , 2147483647 , '2006-05-23' , 'Antananarivo III' , 357 , 'BFV-SG' , 5555 , '555' , '' , '' , 0 ),
( 26 , '2018-09-10' , 143 , 'Compta' , 'RH' , 'Rasoa' , 'Niry' , '1978-04-29' , 'Ampandrianomby' , 340567890 , 2147483647 , '1995-09-10' , 'Antananarivo I' , 647 , 'MAURITUS COMMERCIAL BANK' , 76870965 , '46' , '' , '' , 0 ),
( 27 , '2018-09-10' , 999 , 'Compta' , 'RH' , 'RAKOTO999' , 'Son999' , '0000-00-00' , 'Ampasampito' , 25252525 , 2147483647 , '2018-09-13' , 'Antananarivo III' , 25252525 , 'BM-MADAGASCAR' , 2147483647 , '25' , '' , '' , 0 ),
( 28 , '2018-10-01' , 211 , 'Epidemiologie' , 'Chargé Logistique' , 'Listes' , 'Listes' , '2018-10-01' , 'Listes' , 54 , 56 , '2018-10-01' , 'Paris' , 59 , 'BOA' , 69 , '21' , '' , '' , 0 ),
( 29 , '2018-10-01' , 75 , 'Informatique' , 'TIC' , 'RAMAKA' , 'Permission' , '2018-10-01' , 'Maka' , 754 , 7543 , '2018-10-01' , 'Antananarivo III' , 75432 , 'BOA' , 7890 , '69' , 'RANDRIAMETY Tena Mety' , '' , 0 ),
( 30 , '2018-10-09' , 457 , 'Administration' , 'Comptable matière' , 'RASOAZANANY' , 'Zanany' , '1978-05-16' , 'Lot Lot Lot' , 345815421 , 2147483647 , '1986-05-16' , 'Antananarivo III' , 656565 , 'ACCESS BANQUE' , 6574 , '457' , 'RAVAOMARIA Zanany Zanany' , '' , 0 ),
( 32 , '2018-10-08' , 468 , 'Informatique' , 'Chargé Informatique' , 'SARY' , 'SARY' , '2018-10-04' , 'Andravoahangy' , 2252225 , 2147483647 , '2018-10-11' , 'Antananarivo III' , 357 , 'BGFI-BANK' , 364541 , '69' , 'Vadin-tsary' , 'Koala.jpg' , 18281 );
CREATE TABLE `promotion` (
`id_permission` int ( 5 ) NOT NULL ,
`matricule` int ( 5 ) DEFAULT NULL ,
`date` date NOT NULL ,
`service` varchar ( 30 ) DEFAULT NULL ,
`fonction` varchar ( 75 ) DEFAULT NULL ,
`salaire` int ( 7 ) DEFAULT NULL
) ENGINE= MyISAM DEFAULT CHARSET= latin1;
INSERT INTO `promotion` ( `id_permission` , `matricule` , `date` , `service` , `fonction` , `salaire` ) VALUES
( 60 , 468 , '2018-10-31' , 'Informatique' , 'Chargé Informatique' , 18281 ),
( 59 , 468 , '2018-10-23' , 'Informatique' , 'Chargé Informatique' , 81182 ),
( 58 , 468 , '2018-10-22' , 'Informatique' , 'Developpeur' , 81182 ),
( 57 , 468 , '2018-10-16' , 'Informatique' , 'ASR' , 81182 ),
( 56 , 468 , '2018-10-22' , 'Informatique' , 'Chargé Informatique' , 81182 ),
( 55 , 468 , '2018-10-31' , 'Informatique' , 'Chargé Informatique' , 811823 ),
( 50 , 468 , '2018-10-31' , NULL , NULL , 18281 ),
( 51 , 468 , '0000-00-00' , 'Informatique' , 'Chargé Informatique' , 18281 ),
( 52 , 468 , '2018-10-31' , 'Informatique' , 'Chargé Informatique' , 8182 ),
( 53 , 468 , '2018-10-31' , 'Informatique' , 'Chargé Informatique' , 81182 ),
( 54 , 468 , '2018-10-29' , 'Informatique' , 'Chargé Informatique' , 81182 );
CREATE TABLE `service` (
`id_service` int ( 5 ) NOT NULL ,
`nom_service` varchar ( 30 ) DEFAULT NULL
) ENGINE= MyISAM DEFAULT CHARSET= latin1;
INSERT INTO `service` ( `id_service` , `nom_service` ) VALUES
( 1 , 'Compta' ),
( 2 , 'Informatique' ),
( 4 , 'Aquaculture' ),
( 6 , 'Epidemiologie' ),
( 7 , 'Statistique' ),
( 8 , 'Secretariat' ),
( 9 , 'Administration' ),
( 10 , 'Logistique' ),
( 11 , 'Laboratoire' ),
( 12 , 'Agrement' ),
( 13 , 'Microbiologie' ),
( 14 , 'Chargé d \' agrement' );
CREATE TABLE `user` (
`id` int ( 4 ) NOT NULL ,
`login` varchar ( 10 ) DEFAULT NULL ,
`mdp` varchar ( 10 ) DEFAULT NULL
) ENGINE= MyISAM DEFAULT CHARSET= latin1;
INSERT INTO `user` ( `id` , `login` , `mdp` ) VALUES
( 0 , 'zoelihery' , '1234' ),
( 1 , 'Lydia' , 'lydia' );
ALTER TABLE `conge`
ADD PRIMARY KEY ( `id_conge` );
ALTER TABLE `enfant`
ADD PRIMARY KEY ( `id_enfant` );
ALTER TABLE `fiche_conge`
ADD PRIMARY KEY ( `idfiche` );
ALTER TABLE `fiche_permission`
ADD PRIMARY KEY ( `idfiche` );
ALTER TABLE `fonction`
ADD PRIMARY KEY ( `id_fonction` );
ALTER TABLE `mission`
ADD PRIMARY KEY ( `id_mission` );
ALTER TABLE `permission`
ADD PRIMARY KEY ( `id_conge` );
ALTER TABLE `personnel`
ADD PRIMARY KEY ( `id_personnel` );
ALTER TABLE `promotion`
ADD PRIMARY KEY ( `id_permission` );
ALTER TABLE `service`
ADD PRIMARY KEY ( `id_service` );
ALTER TABLE `user`
ADD PRIMARY KEY ( `id` );
ALTER TABLE `conge`
MODIFY `id_conge` int ( 11 ) NOT NULL AUTO_INCREMENT , AUTO_INCREMENT = 10 ;
ALTER TABLE `enfant`
MODIFY `id_enfant` int ( 5 ) NOT NULL AUTO_INCREMENT , AUTO_INCREMENT = 24 ;
ALTER TABLE `fiche_conge`
MODIFY `idfiche` int ( 11 ) NOT NULL AUTO_INCREMENT , AUTO_INCREMENT = 33 ;
ALTER TABLE `fiche_permission`
MODIFY `idfiche` int ( 11 ) NOT NULL AUTO_INCREMENT , AUTO_INCREMENT = 3 ;
ALTER TABLE `fonction`
MODIFY `id_fonction` int ( 5 ) NOT NULL AUTO_INCREMENT , AUTO_INCREMENT = 22 ;
ALTER TABLE `mission`
MODIFY `id_mission` int ( 11 ) NOT NULL AUTO_INCREMENT , AUTO_INCREMENT = 8 ;
ALTER TABLE `permission`
MODIFY `id_conge` int ( 11 ) NOT NULL AUTO_INCREMENT , AUTO_INCREMENT = 13 ;
ALTER TABLE `personnel`
MODIFY `id_personnel` int ( 5 ) NOT NULL AUTO_INCREMENT , AUTO_INCREMENT = 33 ;
ALTER TABLE `promotion`
MODIFY `id_permission` int ( 5 ) NOT NULL AUTO_INCREMENT , AUTO_INCREMENT = 61 ;
ALTER TABLE `service`
MODIFY `id_service` int ( 5 ) NOT NULL AUTO_INCREMENT , AUTO_INCREMENT = 15 ;
COMMIT;
;
;
;
Cordialement!
Configuration: Windows / Firefox 69.0
Afficher la suite
19 oct. 2019 à 09:42
11 nov. 2019 à 09:17