PHP中的字符串替换

Question

I have replaced comma , buy using str_replace(); following is the code of it

$result1 = mysql_query("SELECT * FROM table WHERE lc_status='Yes' ORDER BY file_no DESC");
$tmp=0;
$tmp1 = 0;
while($row=mysql_fetch_assoc($result1)){
$tmp +=str_replace(',','', $row['jpy_value']);
$tmp1 +=str_replace(',','',$row['lkr_value']);

Now I can get the total value of the column. but total value is coming without the comma.
Ex: 250000

how can i replace the comma back to normal number format. i would be very glad if someone can help me with it

Answer 1

use intval() to convert the string to number and str_replace to replace the ,.

$tmp += intval(str_replace(",", "", $row['jpy_value']));
$tmp1 += intval(str_replace(',','',$row['lkr_value']));