$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('*****@*****.**');
