function createPriority($db, $priorityType, $languageCode, $title)
{
$check = $db->prepare('SELECT * FROM priority_translation WHERE title = :title');
$check->execute(array(':title' => $title));
if ($priorityExist = $check->fetch()) {
changeStatusPriorityTable($db, $priorityExist['id'], FALSE);
changeStatusPriorityTranslationTable($db, $priorityExist['id'], FALSE);
updatePriority($db, $priorityExist['id'], $priorityType, $title);
} else {
insertIntoPriorityTable($db, $priorityType);
$priorityId = $db->lastInsertId();
insertIntoPriorityTranslationTable($db, $priorityId, $languageCode, $title);
$_SESSION['priority_id'] = $priorityId;
header('Location: categories.php?msg=success');
}
}
<?php
include 'config/autoload.php';
if (!isset($_GET['id'])) {
header('Location: categories.php');
}
$priority = getPriority($db, $_GET['id']);
if (isset($_POST['priorityType']) and isset($_POST['title'])) {
updatePriority($db, $_GET['id'], $_POST['priorityType'], $_POST['title']);
header('Location: categories.php');
}
?>
<h3>Gestion des catégories : domaine, priorité et thème</h3>
<form action="editPriority.php?id=<?php
echo $_GET['id'];
?>
" method="post">
<fieldset>
<legend>Edition de la priorité :</legend>
<select name="priorityType" value="<?php
echo $priority['priority_type'];
?>
">
<option value="Domaine">Domaine</option>
<option value="Fixe">Fixe</option>
<option value="Variable">Variable</option>
</select>
<input type="text" name="title" value="<?php
echo $priority['title'];
