doumiang2297 2013-01-08 20:35
浏览 51
已采纳

从数组中过滤字符串值以仅格式化数字

The problem is, I have an array that I get from this query :

$secimKrm   =   ("SELECT * FROM kurumlar
INNER JOIN veri_2012_09
ON kurumlar.krmKod  =  veri_2012_09.krmKod
WHERE kurumlar.krmKod = '$krmKod'");
$sonucKrm   =   $mysqliKrm->query($secimKrm);
$row    =   $sonucKrm->fetch_assoc();

"kurumlar" consists of strings and "veri_2012_09" consists of big integers. There are almost 35 columns in "veri_2012_09" and I don't want to format numbers one by one.

When I try to format numbers in the array "$row" I use this:

foreach ($row as $key => $val) {
$row[$key] = number_format($val, 0, ',', '.');
}

It works, but it causes errors, (Warning: number_format() expects parameter 1 to be double, string given in...) because my array has strings in it. How can I exclude the strings before formatting the numbers?

  • 写回答

1条回答 默认 最新

  • douao3636 2013-01-08 20:36
    关注

    Perform is_numeric check like:

    foreach ($row as $key => $val) {
        if (is_numeric($val)) {
            $row[$key] = number_format($val, 0, ',', '.');
        }
    }
    

    So your question shouldn't be "How can I exclude the strings", but "How can I include only strings"

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥20 测距传感器数据手册i2c
  • ¥15 RPA正常跑,cmd输入cookies跑不出来
  • ¥15 求帮我调试一下freefem代码
  • ¥15 matlab代码解决,怎么运行
  • ¥15 R语言Rstudio突然无法启动
  • ¥15 关于#matlab#的问题:提取2个图像的变量作为另外一个图像像元的移动量,计算新的位置创建新的图像并提取第二个图像的变量到新的图像
  • ¥15 改算法,照着压缩包里边,参考其他代码封装的格式 写到main函数里
  • ¥15 用windows做服务的同志有吗
  • ¥60 求一个简单的网页(标签-安全|关键词-上传)
  • ¥35 lstm时间序列共享单车预测,loss值优化,参数优化算法