Example #1
0
 /**
  * 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;
     }
 }
Example #2
0
 /**
  * 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);
 }