比较php中的两个价格字符串与正则表达式

Question

Say we have two price strings in different format:

$s_price = '85.95' or '1500.00'
$r_price = '$ 85.95' or '1,500'

But all these prices are the same and should match.

I have a regex to do that but don't know if this is how we do it:

(\d+)*(,)?\d+(.)?\d*

Answer 1

To retrieve and parse a float from a string in PHP, use the floatval() method.

For the symbols, it depends on wether you always use the same conventions for your currencies (comma for thousands separator and dot for decimals). In that case, you should remove non-digits except dots with the preg_replace() method (the correspondig Regex could be /[^0-9.]/)

<?php

function sanitize($price) {
    return floatval(preg_replace('/[^0-9.]/', '', $price));
}

$a1 = '85.95';
$a2 = '1500.00';
$b1 = '$ 85.95';
$b2 = '1,500';

sanitize($a1); // (float) 85.95
sanitize($a2); // (float) 1500
sanitize($b1); // (float) 85.95
sanitize($b2); // (float) 1500

sanitize($a1) === sanitize($b1); // (bool) true
sanitize($a2) === sanitize($b2); // (bool) true
sanitize($a1) <= sanitize($a2); // (bool) true
sanitize($b1) >= sanitize($b2); // (bool) false

Hope it will help !