function addSport($fileURLphoto) { $nom = minNoSpace($_POST['nom']); $description = $_POST['description']; $id_type = $_POST['id_type']; $sql = "INSERT INTO sports (nom, description, id_type) VALUES (?,?,?)"; $resultat = $this->requeteSQL($sql, [$nom, $description, $id_type]); $id_sport = $this->connectBDD()->lastInsertId(); //fonction intégrée de PDO. $nom .= '_photo'; $sql = "INSERT INTO photo (nom, chemin, id_sport) VALUES (?,?,?)"; $resultat = $this->requeteSQL($sql, [$nom, $fileURLphoto, $id_sport]); }
public function loadBackOfficeSport() { $error = ""; if (!empty($_POST)) { if (!empty($_FILES['icone']['name'])) { $error .= "Veuillez selectionner une icone pour le sport."; } if (!empty($_FILES['photo']['name'])) { $error .= "Veuillez selectionner une photo pour le sport."; } $verification = new Verification($_POST); $verificationPhoto = new Verification($_FILES); $verification->notEmpty('nom', "Veuillez indiquer un nom à votre sport."); $verification->notEmpty('description', "Veuillez remplir la description du groupe."); $verification->notEmpty('id_type', "N'oubliez pas de choisir un type."); $verificationPhoto->PhotoOk('photo', $_POST['nom'] . '.jpg', 'Sports'); $verificationPhoto->PhotoOk('icone', $_POST['nom'] . '.svg', 'Sports'); $error = $verification->error; $error .= $verificationPhoto->error; if ($verification->isValid() && $verificationPhoto->isValid()) { /*upload images*/ $error .= uploadPhoto(minNoSpace($_POST['nom']) . '.jpg', 'Sports', 'photo'); $error .= uploadPhoto(minNoSpace($_POST['nom']) . '.svg', 'svg', 'icone'); //Add BDD if (empty($error)) { $fileURLphoto = 'Sports/' . minNoSpace($_POST["nom"]) . '.jpg'; $this->admin->addSport($fileURLphoto); } } } $sports = $this->sport->getSports()->fetchAll(); $types = $this->sport->getTypes()->fetchAll(); $nbgroupe = $this->groupe->getNbGroupeSports($sports); $vue = new Vue("BackOfficeSport", "Admin", ['font-awesome.css', 'admin.css'], ['Admin/admin.js']); $vue->loadbackoffice(['sports' => $sports, 'nbgroupe' => $nbgroupe, 'types' => $types, 'error' => $error]); }