phpmyadmin /
sql-parser
| @@ 233-240 (lines=8) @@ | ||
| 230 | if (isset($component->value)) { |
|
| 231 | // Syntax type 0 |
|
| 232 | $ret .= $component->value . ' '; |
|
| 233 | for ( |
|
| 234 | $i = 0; |
|
| 235 | $i < count($component->compare_values) && $i < count($component->results); |
|
| 236 | $i++ |
|
| 237 | ) { |
|
| 238 | $ret .= 'WHEN ' . $component->compare_values[$i] . ' '; |
|
| 239 | $ret .= 'THEN ' . $component->results[$i] . ' '; |
|
| 240 | } |
|
| 241 | } else { |
|
| 242 | // Syntax type 1 |
|
| 243 | for ( |
|
| @@ 243-250 (lines=8) @@ | ||
| 240 | } |
|
| 241 | } else { |
|
| 242 | // Syntax type 1 |
|
| 243 | for ( |
|
| 244 | $i = 0; |
|
| 245 | $i < count($component->conditions) && $i < count($component->results); |
|
| 246 | $i++ |
|
| 247 | ) { |
|
| 248 | $ret .= 'WHEN ' . Condition::build($component->conditions[$i]) . ' '; |
|
| 249 | $ret .= 'THEN ' . $component->results[$i] . ' '; |
|
| 250 | } |
|
| 251 | } |
|
| 252 | if (isset($component->else_result)) { |
|
| 253 | $ret .= 'ELSE ' . $component->else_result . ' '; |
|
