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; } }
// logText("Artwork: ". $artwork); // } //timeExecution("Parse info"); if (isset($title) && isset($artist)) { if (!$lastRecord || $lastRecord->title != $title) { insertRecord($fileName, $title, $album, $artist); //timeExecution("Insert record"); //iTunes API request $term = urlencode($artist . (isset($album) ? " " . $album : "") . " " . $title); // //echo $term; $iTunesJSON = file_get_contents('http://itunes.apple.com/search?term=' . $term . '&media=music&entity=song&limit=1'); $iTunesData = json_decode($iTunesJSON, true); if ($iTunesData["resultCount"] > 0) { $iTunesMetadata = $iTunesData["results"][0]; //timeExecution("Pull iTunes data"); insertMedia($iTunesMetadata); //timeExecution("Add media"); } else { logText("No itunes info"); } //$content = "<div style='background-image: url({$artwork});'><h1>{$artist} - {$title}</h1></div>"; // $contentFile = fopen("content.php", "w"); // fwrite($contentFile, $content); // fclose($contentFile); } elseif ($lastRecord) { //UPDATE filename in DB updateRecord($lastRecord->id, $fileName); //timeExecution("Update record"); logText("Song duplicate"); } } else {
unset($contents['images'][$key]); $contents['img_number']--; } } } if (!empty($_FILES["photos"]["name"][0]) && $contents['img_number'] < 4) { // Boucle sur $_FILES pour passer sur tous les fichiers $photoLeft = 4 - $contents['img_number']; foreach ($_FILES['photos']['name'] as $f => $name) { if ($photoLeft <= 0) { break; } $check = checkOnePhotos("photos", $f, $maxsize, $max_height, $max_width, $validExtensions, NULL, PHOTO_EVENT); if ($check[0]) { if (uploadOnePhotos("photos", $f, NULL, PHOTO_EVENT, $check[1])) { $media_id = insertMedia($check[1]); if (insertEventMedia($_GET['id'], $media_id)) { $contents['images'][$f] = [$media_id, $check[1]]; $contents['img_number']++; // Nombre d'images uploadés avec succès. $photoLeft--; //Nombre de photos restantes. } } } else { $contents['errorMessage'] .= '(' . $name . ')' . $check[1]; } } } if (empty($contents['errorMessage']) && (!empty($_POST) or !empty($_FILES))) { alert("ok", "Les images on bien été modifiées");