/** * checks if a username is already existing * @param $username * @return boolean */ public function validUser($username) { $this->user = false; $pdo = config_db::getConnected(); $statement = $pdo->prepare("SELECT * FROM `users` WHERE username = :username"); $result = $statement->execute(array('username' => $username)); echo $username; $this->user = $statement->fetch(); if ($this->user) { return true; } else { return false; } }
/** * renames a file * @param $fileid * @param $oldname * @param $newName */ public function renameFile($fileid, $oldname, $newName) { $this->pdo = config_db::getConnected(); $fileid = $_POST['fileid']; $oldname = $_POST['oldfile']; $query = "UPDATE `files` SET `filename` = :newFilename WHERE id = :id"; $updatestmt = $this->pdo->prepare($query); $updatestmt->bindParam(':newFilename', $newName, PDO::PARAM_STR); $updatestmt->bindParam(':id', $fileid); $updatestmt->execute(); //rename file //first set file-access chmod(config_db::FILEFOLDER . '/' . $oldname, 755); rename(config_db::FILEFOLDER . '/' . $oldname, config_db::FILEFOLDER . '/' . $newName); }