FilesExpand file tree

 master

/

SQL.php

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

80 lines (69 loc) · 1.31 KB

 master

/

SQL.php

Copy path

Top

File metadata and controls

• Code
• Blame

80 lines (69 loc) · 1.31 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

<?php

namespace DesignPatterns\FluentInterface;

/**

* class SQL

*/

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);

}

}