phpmyadmin /
sql-parser
| @@ 258-265 (lines=8) @@ | ||
| 255 | if (isset($component->value)) { |
|
| 256 | // Syntax type 0 |
|
| 257 | $ret .= $component->value . ' '; |
|
| 258 | for ( |
|
| 259 | $i = 0; |
|
| 260 | $i < count($component->compare_values) && $i < count($component->results); |
|
| 261 | $i++ |
|
| 262 | ) { |
|
| 263 | $ret .= 'WHEN ' . $component->compare_values[$i] . ' '; |
|
| 264 | $ret .= 'THEN ' . $component->results[$i] . ' '; |
|
| 265 | } |
|
| 266 | } else { |
|
| 267 | // Syntax type 1 |
|
| 268 | for ( |
|
| @@ 268-275 (lines=8) @@ | ||
| 265 | } |
|
| 266 | } else { |
|
| 267 | // Syntax type 1 |
|
| 268 | for ( |
|
| 269 | $i = 0; |
|
| 270 | $i < count($component->conditions) && $i < count($component->results); |
|
| 271 | $i++ |
|
| 272 | ) { |
|
| 273 | $ret .= 'WHEN ' . Condition::build($component->conditions[$i]) . ' '; |
|
| 274 | $ret .= 'THEN ' . $component->results[$i] . ' '; |
|
| 275 | } |
|
| 276 | } |
|
| 277 | if (isset($component->else_result)) { |
|
| 278 | $ret .= 'ELSE ' . $component->else_result . ' '; |
|
