dqby43944
2019-07-28 19:11 阅读 75
已采纳

如何从PHP中获取附近的数据库值?

I have a table in my database which is related to another table, there are 2 fields in database one is minprice and another is maxprice, these fields have floating value stored in database (eg. 23.47 Lac). Now i want nearby value from database on 1 field, I am using round($r->minprice); for this, but it's giving me the value between (1-100), But i want like this (Suppose a property have price 13.45 lac, then it could be show min 10 lac on display), What will be the condition for this.

Here are my code....

$praa = round($r->minprice);
$prop->meta_desc = $best." ".$subCat[0]->cat_name." ".$in." ".$cities->name
                    ." ".$Location->locations.","." ".$r->title." ".$subCat[0]->cat_name
                    ." ".$under." ".$praa." " ."Lac";
  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享

1条回答 默认 最新

  • 已采纳
    duansaxf095988 duansaxf095988 2019-07-28 20:37

    You can try this:

    $praa = (int) round($r->minprice, -1);
    

    It'll round to the nearest 10th.

    Live demo here

    点赞 评论 复制链接分享

相关推荐