dongliaoqiang8524 2013-02-07 07:38
浏览 22
已采纳

我如何加入或破坏下面的数组代码?

In the below code i want to join or implode all arrays of $trackersurl in a single line. i am getting the results in different lines, so i want to join in a single line. Can anyone help me out?

I am searching results in stackoverflow, but could not follow.

My code is in below:

$sql = "SELECT * FROM announce WHERE torrent = $id ORDER BY seeders DESC";
$query = @mysql_query($sql);
while ($result  = @mysql_fetch_array($query)) {

$trackersurl1 = $result['url'];
$trackersurl2 = "&tr=".$trackersurl1;
$trackersurl = array($trackersurl2);

}

Results of [var.trackersurl] in html page is below:

&tr=http:ajgdsjhg/ann
&tr=udp://iuysidfu/ann
&tr=udp:wutefghgw/ann
&tr=http://sdhgsjdhgj/ann

I want to join them in a single line below

&tr=http:ajgdsjhg/ann&tr=udp://iuysidfu/ann&tr=udp:wutefghgw/ann&tr=http://sdhgsjdhgj/ann
  • 写回答

2条回答 默认 最新

  • dongxiezhuo8852 2013-02-07 07:52
    关注

    You should be careful of sql injection.

    Are you looking to create an array['trackers'] with a string of all the trackers for a magnet link?

    <?php
    $sql = "SELECT * FROM announce WHERE torrent = ".mysql_real_escape_string($id)." ORDER BY seeders DESC";
    $query = mysql_query($sql);
    
    $tracker = null;
    if(mysql_num_rows($query)>=1){
        while ($result  = mysql_fetch_array($query)) {
            $tracker .= "&tr=".$result['url'];
        }
    }
    $tracker = array('trackers'=>$tracker);
    
    //$tracker['trackers'] = "&tr=a.com&tr=b.com&tr=c.com";
    ?>
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 求差集那个函数有问题,有无佬可以解决
  • ¥15 【提问】基于Invest的水源涵养
  • ¥20 微信网友居然可以通过vx号找到我绑的手机号
  • ¥15 寻一个支付宝扫码远程授权登录的软件助手app
  • ¥15 解riccati方程组
  • ¥15 display:none;样式在嵌套结构中的已设置了display样式的元素上不起作用?
  • ¥15 使用rabbitMQ 消息队列作为url源进行多线程爬取时,总有几个url没有处理的问题。
  • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
  • ¥50 树莓派安卓APK系统签名
  • ¥65 汇编语言除法溢出问题