public function updateUser($id)
{
$req = $this->app->request();
$imageName = $_FILES['image']['name'];
$imageTmp = $_FILES['image']['tmp_name'];
$uniqueID = md5(uniqid(rand(), true));
$fileType = strchr($imageName, '.');
$newUpload = 'assets/img_public/' . $uniqueID . $fileType;
if ($imageName != null) {
unlink(User::showImageUser($id));
}
move_uploaded_file($imageTmp, $newUpload);
@chmod($newUpload, 0777);
if ($imageName != null) {
$sql = 'UPDATE users SET u_email = :u_email, u_password = :u_password, u_image = :u_image, level = :level WHERE user_id = :id';
} else {
$sql = 'UPDATE users SET u_email = :u_email, u_password = :u_password, level = :level WHERE user_id = :id';
}
$this->users = parent::connect()->prepare($sql);
$this->users->bindValue(':u_email', $req->post('email'));
$this->users->bindValue(':u_password', Bcrypt::hash($req->post('password')));
if ($imageName != null) {
$this->users->bindValue(':u_image', $newUpload);
}
$this->users->bindValue(':level', $req->post('level'));
$this->users->bindValue(':id', $id);
try {
$this->users->execute();
} catch (PDOException $e) {
die($e->getMessage());
}
}
public function updateCustomer($id)
{
$req = $this->app->request();
$sql = 'UPDATE customers SET c_email = :c_email, c_password = :c_password, c_name = :c_name, address = :address, phone = :phone, notes = :notes
WHERE customer_id = :id';
$this->customers = parent::connect()->prepare($sql);
$data = array('c_email' => $req->post('c_email'), 'c_password' => Bcrypt::hash($req->post('c_password')), 'c_name' => $req->post('c_name'), 'address' => $req->post('address'), 'phone' => $req->post('phone'), 'notes' => $req->post('notes'), 'id' => $id);
try {
$this->customers->execute($data);
} catch (PDOException $e) {
die($e->getMessage());
}
}
