seo_info.php
3.22 KB
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
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
<?php
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
namespace models;
class seo_info extends \db
{
public function getAllSeo()
{
return $this->get(
'
SELECT * FROM
public.seo_info
ORDER BY
id ASC
',
[
],
-1
);
}
function getByUrl($url)
{
return $this->get(
'
SELECT * FROM
public.seo_info
WHERE
url = :url
',
[
'url' => $url
],
-1
);
}
public function getOneSeo($id)
{
return $this->get(
'
SELECT * FROM
public.seo_info
WHERE
id = :id
',
[
'id' => $id
],
-1
);
}
public function deleteSeo($id){
return $this->exec(
' DELETE
FROM
public.seo_info
WHERE
id = :id
',
[
'id' => $id
]
);
}
public function addSeoData($data)
{
return $this->get(
'
INSERT INTO
public.seo_info
(
title,
url,
h1,
description,
seo_text
)
VALUES
(
:title,
:url,
:h1,
:description,
:seo_text
)
RETURNING id
',
[
"title" => $data['title'],
"url" => $data["url"],
"h1" => $data['h1'],
"description" => $data['description'],
"seo_text" => $data['seo_text'],
],
-1
);
}
public function UpdateSeo($data)
{
return $this->exec(
'
UPDATE
public.seo_info
SET
title = :title,
url = :url,
h1 = :h1,
description = :description,
seo_text = :seo_text
WHERE
id = :id
',
[
"title" => $data['title'],
"url" => $data["url"],
"h1" => $data['h1'],
"description" => $data['description'],
"seo_text" => $data['seo_text'],
"id" => $data['id']
]
);
}
}