Problème d'affichage d'un lien de téléchargement avec PHP
jus2mandarine
Messages postés
258
Statut
Membre
-
jordane45 Messages postés 30426 Date d'inscription Statut Modérateur Dernière intervention -
jordane45 Messages postés 30426 Date d'inscription Statut Modérateur Dernière intervention -
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 /-
3 réponses
-
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 ?
-
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> <strong>Annuler</strong></a> </div> </div> </form> </div> </div> <?php } ?>Merci de votre support /-
-
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; } } ?>
