我的数据库中有带逗号的值。例如:
周一,周二,周三,周四,周五。当我从数据库中调用某个 id 的行时,我想将结果写入每个逗号后的文本文件到新行中,如下所示:
Monday
Tuesday
Wednesday
Thursday
Friday
一个在另一个下面。
希望这是有道理的。
您可以使用分解函数。
爆炸 — 按字符串拆分字符串
$days = "Monday,Tuesday,Wednesday,Thursday,Friday,Saturday,Sunday";
$weekdays = explode(",", $days);
foreach( $weekdays as $value ){
echo $value."n";
}
输出:
Monday
Tuesday
Wednesday
Thursday
Friday
我认为它会为你工作!
类似的东西:
$result = "Monday,Tuesday,Wednesday,Thursday,Friday,Saturday,Sunday";
$array = explode(",", $result);
foreach( $array as $key => $value ){
echo $value."n";
}
爆炸函数将帮助您
$str = "Monday,Tuesday,Wednesday,Thursday,Friday";
$val = explode(",",$str);
foreach ($val as $key=>$value) {
echo $value.'</br>';
}
使用类似这样的东西
$colVal = $row['col-name'];
echo str_replace(",", "rn", $colVal);