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);
 }
Example #2
0
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;
}
Example #3
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;
}