PHP 不回显最后一行的文本

Question

我正在尝试在 php 中编写一个相对简单的 twitter 查询，结果如下：

from:TravisBenjamin3 OR from:AshleyElisaG OR from:tncvaan ...

这段代码可以工作，接受它不会回显第二个 OR，我也不这样做想要在最后一行显示 OR。

$counter = 0;
while($row = mysql_fetch_array($result)){
$counter++;
echo " from:";
echo $row['twitter'];
if ($counter < count($row)) {
               echo " OR";
           }
}

一些帮助将不胜感激。谢谢，

Answer 1

<?php
$tweets = array();
while($row = mysql_fetch_array($result)) {
    $tweets[] = $row['twitter'];
}
if(count($tweets) > 0) {
    echo "from:" . implode(" OR from:", $tweets);
}
?>

Answer 2

$rowCount = mysql_num_rows($result);

while($row = mysql_fetch_array($result)){
$counter++;
echo " from:";
echo $row['twitter'];
if ($counter < $rowCount) {
               echo " OR";
           }
}

Answer 3

$count = mysql_num_rows($result);

for($r = 0; $r < $count; $r++)
{
   $row = mysql_fetch_array($result));
   echo " from:";
   echo $row['twitter'];
   if ($r < ($count - 1)) 
   {
           echo " OR";
   }
}

或者，更简单：

$search = "";

while($row = mysql_fetch_array($result))
{
   $search .= " from:" . $row['twitter'] . " OR";
}

// Cut the last " OR"
$search = substr($search, 0, strlen($search) - 3);
echo $search;

这实际上是 Aaron W. 建议的 implode() 的穷人实现。