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()); } }