PHP value is a string and boolean need the value as a number-CodePudding

I am trying to improve a woocommerce plugin to add an additional field in a report.

A value of $25.80 is displayed via the variable $item['order_price']

What I am trying to do is convert the value to a number of 25.80 so that I can run a calculation with it. I have tried numerous methods all of which have been unsuccessful (see below). When I run the following code var_dump($item['order_price']) it returns the following string(128) "$25.80"

Any ideas how I can convert this to a number for calculating?

Thanks in advance

# Returns 0 
<?php echo intval($item['order_price']); ?>

# Returns 0 
<?php echo (int)$item['order_price']; ?>

# Returns 0 
<?php echo( intval($item['order_price'])); ?>

# Returns 0 
<?php  $item_price = ( Number($item['order_price'])); ?>

# Return 200 OK
<?php   $unit_price = ereg_replace("[^0-9]", "", $item['order_price']);  ?>

# Returns $25.80
strval($item['order_price']);

# Retuns 0
<?php echo floatval($item['order_price']); ?>

# Retuns 1
<?php echo settype($item['order_price'], integer); ?>

# Retuns True 
<?php echo (boolval($item['order_price']) ? 'true' : 'false')."\n"; ?>

# Returns String 
<?php echo "order price -".gettype($item['order_price']); ?>

# Retuns False
<?php var_dump(is_float($item['order_price'])); ?>

# Retuns $25.801
<?php echo print_r($item['order_price']); ?>

# Retuns 128
<?php echo strlen($item['order_price']); ?>

# Reurns Null
<?php echo substr($item, 0, 5); ?>

# Reurns Null
<?php echo mb_substr($item, 0, 5); ?>

CodePudding user response：

It's the $ that's messing you up. Try trim($item['order_price'], '$') and turn that into a float.

Edit to add: you could also use substr or a few other methods to remove the $, but the above states very nicely your intent, which means the next person will understand instantly what that line of code is there to to.

Edit again to add: The trim function does not alter the provided string, it returns a new, trimmed string.

$price = floatval(trim($item['order_price'], '$'));

please see https://www.php.net/manual/en/function.trim.php

CodePudding user response：

After some work I finally managed to resolve this issue with Jerry pointing me in the right direction.

The string containing the value had multiple characters to deal with and when left with only numbers I notice extra numbers that should not have been there that had been added by the developer to prevent editing the string easily.

Final result looks like this

<td ><?php echo $item['quantity']; ?></td>
<?php
        $unit_price = preg_replace('/[^0-9.] /', '', $item['order_price']);
        $unit_price = substr($unit_price, 2);
        $clean_price = (floatval($unit_price) / floatval($item['quantity']));
        $clean_price = number_format($clean_price, 2, '.', ',');
?>
<td ><?php echo '$'. $clean_price; ?></td>

CodePudding user response：

As an alternative approach, please consider using NumberFormatter to both parse the currency to a float value and output the float value in the desired currency.

Example: https://3v4l.org/XmE3h

$item['order_price'] = '$25.80';

$fmt = new NumberFormatter('en', NumberFormatter::CURRENCY);

$decimal = $fmt->parseCurrency($item['order_price'], $cur);
var_dump($decimal, $cur);

$currency = $fmt->formatCurrency($decimal, $cur);
var_dump($currency);

Result

float(25.8)
string(3) "USD"

string(6) "$25.80"

Although string(128) "$25.80" does not make sense, perhaps there is additional hidden characters in the variable? If it is just white-space, use trim($item['order_price'])