public static function getNoteById($bdd, $id) { $note = $bdd->prepare('SELECT * FROM note_frais WHERE id = :id LIMIT 1'); $note->execute(array(':id' => $id)); $array = $note->fetch(); $CloneNote = new Note(); $CloneNote->setDate($array['date']); $CloneNote->setId($array['id']); $CloneNote->setName($array['name']); $CloneNote->setStatut($array['statut_id']); $CloneNote->setUser($array['user_id']); return $CloneNote; }
$note_name = $_POST[$namenote]; if (isset($note_name) && !empty($note_name)) { $namenote = htmlentities($note_name); $statutnote = htmlentities($_POST['statut']); $nid = $_GET['id']; Note::updateNote($bdd, $nid, $namenote, $statutnote); echo '<div class="bg-success">La note à bien été éditée</div><br/><br/>'; } } elseif (isset($_POST['valider'])) { $note_name = filter_input(INPUT_POST, $namenote); if (isset($note_name) && !empty($note_name)) { $date = date("Y-m-d"); $namenote = htmlentities($note_name); $newnote = new Note(); $newnote->setName($namenote); $newnote->setDate($date); $newnote->setUser($sessionUser->getId()); $newnote->setStatut(1); $newnote->insertNewNote($bdd); echo '<div class="bg-success">La note à bien été ajoutée</div><br/><br/>'; } } elseif (isset($_POST['modifier'])) { $note_name = filter_input(INPUT_POST, $namenote); if (isset($note_name) && !empty($note_name)) { $namenote = htmlentities($note_name); //s'il a coché la case 'Cloturer' if (isset($_POST['cloturer']) && !empty($_POST['cloturer'])) { $statutnote = "2"; } else { $statutnote = "1"; }