prepare('SELECT username, code_permission FROM users NATURAL JOIN roles NATURAL JOIN roles_has_permissions NATURAL JOIN permissions WHERE code_permission=:perm AND username=:user;'); $query_perm->execute(['user' => $_SESSION["username"], 'perm' => "SFx8"]); if ($query_perm->rowCount() == 1) { $query = $bdd->prepare('SELECT * FROM internships INNER JOIN localisations ON localisations.ID_localisation = internships.ID_localisation INNER JOIN companies ON companies.ID_company = internships.ID_company;'); $query->execute(); $results = $query->fetchALL(PDO::FETCH_OBJ); ?> Stages - CTS
Favoris
name_internship; ?>

Nom de l'entreprise : name_company; ?>

Description du stage : description_internship; ?>

Localisation du stage : city_localisation; ?> postal_code_localisation; ?>

Durée du stage : duration_internship; ?> jours

Rémunération : remuneration_internship; ?>€ / heure

Date de l'offre : offer_date_internship; ?>

Compétences requises : competences_internship; ?>

location.href='/';"; } ?>