-
Notifications
You must be signed in to change notification settings - Fork 1
/
SetClause.php
55 lines (45 loc) · 1.24 KB
/
SetClause.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
44
45
46
47
48
49
50
51
52
53
54
55
<?php
/*
* Class to manage the set clauses.
* Examples: SET(user_id:123)
*/
class SetClause
{
private $clause;
private $arguments; // Array with column (0), value (1)
public function __construct($query)
{
$query = strtolower($query);
$this->clause = SetClause::getSetClauseFromQuery($query);
$this->arguments = $this->genArguments($this->clause);
}
public function getClause() {
return $this->clause;
}
public function getSetArguments() {
return $this->arguments;
}
public static function getSetClauseFromQuery($query)
{
$set_clause = null;
// Use Regex to find the WHERE clause
preg_match("/(set\(([^)]+)\))/", $query, $results);
if (preg_match("/(set\(([^)]+)\))/", $query))
{
// If found return the where clause
$set_clause = $results[1];
}
return $set_clause;
}
private function genArguments($clause)
{
preg_match("/set\(([^)]+)\\)/", $clause, $results);
$arguments = explode(':', $results[1]);
$arguments_array = array(
'column' => $arguments[0],
'value' => $arguments[1]
);
return $arguments_array;
}
}
?>