phpmyadmin /
sql-parser
| @@ 216-223 (lines=8) @@ | ||
| 213 | if (isset($component->value)) { |
|
| 214 | // Syntax type 0 |
|
| 215 | $ret .= $component->value . ' '; |
|
| 216 | for ( |
|
| 217 | $i = 0; |
|
| 218 | $i < count($component->compare_values) && $i < count($component->results); |
|
| 219 | ++$i |
|
| 220 | ) { |
|
| 221 | $ret .= 'WHEN ' . $component->compare_values[$i] . ' '; |
|
| 222 | $ret .= 'THEN ' . $component->results[$i] . ' '; |
|
| 223 | } |
|
| 224 | } else { |
|
| 225 | // Syntax type 1 |
|
| 226 | for ( |
|
| @@ 226-233 (lines=8) @@ | ||
| 223 | } |
|
| 224 | } else { |
|
| 225 | // Syntax type 1 |
|
| 226 | for ( |
|
| 227 | $i = 0; |
|
| 228 | $i < count($component->conditions) && $i < count($component->results); |
|
| 229 | ++$i |
|
| 230 | ) { |
|
| 231 | $ret .= 'WHEN ' . Condition::build($component->conditions[$i]) . ' '; |
|
| 232 | $ret .= 'THEN ' . $component->results[$i] . ' '; |
|
| 233 | } |
|
| 234 | } |
|
| 235 | if (isset($component->else_result)) { |
|
| 236 | $ret .= 'ELSE ' . $component->else_result . ' '; |
|
