duancunsu9209 2018-08-07 08:12
浏览 96
已采纳

PHP从数据库中获取数据并将数据放入字符串中

I am still new to PHP. I have tried a few stuff, but I just can't get it to work.

Question: I want all the data from my users table to be in a string, separated by comma. Then when the ID is 2 to be ; for net new row, so on and so forth. If someone can please help me.

$server = "localhost";
$user_name = "root";
$password = "";
$database = "users";

$conn = new mysqli($server, $user_name, $password, $database);
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 

$sql = "SELECT * FROM Users;";
$result = $conn ->query($sql);

while($row = mysqli_fetch_array( $result )) {
    $rows = implode (";",$result);
    $array = $rows;

    echo $array;
}

Question2: But if I want first row of DB data to be, separated and then at the end with a ;. How would I do that?

Output: The output of this code is: Warning: implode(): Invalid arguments passed

  • 写回答

2条回答 默认 最新

  • dpuwov1487 2018-08-07 08:53
    关注

    Let's say your user table has 2 fields Firstname and Lastname. What I understood from your question is you want your output to be something like

    $array = ['steve,jobs;', 'mark,zukerberg;'];
    

    To achieve this you can append ';' at the end of the string.

    while($row = mysqli_fetch_array( $result )) {
         $rows = implode(',',$row) . ';'; //you have named this variable $rows but it is going to have data of a single row
         $array = $rows; //you could directly var_dump($rows) instead of assigning it to a new variable
         echo $array; //you could rather use var_dump($array) for this
    }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥20 求有缘人帮我把笛卡尔坐标系转换为经纬度 有偿
  • ¥15 vue2中使用计算属性
  • ¥50 远程桌面打开Mastercam、没有许可证、物理机打开正常
  • ¥15 ubuntu安装gdal后java读取tif文件报错
  • ¥15 请问lammps怎么做两种金属连接的原子浓度分布图
  • ¥15 求jacquard数据集
  • ¥15 w10部分软件不能联网
  • ¥15 关于安装hbase的问题(操作系统-windows)
  • ¥15 novnc连接pve虚拟机报错安全协议不支持262
  • ¥15 设备精度0.03给多少公差能达到CPK1.33