FazBrowse GitHub Viewer
|
Trending
|
URL:
|
Home
Tools:
[Download Repo ZIP]
[View Raw Code]
[Original HTTPS Page]
DesignPatternsPHP/FluentInterface/SQL.php at master · NandoKstroNet/DesignPatternsPHP · GitHub
NandoKstroNet
/
DesignPatternsPHP
Public
forked from
DesignPatternsPHP/DesignPatternsPHP
Notifications
You must be signed in to change notification settings
Fork
0
Star
2
Code
Pull requests
0
Actions
Projects
Wiki
Security and quality
0
Insights
Additional navigation options
Code
Pull requests
Actions
Projects
Wiki
Security and quality
Insights
Expand file tree
Breadcrumbs
DesignPatternsPHP
/
FluentInterface
/
SQL.php
Copy path
More file actions
More file actions
Latest commit
History
History
History
88 lines (77 loc) · 1.62 KB
Breadcrumbs
DesignPatternsPHP
/
FluentInterface
/
SQL.php
Copy path
File metadata and controls
88 lines (77 loc) · 1.62 KB
Raw
Copy raw file
Download raw file
Open symbols panel
Edit and raw actions
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
<?php
namespace
DesignPatterns
\
FluentInterface
;
/**
* fluent interface pattern
*
* Purpose:
* to write code that is easy readable just like "real" sentences
*
* Examples:
* - Doctrine2's QueryBuilder works something like that example class below
* - PHPUnit uses fluent interfaces to build mock objects
* - Yii Framework: CDbCommand and CActiveRecord use this pattern, too
*/
class
SQL
{
/**
* @var array
*/
protected
$
fields
=
array
();
/**
* @var array
*/
protected
$
from
=
array
();
/**
* @var array
*/
protected
$
where
=
array
();
/**
* adds select fields
*
* @param array $fields
*
* @return SQL
*/
public
function
select
(
array
$
fields
=
array
())
{
$
this
->
fields
=
$
fields
;
return
$
this
;
}
/**
* adds a FROM clause
*
* @param string $table
* @param string $alias
*
* @return SQL
*/
public
function
from
(
$
table
,
$
alias
)
{
$
this
->
from
[] =
$
table
.
'
AS
'
.
$
alias
;
return
$
this
;
}
/**
* adds a WHERE condition
*
* @param string $condition
*
* @return SQL
*/
public
function
where
(
$
condition
)
{
$
this
->
where
[] =
$
condition
;
return
$
this
;
}
/**
* Gets the query, just an example of building a query,
* no check on consistency
*
* @return string
*/
public
function
getQuery
()
{
return
'
SELECT
'
.
implode
(
'
,
'
,
$
this
->
fields
)
.
'
FROM
'
.
implode
(
'
,
'
,
$
this
->
from
)
.
'
WHERE
'
.
implode
(
'
AND
'
,
$
this
->
where
);
}
}
Back
|
FazBrowse Home
|
New Git URL