Telegram Bot 和 Mysqli_fetch_assoc 问题

Question

我正在用 PHP 制作一个 Telegram 机器人。我已经连接了一个 Mysql 数据库，并且需要在唯一的消息中打印一些结果。但是当我启动命令时，它会在一些消息中打印每个结果。如何在一条独特的消息中打印所有结果？

这是代码：

if($data == 'rawliberi'){

  $thequery = "SELECT * FROM uwgliberi WHERE roster='OCW'";

  $thequeryup = mysqli_query($conn, $thequery);

  while($row = mysqli_fetch_assoc($thequeryup)){

       $Alex -> Request('sendMessage', ['chat_id' => $chat_id, 'text' => $row['wrestlername'], 'parse_mode' => 'HTML']);

  }

}

Answer 1

您正在为查询中的每个结果发送一条消息，因为 while 循环是针对所有行执行的。如果我理解正确的话，您想发送一条包含所有查询结果的消息。我建议您使用PDO连接数据库并从数据库获取数据/向数据库插入数据，因为这样更安全。尝试这个：<?php$pdo = new PDO("mysql:host=localhost;dbname=DATABASE_NAME", "USERNAME", "PASSWORD");if($data == 'rawliberi'){  $allResults = "";  $stmt = $pdo->prepare("SELECT * FROM uwgliberi WHERE roster=:roster"); // Prepare the query  $stmt->execute(['roster' => "OCW"]); // Replace parameters starting with ":" with the given value (e.g. replace ":roster" with "OCW") and execute the query  $results = $stmt->fetchAll(\PDO::FETCH_ASSOC); // Insert results in the $results variable/*Result's value example[  {    "id": "1",    "wrestlername": "Nicola",    "roster": "OCW"  },  {    "id": "2",    "wrestlername": "Mauro",    "roster": "OCW"  },  {    "id": "3",    "wrestlername": "Don Gino",    "roster": "OCW"  }]*/  for ($i = 0; $i < count($results); $i++){ // Execute this loop for each result in $results. The count() function return the count of the results    $allResults .= $results[$i]['wrestlername'] . "\n"; // Add the wrestlername to the allResults variable and go to a new line (\n) so the names won't be "NicolaMauroDon Gino"  }  $Alex->Request('sendMessage', ['chat_id' => $chat_id, 'text' => $allResults, 'parse_mode' => 'HTML']);}