spip /
SPIP
| @@ 354-374 (lines=21) @@ | ||
| 351 | * @param $args |
|
| 352 | * @return string |
|
| 353 | */ |
|
| 354 | function spip_mysql_select_as($args) |
|
| 355 | { |
|
| 356 | $res = ''; |
|
| 357 | foreach($args as $k => $v) { |
|
| 358 | if (substr($k,-1)=='@') { |
|
| 359 | // c'est une jointure qui se refere au from precedent |
|
| 360 | // pas de virgule |
|
| 361 | $res .= ' ' . $v ; |
|
| 362 | } |
|
| 363 | else { |
|
| 364 | if (!is_numeric($k)) { |
|
| 365 | $p = strpos($v, " "); |
|
| 366 | if ($p) |
|
| 367 | $v = substr($v,0,$p) . " AS `$k`" . substr($v,$p); |
|
| 368 | else $v .= " AS `$k`"; |
|
| 369 | } |
|
| 370 | ||
| 371 | $res .= ', ' . $v ; |
|
| 372 | } |
|
| 373 | } |
|
| 374 | return substr($res,2); |
|
| 375 | } |
|
| 376 | ||
| 377 | // |
|
| @@ 1515-1534 (lines=20) @@ | ||
| 1512 | ||
| 1513 | // renvoie des 'nom AS alias' |
|
| 1514 | // http://doc.spip.org/@_sqlite_calculer_select_as |
|
| 1515 | function _sqlite_calculer_select_as($args){ |
|
| 1516 | $res = ''; |
|
| 1517 | foreach ($args as $k => $v){ |
|
| 1518 | if (substr($k, -1)=='@'){ |
|
| 1519 | // c'est une jointure qui se refere au from precedent |
|
| 1520 | // pas de virgule |
|
| 1521 | $res .= ' '.$v; |
|
| 1522 | } |
|
| 1523 | else { |
|
| 1524 | if (!is_numeric($k)){ |
|
| 1525 | $p = strpos($v, " "); |
|
| 1526 | if ($p) |
|
| 1527 | $v = substr($v, 0, $p)." AS '$k'".substr($v, $p); |
|
| 1528 | else $v .= " AS '$k'"; |
|
| 1529 | } |
|
| 1530 | $res .= ', '.$v; |
|
| 1531 | } |
|
| 1532 | } |
|
| 1533 | return substr($res, 2); |
|
| 1534 | } |
|
| 1535 | ||
| 1536 | ||
| 1537 | /** |
|
