Problème d'insertion à la base [Résolu]

Messages postés
104
Date d'inscription
jeudi 20 mars 2014
Statut
Membre
Dernière intervention
2 décembre 2019
- - Dernière réponse : rasielblas
Messages postés
104
Date d'inscription
jeudi 20 mars 2014
Statut
Membre
Dernière intervention
2 décembre 2019
- 11 nov. 2019 à 09:17
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']))
{ 

//Chargement de la photo

	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))
		{
			//uploade vers le dossier /uploads
			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($_POST['date_emb'], $_POST['mat'],$_POST['nom'],$_POST['prenom'],$_POST['adresse'],$_POST['tel'],$_POST['cin'],$_POST['datecin'],$_POST['lieucin'],$_POST['num_cnaps'],$_POST['nom_banque'],$_POST['num_banque'],$_POST['rib']));
			$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');

		}
					//echo "ajouter pesronnel";
	}
}

		/*	$req->execute(array($_POST['date_emb'], $_POST['mat'],$_POST['nom'],$_POST['prenom'],$_POST['adresse'],$_POST['tel'],$_POST['cin'],$_POST['datecin'],$_POST['lieucin'],$_POST['num_cnaps'],$_POST['nom_banque'],$_POST['num_banque'],$_POST['rib']));
			echo "ajouter pesronnel";
		}*/


 ?>
<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:

-- phpMyAdmin SQL Dump
-- version 4.8.0.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Apr 16, 2019 at 07:40 AM
-- Server version: 10.1.32-MariaDB
-- PHP Version: 5.6.36

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `gpersonnel`
--

-- --------------------------------------------------------

--
-- Table structure for table `conge`
--

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;

--
-- Dumping data for table `conge`
--

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é');

-- --------------------------------------------------------

--
-- Table structure for table `detail_mission`
--

CREATE TABLE `detail_mission` (
  `num_mission` varchar(10) NOT NULL,
  `nom` varchar(150) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `detail_mission`
--

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');

-- --------------------------------------------------------

--
-- Table structure for table `enfant`
--

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;

--
-- Dumping data for table `enfant`
--

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');

-- --------------------------------------------------------

--
-- Table structure for table `fiche_conge`
--

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;

--
-- Dumping data for table `fiche_conge`
--

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);

-- --------------------------------------------------------

--
-- Table structure for table `fiche_permission`
--

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;

--
-- Dumping data for table `fiche_permission`
--

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);

-- --------------------------------------------------------

--
-- Table structure for table `fonction`
--

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;

--
-- Dumping data for table `fonction`
--

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');

-- --------------------------------------------------------

--
-- Table structure for table `mission`
--

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;

--
-- Dumping data for table `mission`
--

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');

-- --------------------------------------------------------

--
-- Table structure for table `permission`
--

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;

--
-- Dumping data for table `permission`
--

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');

-- --------------------------------------------------------

--
-- Table structure for table `personnel`
--

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;

--
-- Dumping data for table `personnel`
--

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);

-- --------------------------------------------------------

--
-- Table structure for table `promotion`
--

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;

--
-- Dumping data for table `promotion`
--

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);

-- --------------------------------------------------------

--
-- Table structure for table `service`
--

CREATE TABLE `service` (
  `id_service` int(5) NOT NULL,
  `nom_service` varchar(30) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `service`
--

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');

-- --------------------------------------------------------

--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `id` int(4) NOT NULL,
  `login` varchar(10) DEFAULT NULL,
  `mdp` varchar(10) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user`
--

INSERT INTO `user` (`id`, `login`, `mdp`) VALUES
(0, 'zoelihery', '1234'),
(1, 'Lydia', 'lydia');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `conge`
--
ALTER TABLE `conge`
  ADD PRIMARY KEY (`id_conge`);

--
-- Indexes for table `enfant`
--
ALTER TABLE `enfant`
  ADD PRIMARY KEY (`id_enfant`);

--
-- Indexes for table `fiche_conge`
--
ALTER TABLE `fiche_conge`
  ADD PRIMARY KEY (`idfiche`);

--
-- Indexes for table `fiche_permission`
--
ALTER TABLE `fiche_permission`
  ADD PRIMARY KEY (`idfiche`);

--
-- Indexes for table `fonction`
--
ALTER TABLE `fonction`
  ADD PRIMARY KEY (`id_fonction`);

--
-- Indexes for table `mission`
--
ALTER TABLE `mission`
  ADD PRIMARY KEY (`id_mission`);

--
-- Indexes for table `permission`
--
ALTER TABLE `permission`
  ADD PRIMARY KEY (`id_conge`);

--
-- Indexes for table `personnel`
--
ALTER TABLE `personnel`
  ADD PRIMARY KEY (`id_personnel`);

--
-- Indexes for table `promotion`
--
ALTER TABLE `promotion`
  ADD PRIMARY KEY (`id_permission`);

--
-- Indexes for table `service`
--
ALTER TABLE `service`
  ADD PRIMARY KEY (`id_service`);

--
-- Indexes for table `user`
--
ALTER TABLE `user`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `conge`
--
ALTER TABLE `conge`
  MODIFY `id_conge` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `enfant`
--
ALTER TABLE `enfant`
  MODIFY `id_enfant` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- AUTO_INCREMENT for table `fiche_conge`
--
ALTER TABLE `fiche_conge`
  MODIFY `idfiche` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;

--
-- AUTO_INCREMENT for table `fiche_permission`
--
ALTER TABLE `fiche_permission`
  MODIFY `idfiche` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `fonction`
--
ALTER TABLE `fonction`
  MODIFY `id_fonction` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `mission`
--
ALTER TABLE `mission`
  MODIFY `id_mission` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `permission`
--
ALTER TABLE `permission`
  MODIFY `id_conge` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `personnel`
--
ALTER TABLE `personnel`
  MODIFY `id_personnel` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;

--
-- AUTO_INCREMENT for table `promotion`
--
ALTER TABLE `promotion`
  MODIFY `id_permission` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=61;

--
-- AUTO_INCREMENT for table `service`
--
ALTER TABLE `service`
  MODIFY `id_service` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;



Cordialement!

Configuration: Windows / Firefox 69.0
Afficher la suite 

1 réponse

Messages postés
26963
Date d'inscription
mercredi 22 octobre 2003
Statut
Modérateur
Dernière intervention
6 décembre 2019
1915
jordane45
Messages postés
26963
Date d'inscription
mercredi 22 octobre 2003
Statut
Modérateur
Dernière intervention
6 décembre 2019
1915 -
Et mets en commentaire la redirection sinon tu ne verras pas l'erreur
rasielblas
Messages postés
104
Date d'inscription
jeudi 20 mars 2014
Statut
Membre
Dernière intervention
2 décembre 2019
-
Merci beaucoup! votre lien m'a beaucoup aidé! c'est donc une mauvaise organisation de code et avec votre lien c'est plus facile de gérer l'erreur avec ce tuto, je marque ce sujet comme résolu! encore merci!
Commenter la réponse de jordane45