-
Notifications
You must be signed in to change notification settings - Fork 1
/
Template.php
43 lines (27 loc) · 1.1 KB
/
Template.php
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
<?php
require_once( "Model.php");
class Template extends Model {
public function create( $uid, $isPublic, $header, $comment, $footer, $name ) {
$query = " INSERT INTO Template";
$query .= " (i_UID, b_Public, t_TemplateHdr, t_TemplateCmt, t_TemplateFtr, vc_TemplateName )";
$query .= " VALUES ( ?, ?, ?, ?, ?, ?)";
$statement = $this->prepareStatementForQuery( $query );
$statement->bind_param( 'iissss', $uid, $isPublic, $header, $comment, $footer, $name );
$statement->execute();
return $statement->insert_id;
}
public function update( $templateId, $uid, $isPublic, $header, $comment, $footer, $name ) {
$query = " UPDATE Template";
$query .= " SET i_UID=?, b_Public=?, t_TemplateHdr=?";
$query .= ", t_TemplateCmt=?, t_TemplateFtr=?, vc_TemplateName=?";
$query .= " WHERE i_TemplateID=?";
$statement = $this->prepareStatementForQuery( $query );
$statement->bind_param( 'iissssi',
$uid, $isPublic, $header,
$comment, $footer, $name,
$templateId
);
$statement->execute();
$statement->close();
}
}