public function save() { $connect = connecttoDB(); $mData = array(':name' => $this->name, ':surname' => $this->surname, ':passwd' => $this->passwd, ':id' => $this->id); $saveQ = 'UPDATE `webapp`.`member` SET `name` = :name,`surname` = :surname,`passwd` = :passwd WHERE `member`.`id` = :id'; $query = $connect->prepare($saveQ); $query->execute($mData); }
function delete_user($id) { $connect = connecttoDB(); $sqlCommand = "DELETE FROM `member` WHERE `id` = :id"; $sth = $connect->prepare($sqlCommand); $param = array(":id" => $id); $sth->execute($param); return $sth->rowCount() > 0; }
function get_product() { $i = 1; $connect = connecttoDB(); $query = 'SELECT `product_code`,`product_name`,`price` FROM `products`'; $stmt = $connect->prepare($query); $stmt->execute(); $get_P = $stmt->fetchAll(); return $get_P; }