spip /
SPIP
| @@ 711-727 (lines=17) @@ | ||
| 708 | ||
| 709 | ||
| 710 | // http://doc.spip.org/@spip_sqlite_in |
|
| 711 | function spip_sqlite_in($val, $valeurs, $not='', $serveur='',$requeter=true) { |
|
| 712 | $n = $i = 0; |
|
| 713 | $in_sql =""; |
|
| 714 | while ($n = strpos($valeurs, ',', $n+1)) { |
|
| 715 | if ((++$i) >= 255) { |
|
| 716 | $in_sql .= "($val $not IN (" . |
|
| 717 | substr($valeurs, 0, $n) . |
|
| 718 | "))\n" . |
|
| 719 | ($not ? "AND\t" : "OR\t"); |
|
| 720 | $valeurs = substr($valeurs, $n+1); |
|
| 721 | $i = $n = 0; |
|
| 722 | } |
|
| 723 | } |
|
| 724 | $in_sql .= "($val $not IN ($valeurs))"; |
|
| 725 | ||
| 726 | return "($in_sql)"; |
|
| 727 | } |
|
| 728 | ||
| 729 | ||
| 730 | // http://doc.spip.org/@spip_sqlite_insert |
|
| @@ 1435-1451 (lines=17) @@ | ||
| 1432 | * @return string |
|
| 1433 | * Expression de requête SQL |
|
| 1434 | **/ |
|
| 1435 | function spip_mysql_in($val, $valeurs, $not = '', $serveur = '', $requeter = true) { |
|
| 1436 | $n = $i = 0; |
|
| 1437 | $in_sql =""; |
|
| 1438 | while ($n = strpos($valeurs, ',', $n+1)) { |
|
| 1439 | if ((++$i) >= 255) { |
|
| 1440 | $in_sql .= "($val $not IN (" . |
|
| 1441 | substr($valeurs, 0, $n) . |
|
| 1442 | "))\n" . |
|
| 1443 | ($not ? "AND\t" : "OR\t"); |
|
| 1444 | $valeurs = substr($valeurs, $n+1); |
|
| 1445 | $i = $n = 0; |
|
| 1446 | } |
|
| 1447 | } |
|
| 1448 | $in_sql .= "($val $not IN ($valeurs))"; |
|
| 1449 | ||
| 1450 | return "($in_sql)"; |
|
| 1451 | } |
|
| 1452 | ||
| 1453 | ||
| 1454 | /** |
|
