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 | /** |
|
| @@ 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 | /** |
|
