spip /
SPIP
| @@ 420-439 (lines=20) @@ | ||
| 417 | * @return string |
|
| 418 | * Contrainte pour clause WHERE |
|
| 419 | */ |
|
| 420 | function calculer_mysql_where($v) { |
|
| 421 | if (!is_array($v)) { |
|
| 422 | return $v; |
|
| 423 | } |
|
| 424 | ||
| 425 | $op = array_shift($v); |
|
| 426 | if (!($n = count($v))) { |
|
| 427 | return $op; |
|
| 428 | } else { |
|
| 429 | $arg = calculer_mysql_where(array_shift($v)); |
|
| 430 | if ($n == 1) { |
|
| 431 | return "$op($arg)"; |
|
| 432 | } else { |
|
| 433 | $arg2 = calculer_mysql_where(array_shift($v)); |
|
| 434 | if ($n == 2) { |
|
| 435 | return "($arg $op $arg2)"; |
|
| 436 | } else { |
|
| 437 | return "($arg $op ($arg2) : $v[0])"; |
|
| 438 | } |
|
| 439 | } |
|
| 440 | } |
|
| 441 | } |
|
| 442 | ||
| @@ 2206-2224 (lines=19) @@ | ||
| 2203 | * @return string |
|
| 2204 | * Contrainte pour clause WHERE |
|
| 2205 | */ |
|
| 2206 | function _sqlite_calculer_where($v) { |
|
| 2207 | if (!is_array($v)) { |
|
| 2208 | return $v; |
|
| 2209 | } |
|
| 2210 | ||
| 2211 | $op = array_shift($v); |
|
| 2212 | if (!($n = count($v))) { |
|
| 2213 | return $op; |
|
| 2214 | } else { |
|
| 2215 | $arg = _sqlite_calculer_where(array_shift($v)); |
|
| 2216 | if ($n == 1) { |
|
| 2217 | return "$op($arg)"; |
|
| 2218 | } else { |
|
| 2219 | $arg2 = _sqlite_calculer_where(array_shift($v)); |
|
| 2220 | if ($n == 2) { |
|
| 2221 | return "($arg $op $arg2)"; |
|
| 2222 | } else { |
|
| 2223 | return "($arg $op ($arg2) : $v[0])"; |
|
| 2224 | } |
|
| 2225 | } |
|
| 2226 | } |
|
| 2227 | } |
|
