mysql - 如何使用for循环读取所有数据

Question

my code is connection.query('call addtion("'+tr+'","'+lat+'","'+long+'","'+sp+'","'+dat+'","'+start+'","'+stop+'",@phonenos,@nameofstop,@busstartstatus);SELECT @phonenos as PhoneNos;SELECT @nameofstop as NameOfStop;SELECT @busstartstatus as BusStartStatus',function(err,result){

console.log("connection.query('call addtion("'+tr+'","'+lat+'","'+long+'","'+sp+'","'+dat+'","'+start+'","'+stop+'",@phonenos,@nameofstop,@busstartstatus);SELECT @phonenos as PhoneNos;SELECT @nameofstop as NameOfStop;SELECT @busstartstatus as BusStartStatus'");

我的问题是我有

24245676856859870D0A,242457658658786870D0A,24245676856859870D0A,242457658658786870D0A,24245676856859870D0A,242457658658786870D0A,24245676856859870D0A,242457658658786870D0A,24245676856859870D0A,242457658658786870D0A,24245676856859870D0A,242457658658786870D0A,24245676856859870D0A,242457658658786870D0A,24245676856859870D0A,242457658658786870D0A

现在它只获取最后的数据，即242457658658786870D0A

Answer 1

如果给定的数据存储在数组中，则像这样使用 foreach 循环

foreach($data as $str)
{
  echo $str."<br>";
}