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