Problème d'affichage d'un lien de téléchargement avec PHP

jus2mandarine Messages postés 220 Date d'inscription vendredi 5 juin 2015 Statut Membre Dernière intervention 1 décembre 2023 - 16 oct. 2023 à 20:05
jordane45 Messages postés 38151 Date d'inscription mercredi 22 octobre 2003 Statut Modérateur Dernière intervention 2 mai 2024 - 18 oct. 2023 à 22:31

Bonjour Chers tous,

J'ai un problème avec un code PHP. Il permet de télécharger un fichier

Quand je clique sur le bouton Télécharger (voir l'image ci-dessous) :

Voici ce qui s'affiche :

Le code complet est ci-dessous, et la partie qui permet le téléchargement se situe entre la ligne 141 et 145

<?php 
global $mydb;
	$red_id = isset($_GET['id']) ? $_GET['id'] : '';

	//$expcandidat = New Expcandidat(); 
	//$exp = $expcandidat->single_applicant($red_id);
	 // `COMPANYID`, `JOBID`, `APPLICANTID`, `APPLICANT`, `REGISTRATIONDATE`, `REMARKS`, `FILEID`, `PENDINGAPPLICATION`

	$applicant = new Expcandidat();
	$appl = $applicant->single_applicant($red_id);
 // `FNAME`, `LNAME`, `MNAME`, `ADDRESS`, `SEX`, `CIVILSTATUS`, `BIRTHDATE`, `BIRTHPLACE`, `AGE`, `USERNAME`, `PASS`, `EMAILADDRESS`,CONTACTNO

	//$jobvacancy = New Jobs();
	//$job = $jobvacancy->single_job($jobreg->JOBID);
 // `COMPANYID`, `CATEGORY`, `OCCUPATIONTITLE`, `REQ_NO_EMPLOYEES`, `SALARIES`, `DURATION_EMPLOYEMENT`, `QUALIFICATION_WORKEXPERIENCE`, `JOBDESCRIPTION`, `PREFEREDSEX`, `SECTOR_VACANCY`, `JOBSTATUS`, `DATEPOSTED`

	//$company = new Company();
	//$comp = $company->single_company($jobreg->COMPANYID);
	 // `COMPANYNAME`, `COMPANYADDRESS`, `COMPANYCONTACTNO`

	/*$sql = "SELECT * FROM `tblattachmentfile` WHERE `FILEID`=" .$jobreg->FILEID;
	$mydb->setQuery($sql);
	$attachmentfile = $mydb->loadSingleResult();*/

?> 
<style type="text/css">
.content-header {
	min-height: 50px;
	border-bottom: 1px solid #ddd;
	font-size: 15px;
	font-weight: bold;
}
.content-body {
	min-height: 350px;
	/*border-bottom: 1px solid #ddd;*/
}
.content-body >p {
	padding:10px;
	font-size: 12px;
	font-weight: bold;
	border-bottom: 1px solid #ddd;
}
.content-footer {
	min-height: 100px;
	border-top: 1px solid #ddd;

}
.content-footer > p {
	padding:5px;
	font-size: 15px;
	font-weight: bold; 
}
 
.content-footer textarea {
	width: 100%;
	height: 200px;
}
.content-footer  .submitbutton{  
	margin-top: 20px;
	/*padding: 0;*/

}
</style>
<form action="controller.php?action=approve" method="POST">
<div class="col-sm-12 content-header" style=""> Details experiences professionnelles du candidat</div>
<div class="col-sm-6 content-body" > 
	<p>Parcourt professionnel</p> 

    <input type="hidden" name="APPLICANTID" value="<?php echo $appl->APPLICANTID;?>">

    <div class="col-sm-6">
		<p>Description des compétences : </p>   
		<p style="margin-left: 15px;"><?php echo $appl->DEGREE;?></p>
	</div>


	<div class="col-sm-6">
		<p>Qualifications principales : </p>  
		<ul>
            <li><i class="fp-ht-bed"></i>Fonction : <?php echo $appl->FONCTION; ?></li>
            <li><i class="fp-ht-food"></i>Entreprise actuelle : <?php echo $appl->ENTREPRISE; ?></li>
            <li><i class="fa fa-sun-"></i>Poste occupé: <?php echo $appl->POSTEOCCUPE; ?></li>
        </ul>
	</div> 

	<div class="col-sm-6">
		<p>Experiences professionnelles : </p> 
		<ul> 
            <li><i class="fp-ht-tv"></i>De : <?php echo $appl->annee_deb_exp1; ?> à <?php echo $appl->annee_fin_exp1; ?></li>
            <li><i class="fp-ht-computer"></i>Lieu travaillé : <?php echo $appl->LIEUTRA1; ?></li>
        </ul>
	</div>
	<div class="col-sm-6">
		<p>Description experience : </p>   
		<p style="margin-left: 15px;"><?php echo $appl->DESCRIPEXP1;?></p>
	</div>

	<div class="col-sm-6">
		<ul> 
            <li><i class="fp-ht-tv"></i>De : <?php echo $appl->annee_deb_exp2; ?> à <?php echo $appl->annee_fin_exp2; ?></li>
            <li><i class="fp-ht-computer"></i>Lieu travaillé : <?php echo $appl->LIEUTRA2; ?></li>
        </ul>
	</div>
	<div class="col-sm-6">
		<p>Description experience : </p>   
		<p style="margin-left: 15px;"><?php echo $appl->DESCRIPEXP2;?></p>
	</div>

	<div class="col-sm-6">
		<ul> 
            <li><i class="fp-ht-tv"></i>De : <?php echo $appl->annee_deb_exp3; ?> à <?php echo $appl->annee_fin_exp3; ?></li>
            <li><i class="fp-ht-computer"></i>Lieu travaillé : <?php echo $appl->LIEUTRA3; ?></li>
        </ul>
	</div>
	<div class="col-sm-12">
		<p> Description experience : </p>   
		<p style="margin-left: 15px;"><?php echo $appl->DESCRIPEXP3;?></p>
	</div>


</div>
	

<div class="col-sm-6 content-body" >
	<p>Informations personnelles</p> 
	<h3> <?php echo $appl->LNAME. ', ' .$appl->FNAME . ' ' . $appl->MNAME;?></h3>
	<ul> 
		<li>Email    : <?php echo $appl->EMAILADDRESS;?></li>
		<li>Sexe  : <?php echo $appl->SEX;?></li>
		<li>Date naissance : <?php echo $appl->BIRTHDATE;?></li> 
		<li>Civilité : <?php echo $appl->CIVILSTATUS;?></li> 
	</ul>
	<div class="col-sm-12"> 
		<p>Niveau d'étude : </p>
		<p style="margin-left: 15px;"><?php echo $appl->DEGREE;?></p>
	</div>


</div> 

<div class="col-sm-12 content-footer">
<p><i class="fa fa-paperclip"></i> Fichier joint par le candidat</p>
	<div class="col-sm-12 slider">
		<h3><a href="<?php echo $appl->picture; ?>">Télécharger</a> le fichier joint par le candidat</h3> 
	</div> 

	
</div>
</form>

Merci pour votre support /-

A voir également:

3 réponses

jordane45 Messages postés 38151 Date d'inscription mercredi 22 octobre 2003 Statut Modérateur Dernière intervention 2 mai 2024 4 652
16 oct. 2023 à 20:28

Bonjour

Pas d'erreur dans le code visiblement...

As-tu vérifié que ton image se trouvait bien à la racine de ton site, et si elle s'orthographie exactement de la même manière y compris les majuscules et les minuscules ?


0
jus2mandarine Messages postés 220 Date d'inscription vendredi 5 juin 2015 Statut Membre Dernière intervention 1 décembre 2023
Modifié le 18 oct. 2023 à 15:14

Bonjour Jordane,

Tu as raison ! Le code ne comporte d'erreur. Je me suis rendu compte que l'erreur se situe du code php/MySQL qui doit permettre le transfert du fichier dans le dossier racine. À  ce sujet, puis-je avoir un modèle ? 

L'enregistrement d'un fichier sur le formulaire (de la base de données) ne permet pas de transférer le fichier dans le dossier source.

Ci-dessous, le code qui permet l'enregistrement du formulaire et l'importation d'un

fichier de l'ordinateur dans ce formulaire afin de l'enregistrer dans un dossier du site.

<!-- <div class="form-group">
  <div class="col-md-11">
  <label class="col-md-4 control-label" for=
    "NATIONALID">NationalID:</label>

    <div class="col-md-8"> 
       <input class="form-control " id="NATIONALID" name="NATIONALID" placeholder=
          "00-000000000000" type="text" value=""  onkeyup="javascript:capitalize(this.id, this.value);" >
    </div>
  </div>
</div> -->
<style type="text/css">
.form-control-2 {
  display: inline-block;
  width: 25%;
  padding: 0.375rem 0.75rem;
  font-size: 1rem;
  line-height: 1.5;
  color: #495057;
  background-color: #fff;
  background-clip: padding-box;
  border: 1px solid #ced4da;
  border-radius: 0.25rem;
  -webkit-transition: border-color 0.15s ease-in-out, -webkit-box-shadow 0.15s ease-in-out;
  transition: border-color 0.15s ease-in-out, -webkit-box-shadow 0.15s ease-in-out;
  -o-transition: border-color 0.15s ease-in-out, box-shadow 0.15s ease-in-out;
  transition: border-color 0.15s ease-in-out, box-shadow 0.15s ease-in-out;
  transition: border-color 0.15s ease-in-out, box-shadow 0.15s ease-in-out, -webkit-box-shadow 0.15s ease-in-out; }
   
</style>

<?php 
if (!isset($_SESSION['APPLICANTID'])) {
?>

            <form action="#" class="bg-white p-5 contact-form">

              <div class="form-group">
               <input name="JOBID" type="hidden" value="<?php echo $_GET['job'];?>">
               <input class="form-control " id="FNAME" name="FNAME" placeholder=
                  "Prénom(s)" type="text" value=""  onkeyup="javascript:capitalize(this.id, this.value);" >
              </div>

              <div class="form-group">
                   <input  class="form-control " id="LNAME" name="LNAME" placeholder="Nom(s)" type="text" onkeyup="javascript:capitalize(this.id, this.value);" >
              </div>

              <div class="form-group">
                <!--input  class="form-control " id="MNAME" name="MNAME" placeholder="Autres noms" onkeyup="javascript:capitalize(this.id, this.value);" --> 
              </div>

              <div class="form-group"> 
                  <textarea class="form-control " id="ADDRESS" name="ADDRESS" placeholder="Adresse" type="text" value="" required  onkeyup="javascript:capitalize(this.id, this.value);" ></textarea>
              </div>

              <div class="form-group">   
                Sexe: 
                    <input checked id="optionsRadios1" checked="True" name="optionsRadios" type="radio" value="Feminin"> Feminin 
                      <input id="optionsRadios2"   name="optionsRadios" type="radio" value="Masculin"> Masculin   
              </div>


    <div class="form-group">  Date naissance  
        <select class="form-control-2" name="month">
          <option>Mois</option>
          <?php

             $mon = array('Jan' => 1 ,'Feb'=> 2,'Mar' => 3 ,'Apr'=> 4,'May' => 5 ,'Jun'=> 6,'Jul' => 7 ,'Aug'=> 8,'Sep' => 9 ,'Oct'=> 10,'Nov' => 11 ,'Dec'=> 11 );    
          
        
            foreach ($mon as $month => $value ) {
              
                  # code...
                   echo '<option value='.$value.'>'.$month.'</option>';
                } 
          ?>
        </select> 

        <select class="form-control-2" name="day">
          <option>jour</option>
        <?php 
          $d = range(31, 1);
          foreach ($d as $day) {
            echo '<option value='.$day.'>'.$day.'</option>';
          }
        
        ?>
          
        </select> 

        <select class="form-control-2" name="year">
          <option>Année</option>
        <?php 
          $years = range(2023, 1900);
          foreach ($years as $yr) {
            echo '<option value='.$yr.'>'.$yr.'</option>';
          }
        
        ?>
        
        </select>
      </div> 
 
              <div class="form-group">  
                <textarea class="form-control " id="BIRTHPLACE" name="BIRTHPLACE" placeholder= "Lieu de naissance" type="text" value="" required  onkeyup="javascript:capitalize(this.id, this.value);" ></textarea>
              </div>

              <div class="form-group"> 
                 <input class="form-control " id="TELNO" name="TELNO" placeholder= "Telephone" type="text" any value="" required  onkeyup="javascript:capitalize(this.id, this.value);" >
              </div>

              <div class="form-group">
                    <select class="form-control " name="CIVILSTATUS" id="CIVILSTATUS">
                        <option value="none" >Civilité</option>
                        <option value="Celibatire">Célibataire</option>
                        <option value="Marié(e)">Marié(e)</option>
                        <option value="Veuve(f)" >Veuve(f)</option> 
                    </select> 
                
              </div>

              <div class="form-group">
                   <input type="email" class="form-control " id="EMAILADDRESS" name="EMAILADDRESS" placeholder="Email" autocomplete="false"/>  
              </div>

              <div class="form-group">
                 <input  class="form-control" type="text" id="USERNAME" name="USERNAME" placeholder="Nom utilisateur" onkeyup="javascript:capitalize(this.id, this.value);" >
                
              </div>

              <div class="form-group">
                   <input  class="form-control " id="PASS" name="PASS" placeholder="Mot de passe" type="password" onkeyup="javascript:capitalize(this.id, this.value);" > 
              </div>


               <div class="panel-header">
                              <div style="padding: 10px;font-size: 25px;font-weight: bold;color: #000;margin-bottom: 5px;">
                                <span >+ Description des competences</span> 
                              </div> 
                         </div>


              <div class="form-group">
                  <input  class="form-control" type="text" id="DEGREE" name="DEGREE" placeholder="Niveau d'etude" onkeyup="javascript:capitalize(this.id, this.value);" >
              </div>

               <div class="form-group">
                  <input  class="form-control" type="text" id="DOMET" name="DOMET" placeholder="Domaine d'etude/Compétence" onkeyup="javascript:capitalize(this.id, this.value);" >
              </div>

               <div class="panel-header">
                              <div style="padding: 10px;font-size: 25px;font-weight: bold;color: #000;margin-bottom: 5px;">
                                <span >+ Qualifications principales</span> 
                              </div> 
                         </div>


                 <div class="form-group">
                  <input  class="form-control" type="text" id="FONCTION" name="FONCTION" placeholder="Fonction" onkeyup="javascript:capitalize(this.id, this.value);" >
              </div>


               <div class="form-group">
                  <input  class="form-control" type="text" id="ENTREPRISE" name="ENTREPRISE" placeholder="Entreprise actuelle" onkeyup="javascript:capitalize(this.id, this.value);" >
              </div>

              <div class="form-group">
                  <input  class="form-control" type="text" id="POSTEOCCUPE" name="POSTEOCCUPE" placeholder="Poste occupé" onkeyup="javascript:capitalize(this.id, this.value);" >
              </div>


              <div class="panel-header">
                              <div style="padding: 10px;font-size: 25px;font-weight: bold;color: #000;margin-bottom: 5px;">
                                <span >+ Experiences professionnelles</span> 
                              </div> 
                         </div>

                 <div class="form-group">
                     <!--input  class="form-control" type="year" id="LIEUTRA1" name="LIEUTRA1" placeholder="Lieu travail excuté" onkeyup="javascript:capitalize(this.id, this.value);" -->
                     De <select class="form-control-2" name="$annee_deb_exp1">
                           <option>Année</option>
                    <?php 
                      $years = range(2023, 1900);
                      foreach ($years as $yr) {
                        echo '<option value='.$yr.'>'.$yr.'</option>';
                      }
                    
                    ?>
                    
                      </select>

                       à <select class="form-control-2" name="$annee_fin_exp1">
                           <option>Année</option>
                    <?php 
                      $years = range(2023, 1900);
                      foreach ($years as $yr) {
                        echo '<option value='.$yr.'>'.$yr.'</option>';
                      }
                    
                    ?>
                    
                      </select>
              </div>

              <div class="form-group">
                  <input  class="form-control" type="text" id="LIEUTRA1" name="LIEUTRA1" placeholder="Lieu travail excuté" onkeyup="javascript:capitalize(this.id, this.value);" >
              </div>

             <div class="form-group">  
                <textarea class="form-control " id="DESCRIPEXP1" name="DESCRIPEXP1" placeholder= "Description de votre experience" type="text" value=""  onkeyup="javascript:capitalize(this.id, this.value);" ></textarea>
              </div>


               <div class="form-group">
                     De <select class="form-control-2" name="$annee_deb_exp2">
                           <option>Année</option>
                    <?php 
                      $years = range(2023, 1900);
                      foreach ($years as $yr) {
                        echo '<option value='.$yr.'>'.$yr.'</option>';
                      }
                    
                    ?>
                    
                      </select>

                       à <select class="form-control-2" name="$annee_fin_exp2">
                           <option>Année</option>
                    <?php 
                      $years = range(2023, 1900);
                      foreach ($years as $yr) {
                        echo '<option value='.$yr.'>'.$yr.'</option>';
                      }
                    
                    ?>
                    
                      </select>
              </div>

              <div class="form-group">
                  <input  class="form-control" type="text" id="LIEUTRA2" name="LIEUTRA2" placeholder="Lieu travail excuté" onkeyup="javascript:capitalize(this.id, this.value);" >
              </div>

             <div class="form-group">  
                <textarea class="form-control" id="DESCRIPEXP2" name="DESCRIPEXP2" placeholder= "Description de votre experience" type="text" value=""  onkeyup="javascript:capitalize(this.id, this.value);" ></textarea>
              </div>


               <div class="form-group">
                     De <select class="form-control-2" name="$annee_deb_exp3">
                           <option>Année</option>
                    <?php 
                      $years = range(2023, 1900);
                      foreach ($years as $yr) {
                        echo '<option value='.$yr.'>'.$yr.'</option>';
                      }
                    
                    ?>
                    
                      </select>

                       à <select class="form-control-2" name="$annee_fin_exp3">
                           <option>Année</option>
                    <?php 
                      $years = range(2023, 1900);
                      foreach ($years as $yr) {
                        echo '<option value='.$yr.'>'.$yr.'</option>';
                      }
                    
                    ?>
                    
                    </select>
              </div>

              <div class="form-group">
                  <input  class="form-control" type="text" id="LIEUTRA3" name="LIEUTRA3" placeholder="Lieu travail excuté" onkeyup="javascript:capitalize(this.id, this.value);" >
              </div>

             <div class="form-group">  
                <textarea class="form-control " id="DESCRIPEXP3" name="DESCRIPEXP3" placeholder= "Description de votre experience" type="text" value=""  onkeyup="javascript:capitalize(this.id, this.value);" ></textarea>
              </div> 


             <div class="form-group"> 
                 Attachez votre CV ci-dessous. 
                    <input id="picture" name="picture" type="file"  >
                    <input name="MAX_FILE_SIZE" type="hidden" value="1000000"> 
            </div>  

              <div class="form-group">
                <input type="checkbox"> En s'inscrivant, vous acceptez nos <a href="#">termes et conditions</a> 
              </div> 

              <div class="form-group">
                <input type="submit" value="Postuler maintenant" name="submit" class="btn btn-primary py-3 px-5">
              </div>
            </form>

 <?php }else{ ?> 

   <div class="col-md-12">
                   <div class="row"> 
 
                    <form class="form-horizontal span6 " action="process.php?action=submitapplication&JOBID=<?php echo $result->JOBID; ?>"  enctype="multipart/form-data"  method="POST">
                        <div class="col-md-12">
                            <div class="row">
                                <div class="panel panel-default">

                                    <div class="panel-header">
                                        <div style="border-bottom: 1px solid #ddd;padding: 10px;font-size: 25px;font-weight: bold;color: #000;margin-bottom: 5px;">Attachez votre CV ci-dessous
                                            <input name="JOBID" type="hidden" value="<?php echo $_GET['job'];?>">
                                        </div>
                                    </div>

                                    <div class="panel-body"> 
                                        <label class="col-md-2" for="picture" style="padding: 0;margin: 0;"></label> 
                                        <div class="col-md-10" style="padding: 0;margin: 0;">
                                           <p>  <input id="picture" name="picture" type="file"> </p>
                                            <input name="MAX_FILE_SIZE" type="hidden" value="1000000"> 
                                        </div> 
                                    </div>

                                </div> 
                            </div> 
                        </div>
                        
                       <div class="form-group">
                        <div class="col-md-12"> 
                             <button class="btn btn-primary btn-md pull-right" name="submit" type="submit" >Postuler maintenant <span class="fa fa-arrow-right"></span></button>
                          <a href="index.php" class="btn btn-info"><span class="fa fa-arrow-left"></span>&nbsp;<strong>Annuler</strong></a> 
                        </div>
                       </div>

                    </form>
                     
                       
                </div>
            </div> 


    <?php } ?>

Merci de votre support /-

0
jordane45 Messages postés 38151 Date d'inscription mercredi 22 octobre 2003 Statut Modérateur Dernière intervention 2 mai 2024 4 652
18 oct. 2023 à 17:11

Quel est le code du fichier  process.php  ?

A noter que, des exemple d'upload de fichiers en php .... tu en trouveras sans mal des dizaines sur internet...

0
jus2mandarine Messages postés 220 Date d'inscription vendredi 5 juin 2015 Statut Membre Dernière intervention 1 décembre 2023
18 oct. 2023 à 18:49

ci-dessous, le contenu du fichier process.php

<?php  
require_once ("include/initialize.php");
$action = (isset($_GET['action']) && $_GET['action'] != '') ? $_GET['action'] : '';

switch ($action) {
	case 'submitapplication' :
	doSubmitApplication();
	break;
  
	case 'register' :
	doRegister(); 
	break; 

	case 'enreg' :
	doEnreg(); 
	break;   

	case 'login' :
	doLogin();
	break; 
	}

function doSubmitApplication() { 
	global $mydb;   
		$jobid  = $_GET['JOBID'];
		

		$autonum = New Autonumber();
		$applicantid = $autonum->set_autonumber('APPLICANT');

		$autonum = New Autonumber();
		$fileid = $autonum->set_autonumber('FILEID');

		@$picture = UploadImage();
		@$location = "photos/". $picture ;


		if ($picture=="") {
			# code...
			redirect(web_root."index.php?q=apply&job=".$jobid."&view=personalinfo");
		}else{ 
			
			if (isset($_SESSION['APPLICANTID'])) {

				$sql = "INSERT INTO `tblattachmentfile` (FILEID,`USERATTACHMENTID`, `FILE_NAME`, `FILE_LOCATION`, `JOBID`) 
				VALUES ('". date('Y').$fileid->AUTO."','{$_SESSION['APPLICANTID']}','CV','{$location}','{$jobid}')";
				$mydb->setQuery($sql); 
				 

				doUpdate($jobid,$fileid->AUTO);


				
			}else{
				 
				$sql = "INSERT INTO `tblattachmentfile` (FILEID,`USERATTACHMENTID`, `FILE_NAME`, `FILE_LOCATION`, `JOBID`) 
				VALUES ('". date('Y').$fileid->AUTO."','". date('Y').$applicantid->AUTO."','CV','{$location}','{$jobid}')";
				$mydb->setQuery($sql); 
				 

				doInsert($jobid,$fileid->AUTO); 

				$autonum = New Autonumber();
				$autonum->auto_update('APPLICANT'); 
			}
		} 
}

function doInsert($jobid=0,$fileid=0) {
	if (isset($_POST['submit'])) {  
	global $mydb; 


      $date1 = DateTime::createFromFormat('Y', $_POST['annee_deb_exp1']);
      $date2 = DateTime::createFromFormat('Y',$_POST['annee_fin_exp1']);
      
      $date3 = DateTime::createFromFormat('Y', $_POST['annee_deb_exp2']);
      $date4 = DateTime::createFromFormat('Y', $_POST['annee_fin_exp2']);

      $date5 = DateTime::createFromFormat('Y', $_POST['annee_deb_exp3']);
      $date6 = DateTime::createFromFormat('Y',$_POST['annee_fin_exp3']);


			$birthdate =  $_POST['year'].'-'.$_POST['month'].'-'.$_POST['day'];


			$age = date_diff(date_create($birthdate), date_create('today'))->y;

			if ($age < 20){
			message("Age invalide. 20 ans et plus accepté.", "error");
			redirect("index.php?q=apply&view=personalinfo&job=".$jobid);

			}else{ 

			$autonum = New Autonumber();
			$auto = $autonum->set_autonumber('APPLICANT');
			 
			$applicant =New Applicants();
			$applicant->APPLICANTID = date('Y').$auto->AUTO;
			$applicant->FNAME = $_POST['FNAME'];
			$applicant->LNAME = $_POST['LNAME'];
			//$applicant->MNAME = $_POST['MNAME'];
			$applicant->ADDRESS = $_POST['ADDRESS'];
			$applicant->SEX = $_POST['optionsRadios'];
			$applicant->CIVILSTATUS = $_POST['CIVILSTATUS'];
			$applicant->BIRTHDATE = $birthdate;
			$applicant->BIRTHPLACE = $_POST['BIRTHPLACE'];
			$applicant->AGE = $age;
			$applicant->USERNAME = $_POST['USERNAME'];
			$applicant->PASS = sha1($_POST['PASS']);
			$applicant->EMAILADDRESS = $_POST['EMAILADDRESS'];
			$applicant->CONTACTNO = $_POST['TELNO'];
			$applicant->DEGREE = $_POST['DEGREE'];
      
      //Ajout des champs
      $applicant->DOMET = $_POST['DOMET'];
      $applicant->FONCTION = $_POST['FONCTION'];
      $applicant->ENTREPRISE = $_POST['ENTREPRISE'];
      $applicant->POSTEOCCUPE = $_POST['POSTEOCCUPE'];

      $applicant->annee_deb_exp1 = $date1;
      $applicant->annee_fin_exp1 = $date2;
      $applicant->LIEUTRA1 = $_POST['LIEUTRA1'];
      $applicant->DESCRIPEXP1 = $_POST['DESCRIPEXP1'];

      $applicant->annee_deb_exp2 = $date3;
      $applicant->annee_fin_exp2 = $date4;
      $applicant->LIEUTRA2 = $_POST['LIEUTRA2'];
      $applicant->DESCRIPEXP2 = $_POST['DESCRIPEXP2'];

      $applicant->annee_deb_exp3 =  $date5;
      $applicant->annee_fin_exp3 = $date6;
      $applicant->LIEUTRA3 = $_POST['LIEUTRA3'];
      $applicant->DESCRIPEXP3 = $_POST['DESCRIPEXP3'];
			$applicant->create();


			$sql = "SELECT * FROM `tblcompany` c,`tbljob` j WHERE c.`COMPANYID`=j.`COMPANYID` AND JOBID = '{$jobid}'" ;
			$mydb->setQuery($sql);
			$result = $mydb->loadSingleResult();


			$jobreg = New JobRegistration(); 
			$jobreg->COMPANYID = $result->COMPANYID;
			$jobreg->JOBID     = $result->JOBID;
			$jobreg->APPLICANTID = date('Y').$auto->AUTO;
			$jobreg->APPLICANT   = $_POST['FNAME'] . ' ' . $_POST['LNAME'];
			$jobreg->REGISTRATIONDATE = date('Y-m-d');
			$jobreg->FILEID = date('Y').$fileid;
			$jobreg->REMARKS = 'En attente';
			$jobreg->DATETIMEAPPROVED = date('Y-m-d H:i');
			$jobreg->create();



		  $autonum = New Autonumber();
	    $autonum->auto_update('FILEID'); 
  

			message("Votre demande a été bien soumise. Patientez que l'entreprise vous confirme si vous êtes qualifiés pour cet offre d'empoi.","success");
			redirect("index.php?q=success&job=".$result->JOBID);

			
	 }
}
}
function doUpdate($jobid=0,$fileid=0) {
	if (isset($_POST['submit'])) {
	global $mydb;   

			$applicant =New Applicants();
			$appl  = $applicant->single_applicant($_SESSION['APPLICANTID']);

			 

			$sql = "SELECT * FROM `tblcompany` c,`tbljob` j WHERE c.`COMPANYID`=j.`COMPANYID` AND JOBID = '{$jobid}'" ;
			$mydb->setQuery($sql);
			$result = $mydb->loadSingleResult();


			$jobreg = New JobRegistration(); 
			$jobreg->COMPANYID = $result->COMPANYID;
			$jobreg->JOBID     = $result->JOBID;
			$jobreg->APPLICANTID = $appl->APPLICANTID;
			$jobreg->APPLICANT   = $appl->FNAME . ' ' . $appl->LNAME;
			$jobreg->REGISTRATIONDATE = date('Y-m-d');
			$jobreg->FILEID = date('Y').$fileid;
			$jobreg->REMARKS = 'En attente';
			$jobreg->DATETIMEAPPROVED = date('Y-m-d H:i');
			$jobreg->create();

			$autonum = New Autonumber();
	   		$autonum->auto_update('FILEID'); 

  
			message("Votre demande a été bien soumise. Patientez que l'entreprise vous confirme si vous êtes qualifiés pour cet offre d'empoi.","success");
			redirect("index.php?q=success&job=".$result->JOBID);
 
	}
}

function doRegister(){
	global $mydb;
	if (isset($_POST['btnRegister'])) { 
			$birthdate =  $_POST['year'].'-'.$_POST['month'].'-'.$_POST['day'];

			$age = date_diff(date_create($birthdate),date_create('today'))->y;

			if ($age < 20){
			message("Age invalide. 20 ans et plus accepté.", "error");
			redirect("index.php?q=register");

			}else{

			$autonum = New Autonumber();
			$auto = $autonum->set_autonumber('APPLICANT');
			 
			$applicant =New Applicants();
			$applicant->APPLICANTID = date('Y').$auto->AUTO;
			$applicant->FNAME = $_POST['FNAME'];
			$applicant->LNAME = $_POST['LNAME'];
			$applicant->MNAME = $_POST['MNAME'];
			$applicant->ADDRESS = $_POST['ADDRESS'];
			$applicant->SEX = $_POST['optionsRadios'];
			$applicant->CIVILSTATUS = $_POST['CIVILSTATUS'];
			$applicant->BIRTHDATE = $birthdate;
			$applicant->BIRTHPLACE = $_POST['BIRTHPLACE'];
			$applicant->AGE = $age;
			$applicant->USERNAME = $_POST['USERNAME'];
			$applicant->PASS = sha1($_POST['PASS']);
			$applicant->EMAILADDRESS = $_POST['EMAILADDRESS'];
			$applicant->CONTACTNO = $_POST['TELNO'];
			$applicant->DEGREE = $_POST['DEGREE'];
			$applicant->create();


 
			$autonum = New Autonumber();
			$autonum->auto_update('APPLICANT');


			message("Inscription effectuée. Se connecter maintenant!","success");
			redirect("index.php?q=success");

			
	 }
 }
}


function doEnreg(){
	global $mydb;
	if (isset($_POST['btnRegister'])) { 


      $date1 = DateTime::createFromFormat('Y', $_POST['annee_deb_exp1']);
      $date2 = DateTime::createFromFormat('Y',$_POST['annee_fin_exp1']);
      
      $date3 = DateTime::createFromFormat('Y', $_POST['annee_deb_exp2']);
      $date4 = DateTime::createFromFormat('Y', $_POST['annee_fin_exp2']);

      $date5 = DateTime::createFromFormat('Y', $_POST['annee_deb_exp3']);
      $date6 = DateTime::createFromFormat('Y',$_POST['annee_fin_exp3']);


			$birthdate =  $_POST['year'].'-'.$_POST['month'].'-'.$_POST['day'];

		
			$age = date_diff(date_create($birthdate),date_create('today'))->y;

			if ($age < 20){
			message("Age invalide. 20 ans et plus accepté.", "error");
			redirect("index.php?q=enreg");

			}else{

			$autonum = New Autonumber();
			$auto = $autonum->set_autonumber('APPLICANT');
			 
			$applicant =New Expcandidat();
			$applicant->APPLICANTID = date('Y').$auto->AUTO;
			$applicant->FNAME = $_POST['FNAME'];
			$applicant->LNAME = $_POST['LNAME'];
			$applicant->MNAME = $_POST['MNAME'];
			//$applicant->ADDRESS = $_POST['ADDRESS'];
			$applicant->SEX = $_POST['optionsRadios'];
			$applicant->CIVILSTATUS = $_POST['CIVILSTATUS'];
			$applicant->BIRTHDATE = $birthdate;
			$applicant->BIRTHPLACE = $_POST['BIRTHPLACE'];
			$applicant->AGE = $age;
			
			$applicant->EMAILADDRESS = $_POST['EMAILADDRESS'];
			//$applicant->CONTACTNO = $_POST['TELNO'];
			$applicant->DEGREE = $_POST['DEGREE'];

			$applicant->FONCTION = $_POST['FONCTION'];
      $applicant->ENTREPRISE = $_POST['ENTREPRISE'];
      $applicant->POSTEOCCUPE = $_POST['POSTEOCCUPE'];

      $applicant->annee_deb_exp1 = $date1;
      $applicant->annee_fin_exp1 = $date2;
      $applicant->LIEUTRA1 = $_POST['LIEUTRA1'];
      $applicant->DESCRIPEXP1 = $_POST['DESCRIPEXP1'];

      $applicant->annee_deb_exp2 = $date3;
      $applicant->annee_fin_exp2 = $date4;
      $applicant->LIEUTRA2 = $_POST['LIEUTRA2'];
      $applicant->DESCRIPEXP2 = $_POST['DESCRIPEXP2'];

      $applicant->annee_deb_exp3 =  $date5;
      $applicant->annee_fin_exp3 = $date6;
      $applicant->LIEUTRA3 = $_POST['LIEUTRA3'];
      $applicant->DESCRIPEXP3 = $_POST['DESCRIPEXP3'];

       $applicant->picture = $_POST['picture'];
       $applicant->FILE_LOCATION = $_POST['FILE_LOCATION'];
			$applicant->create();


 
			$autonum = New Autonumber();
			$autonum->auto_update('APPLICANT');


			message("Merci d'envoyer vos informations!","success");
			redirect("index.php?q=success");

			
	 }
 }
}


function doLogin(){
	
	$email = trim($_POST['USERNAME']);
	$upass  = trim($_POST['PASS']);
	$h_upass = sha1($upass);
 
  //it creates a new objects of member
    $applicant = new Applicants(); 
    //make use of the static function, and we passed to parameters
    $res = $applicant->applicantAuthentication($email, $h_upass);
    if ($res==true) { 

       	message("Connexion à votre compte établie!","success");
       
       // $sql="INSERT INTO `tbllogs` (`USERID`,USERNAME, `LOGDATETIME`, `LOGROLE`, `LOGMODE`) 
       //    VALUES (".$_SESSION['USERID'].",'".$_SESSION['FULLNAME']."','".date('Y-m-d H:i:s')."','".$_SESSION['UROLE']."','Logged in')";
       //    mysql_query($sql) or die(mysql_error()); 
         redirect(web_root."applicant/");
     
    }else{
    	 echo "Ce compte n'existe pas! Contactez l'administrateurr."; 
    } 
}
 
function UploadImage($jobid=0){
	$target_dir = "applicant/photos/";
	$target_file = $target_dir . date("dmYhis") . basename($_FILES["picture"]["name"]);
	$uploadOk = 1;
	$imageFileType = pathinfo($target_file,PATHINFO_EXTENSION);
	
	
	if($imageFileType != "jpg" || $imageFileType != "png" || $imageFileType != "jpeg"
|| $imageFileType != "gif" ) {
		 if (move_uploaded_file($_FILES["picture"]["tmp_name"], $target_file)) {
			return  date("dmYhis") . basename($_FILES["picture"]["name"]);
		}else{
			message("Error Uploading File","error");
			// redirect(web_root."index.php?q=apply&job=".$jobid."&view=personalinfo");
			// exit;
		}
	}else{
			message("File Not Supported","error");
			// redirect(web_root."index.php?q=apply&job=".$jobid."&view=personalinfo");
			// exit;
		}
} 


?>
0
jordane45 Messages postés 38151 Date d'inscription mercredi 22 octobre 2003 Statut Modérateur Dernière intervention 2 mai 2024 4 652
18 oct. 2023 à 22:31

Et bien... le code semble bon pour ce qui est du chargement de l'image sur le serveur...

Quel souci rencontres tu exactement ?

As tu essayé de debuguer ton code pour voir ce qu'il faisait ?

D'ailleurs... est-ce bien..."ton code" et le comprends tu ??

0