Problème d'affichage d'un lien de téléchargement avec PHP
jus2mandarine
Messages postés
258
Statut
Membre
-
jordane45 Messages postés 40050 Date d'inscription Statut Modérateur Dernière intervention -
jordane45 Messages postés 40050 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 /-
A voir également:
- Problème d'affichage d'un lien de téléchargement avec PHP
- Partager des photos avec un lien - Guide
- Site de telechargement - Accueil - Outils
- Lien url - Guide
- Verificateur de lien - Guide
- Telechargement - Télécharger - Traitement de texte
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;
}
}
?>
