Blame view

src/lib/models/manager_mail.php 1.25 KB
acd509a2   Administrator   090316
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
  <?php
  
  ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
  
  namespace models;
  
  class manager_mail extends \db
  {
  
      public function addData($data) {
          return $this->get(
              '
              INSERT INTO
                public.manager_mail
                (
                  "text"
                )
                VALUES
                (
                  :text
                )
                RETURNING manager_mail_id
              ',
              [
                  'text' => $data['text']
              ],
              -1
          );
      }
      public function getData()
      {
  
          return $this->get(
              '
                  SELECT
                  *
                  FROM
                      public.manager_mail
                  where manager_mail_id =1
              ',
              [],
              -1
  
          );
      }
  
  
      public function UpdateData($data)
      {
          return $this->exec(
              '
                  UPDATE
                      public.manager_mail
                  SET
                      text = :text
                  where manager_mail_id = 1
              ',
              [
                  "text" => $data['text'],
              ]
          );
      }
  
  
  
  }