$fileUpdate->setFaculty(issetOrBlank($_POST['file-faculty'])); $fileUpdate->setExpiry(trim($_POST['file-expiry']) == "" ? "0000-00-00 00:00:00" : date('Y-m-d H:i:s', strtotime($_POST['file-expiry']))); ///0000-00-00 00:00:00 $fileUpdate->setDescription($_POST['file-description']); if (issetOrBlank($_POST['file-tags']) != $file->getTags()) { //sort the tags $tags = array_filter(array_map('trim', explode(',', issetOrBlank($_POST['file-tags'])))); asort($tags); $tags = implode(', ', $tags); $fileUpdate->setTags($tags); $query = "SELECT `option` FROM `options` WHERE `group_id` = 4 order by `sort`"; $Otags = $conn->query($query); $Otags->execute(); $Otags = $Otags->fetchAll(PDO::FETCH_COLUMN); //echo $tags; $newTags = explode(",", $fileUpdate->getTags()); $addTags = array_diff($newTags, $Otags); $pos = sizeof($Otags); foreach ($addTags as $tag) { $pos++; $newTag = $conn->prepare("INSERT INTO `fileupload`.`options` (`group_id`, `option`, `sort`) VALUES ('4', :tag, :pos)"); $newTag->bindParam(':tag', $tag); $newTag->bindParam(':pos', $pos); $newTag->execute(); } } else { $fileUpdate->setTags($file->getTags()); } $fileUpdate->setType(issetOrBlank($_POST['file-type'])); $fileUpdate->setUploadDate($file->getUploadDate()); //see if active has changed