$query = $this->db->prepare("UPDATE {$this->table} SET name =:name, email=:email WHERE user_id=:user_id"); $query->bindParam(':name', $name); $query->bindParam(':email', $email); $query->bindParam(':user_id', $user_id); $query->execute(); } function delete($email, $user_id) { $query = $this->db->prepare("DELETE FROM {$this->table} WHERE email=:email AND user_id=:user_id"); $query->bindParam(':email', $email); $query->bindParam(':user_id', $user_id); $query->execute(); } function createUserDir($email) { $query = $this->db->prepare("SELECT user_id FROM {$this->table} WHERE email=:email"); $query->bindParam(':email', $email); $query->execute(); $result = $query->fetch(PDO::FETCH_ASSOC); $path = "testuser/" . $result['user_id'] . "/img"; if (!file_exists($path)) { mkdir($path, 0777, true); echo "dir created"; } else { echo "error "; } } } $user = new UserTest(); $user->createUserDir('*****@*****.**');