if ($aliasUpdate->execute()) {
echo "Alias deleted Successfully.";
}
} else {
//new or Update
//ensure it is available!
$alias = new Alias($conn);
$alias->setAlias($fileAlias);
$numAliases = sizeof($alias->getObjectsLikeThis());
if ($numAliases == 0) {
if ($file->getAliasID() == 0) {
$alias->setPointer($file->getId());
$alias->setType('file');
if ($alias->save() > 0) {
//echo "Alias Saved";
$fileUpdate->setAliasID($alias->getId());
}
} else {
$aliasUpdate = "UPDATE `alias` set `alias` = :NEWALIAS where `id` = :ALIASID";
$aliasUpdate = $conn->prepare($aliasUpdate);
$aliasUpdate->bindParam(':NEWALIAS', $fileAlias);
$aliasUpdate->bindParam(':ALIASID', $file->getAliasID());
$fileUpdate->setAliasID($file->getAliasID());
if ($aliasUpdate->execute() > 0) {
//echo "Alias updated Successfully.";
}
}
} else {
echo "Alias '" . $fileAlias . "' already exists!";
$fileUpdate->setAliasID($file->getAliasID());
}