spip /
SPIP
| @@ 1085-1101 (lines=17) @@ | ||
| 1082 | * @return string |
|
| 1083 | * Expression de requête SQL |
|
| 1084 | **/ |
|
| 1085 | function spip_sqlite_in($val, $valeurs, $not = '', $serveur = '', $requeter = true) { |
|
| 1086 | $n = $i = 0; |
|
| 1087 | $in_sql = ""; |
|
| 1088 | while ($n = strpos($valeurs, ',', $n + 1)) { |
|
| 1089 | if ((++$i) >= 255) { |
|
| 1090 | $in_sql .= "($val $not IN (" . |
|
| 1091 | substr($valeurs, 0, $n) . |
|
| 1092 | "))\n" . |
|
| 1093 | ($not ? "AND\t" : "OR\t"); |
|
| 1094 | $valeurs = substr($valeurs, $n + 1); |
|
| 1095 | $i = $n = 0; |
|
| 1096 | } |
|
| 1097 | } |
|
| 1098 | $in_sql .= "($val $not IN ($valeurs))"; |
|
| 1099 | ||
| 1100 | return "($in_sql)"; |
|
| 1101 | } |
|
| 1102 | ||
| 1103 | ||
| 1104 | /** |
|
| @@ 1571-1587 (lines=17) @@ | ||
| 1568 | * @return string |
|
| 1569 | * Expression de requête SQL |
|
| 1570 | **/ |
|
| 1571 | function spip_mysql_in($val, $valeurs, $not = '', $serveur = '', $requeter = true) { |
|
| 1572 | $n = $i = 0; |
|
| 1573 | $in_sql = ""; |
|
| 1574 | while ($n = strpos($valeurs, ',', $n + 1)) { |
|
| 1575 | if ((++$i) >= 255) { |
|
| 1576 | $in_sql .= "($val $not IN (" . |
|
| 1577 | substr($valeurs, 0, $n) . |
|
| 1578 | "))\n" . |
|
| 1579 | ($not ? "AND\t" : "OR\t"); |
|
| 1580 | $valeurs = substr($valeurs, $n + 1); |
|
| 1581 | $i = $n = 0; |
|
| 1582 | } |
|
| 1583 | } |
|
| 1584 | $in_sql .= "($val $not IN ($valeurs))"; |
|
| 1585 | ||
| 1586 | return "($in_sql)"; |
|
| 1587 | } |
|
| 1588 | ||
| 1589 | ||
| 1590 | /** |
|
