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]);
}
