function updateEvent($push)
{
$bdd = new PDO(DSN, DBUSER, DBPASS);
require MODELES . 'functions/adresse.php';
require MODELES . 'functions/insertMedia.php';
require MODELES . 'functions/updateMedia.php';
require MODELES . 'functions/removeMedia.php';
$id_type = $push["id_type"];
$adresse_id = insertAddress($push['adresse']);
$media_id = NULL;
if (!empty($push['id_media_principal'])) {
if (!empty($push['lien_photo'])) {
if ($push['lien_photo'] == -1) {
unlink(PHOTO_EVENT . $push['old_lien_photo']);
removeMedia($push['id_media_principal']);
$media_id = NULL;
} else {
updateMedia($push['lien_photo'], $push['id_media_principal']);
$media_id = $push['id_media_principal'];
}
}
} else {
if (!empty($push['lien_photo'])) {
$media_id = insertMedia($push['lien_photo']);
}
}
// insérer dans organise ou organise = coming soon
foreach ($push as $key => $value) {
if ($value == '') {
$push[$key] = NULL;
}
}
$updateQuery = $bdd->prepare('UPDATE
evenement SET
titre = :titre,
debut = :debut,
fin = :fin,
age_min = :age_min,
age_max = :age_max,
visibilite = :visibilite,
invitation = :invitation,
tarif = :tarif,
description = :description,
site = :site,
langue = :langue,
id_type = :id_type,
id_adresse = :id_adresse,
id_media_principal = :id_media_principal,
sponsor = :sponsor,
organisateur = :organisateur,
organisateur_contact = :organisateur_contact,
max_participants = :max_participants
WHERE id = :id;');
if ($updateQuery->execute([':titre' => $push['titre'], ':debut' => $push['date_debut'] . ' ' . $push['beginning'], ':fin' => $push['date_fin'] . ' ' . $push['end'], ':age_min' => $push['age_min'], ':age_max' => $push['age_max'], ':visibilite' => $push['visibilite'], ':invitation' => $push['invitation'], ':tarif' => $push['price'], ':description' => $push['description'], ':site' => $push['website'], ':langue' => $push['langue'], ':id_type' => $id_type, ':id_adresse' => $adresse_id, ':id_media_principal' => $media_id, ':sponsor' => $push['sponsors'], ':max_participants' => $push['max_attendees'], ':organisateur' => $push['hosts'], ':organisateur_contact' => $push['hosts_contact'], ':id' => $push['id']])) {
return True;
} else {
var_dump($updateQuery->errorInfo());
return False;
}
}
function insertEvent($push)
{
$bdd = new PDO(DSN, DBUSER, DBPASS);
require MODELES . 'functions/adresse.php';
require MODELES . 'functions/insertMedia.php';
$id_type = $push["id_type"];
$adresse_id = insertAddress($push['adresse']);
if (!empty($push['lien_photo'])) {
$media_id = insertMedia($push['lien_photo']);
} else {
$media_id = NULL;
}
// insérer dans organise ou organise = coming soon
$insertQuery = $bdd->prepare('INSERT INTO
evenement (titre, debut, fin, age_min, age_max, visibilite, invitation, tarif, description, site, langue, id_type, id_adresse, id_createur, id_media_principal, sponsor, organisateur, organisateur_contact, max_participants)
VALUES (:titre, :debut, :fin, :age_min, :age_max, :visibilite, :invitation, :tarif, :description, :site, :langue, :id_type, :id_adresse, :id_createur, :id_media_principal, :sponsor, :organisateur, :organisateur_contact, :max_participants)');
if ($insertQuery->execute([':titre' => $push['titre'], ':debut' => $push['debut'], ':fin' => $push['fin'], ':age_min' => $push['age_min'], ':age_max' => $push['age_max'], ':visibilite' => $push['visibilite'], ':invitation' => $push['invitation'], ':tarif' => $push['price'], ':description' => $push['description'], ':site' => $push['website'], ':langue' => $push['langue'], ':id_type' => $id_type, ':id_adresse' => $adresse_id, ':id_media_principal' => $media_id, ':sponsor' => $push['sponsors'], ':max_participants' => $push['max_attendees'], ':organisateur' => $push['hosts'], ':organisateur_contact' => $push['hosts_contact'], ':id_createur' => $push['id_createur']])) {
$eventId = $bdd->lastInsertId();
return $eventId;
} else {
var_dump($insertQuery->errorInfo());
return False;
}
}
<?php
ini_set('display_errors', 1);
error_reporting(E_ALL);
$Naam = $_POST["Naam"];
$Postcode = $_POST["Postcode"];
$Huisnr = $_POST["Huisnr"];
$Toevoeging = $_POST["Toevoeging"];
$Plaats = $_POST["Woonplaats"];
$Straat = $_POST["Straat"];
$Gebruikersnaam = $_POST["Gebruikersnaam"];
$Wachtwoord = $_POST["Wachtwoord"];
include "functions.php";
$link = connect();
if ($link == false) {
echo 0;
exit;
}
$Hash = bCrypt($Wachtwoord, 12);
$AdresID = insertAddress($Postcode, $Huisnr, $Toevoeging, $Straat, $Plaats);
$PersoonID = insertPersoon($Naam, $AdresID);
insertLogingegevens($PersoonID, $Gebruikersnaam, $Hash);
