phpmyadmin /
sql-parser
| @@ 224-231 (lines=8) @@ | ||
| 221 | if (isset($component->value)) { |
|
| 222 | // Syntax type 0 |
|
| 223 | $ret .= $component->value . ' '; |
|
| 224 | for ( |
|
| 225 | $i = 0; |
|
| 226 | $i < count($component->compare_values) && $i < count($component->results); |
|
| 227 | $i++ |
|
| 228 | ) { |
|
| 229 | $ret .= 'WHEN ' . $component->compare_values[$i] . ' '; |
|
| 230 | $ret .= 'THEN ' . $component->results[$i] . ' '; |
|
| 231 | } |
|
| 232 | } else { |
|
| 233 | // Syntax type 1 |
|
| 234 | for ( |
|
| @@ 234-241 (lines=8) @@ | ||
| 231 | } |
|
| 232 | } else { |
|
| 233 | // Syntax type 1 |
|
| 234 | for ( |
|
| 235 | $i = 0; |
|
| 236 | $i < count($component->conditions) && $i < count($component->results); |
|
| 237 | $i++ |
|
| 238 | ) { |
|
| 239 | $ret .= 'WHEN ' . Condition::build($component->conditions[$i]) . ' '; |
|
| 240 | $ret .= 'THEN ' . $component->results[$i] . ' '; |
|
| 241 | } |
|
| 242 | } |
|
| 243 | if (isset($component->else_result)) { |
|
| 244 | $ret .= 'ELSE ' . $component->else_result . ' '; |
|
