spip /
SPIP
| @@ 1579-1595 (lines=17) @@ | ||
| 1576 | * @return string |
|
| 1577 | * Expression de requête SQL |
|
| 1578 | **/ |
|
| 1579 | function spip_mysql_in($val, $valeurs, $not = '', $serveur = '', $requeter = true) { |
|
| 1580 | $n = $i = 0; |
|
| 1581 | $in_sql = ""; |
|
| 1582 | while ($n = strpos($valeurs, ',', $n + 1)) { |
|
| 1583 | if ((++$i) >= 255) { |
|
| 1584 | $in_sql .= "($val $not IN (" . |
|
| 1585 | substr($valeurs, 0, $n) . |
|
| 1586 | "))\n" . |
|
| 1587 | ($not ? "AND\t" : "OR\t"); |
|
| 1588 | $valeurs = substr($valeurs, $n + 1); |
|
| 1589 | $i = $n = 0; |
|
| 1590 | } |
|
| 1591 | } |
|
| 1592 | $in_sql .= "($val $not IN ($valeurs))"; |
|
| 1593 | ||
| 1594 | return "($in_sql)"; |
|
| 1595 | } |
|
| 1596 | ||
| 1597 | ||
| 1598 | /** |
|
| @@ 1014-1030 (lines=17) @@ | ||
| 1011 | * @return string |
|
| 1012 | * Expression de requête SQL |
|
| 1013 | **/ |
|
| 1014 | function spip_sqlite_in($val, $valeurs, $not = '', $serveur = '', $requeter = true) { |
|
| 1015 | $n = $i = 0; |
|
| 1016 | $in_sql = ""; |
|
| 1017 | while ($n = strpos($valeurs, ',', $n + 1)) { |
|
| 1018 | if ((++$i) >= 255) { |
|
| 1019 | $in_sql .= "($val $not IN (" . |
|
| 1020 | substr($valeurs, 0, $n) . |
|
| 1021 | "))\n" . |
|
| 1022 | ($not ? "AND\t" : "OR\t"); |
|
| 1023 | $valeurs = substr($valeurs, $n + 1); |
|
| 1024 | $i = $n = 0; |
|
| 1025 | } |
|
| 1026 | } |
|
| 1027 | $in_sql .= "($val $not IN ($valeurs))"; |
|
| 1028 | ||
| 1029 | return "($in_sql)"; |
|
| 1030 | } |
|
| 1031 | ||
| 1032 | ||
| 1033 | /** |
|
