dongya1228 2017-08-25 13:07
浏览 41
已采纳

如何从MySQL表中获取多个电话号码并将它们存储在PHP中以逗号分隔的变量中?

I'm new to PHP-MySQL array functions. So I need help for the following:

I need to select phone numbers of all users from the MySQL table "users" in PHP and then need to store the phone numbers in a variable. All the numbers should be separated by "," (comma).

What I have tried:

    $stmt = $mysqli->prepare("SELECT phone FROM users WHERE status = ?");
    $stmt->bind_param('i',$status);
    $stmt->execute();
    $stmt->store_result();
    $stmt->bind_result($phone);
    while ($stmt->fetch())
    {
        $allphones = "$phone,"; //need help here.
    }
    $stmt->close(); 

What I need:

$allphones = "9999999990,9999999991,9999999992,9999999993";  

all the phone numbers should be separated by comma (,) and stored in a variable like above.

Any help will be appreciated! Thanks!

  • 写回答

1条回答 默认 最新

  • duandao2306 2017-08-25 13:21
    关注

    One way. You could also fetch all to avoid declaration and initialization of a new array (allphonesArray). It's up to you.

    $stmt = $mysqli->prepare("SELECT phone FROM users WHERE status = ?");
    $stmt->bind_param('i',$status);
    $stmt->execute();
    $stmt->store_result();
    $stmt->bind_result($phone);
    
    $allphonesArray = array(); //New array
    while ($stmt->fetch())
    {
        $allphonesArray[] = $phone; //Add each phone value to the array
    }
    $stmt->close(); 
    
    $allphonesString = implode(',', $allphonesArray); //Concatenate every element and separate them with ','
    echo $allphonesString;
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

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