星期日, 3月 01, 2015

array_push 結合陣列中的文字

<?php
require 'bootstrap.php';
require 'config/global.php';

// 跑馬燈開始
$rs = $pdo->prepare("SELECT * FROM `marquee` WHERE `is_show`='Y' AND TO_DAYS(NOW()) - TO_DAYS(start_date) >= 0 AND TO_DAYS(NOW()) - TO_DAYS(end_date) <= 0  ORDER BY `sno`");
$rs->execute();

if ($rs->rowCount() > 0){
  echo '<div class="col-md-8 col-md-offset-2"><font color="#FFFF"><marquee>';
  $tmpArray = array();
 
  while($d = $rs->fetchObject()){

    array_push($tmpArray, sprintf('<a href="%s" title="%s">%s</a>', $d->url, $d->headline, $d->headline));
  }

  $marquee = implode('&nbsp;&nbsp;&nbsp;&nbsp;&nbsp', $tmpArray);

  echo($marquee);

  echo "</marquee></font>";
}
// 跑馬燈結束
?>

沒有留言: