How to user a 'greater than' PHP statement with MySQL Decimals

Question

I have a decimal(15,2) field in my MySQL database named 'price'. I would like to do something like this with PHP:

<? 
    $price = $row->price;
    if($price >= 75) { echo 'Free Delivery'; }
?>

Do I need to turn $price into an integer before doing this? If so, what's the best way to do this? Any help would be much appreciated!

did u tried to echo $price; before if statement to check if it looks good? What error do u have? — artur99
– artur99, Commented Dec 11, 2013 at 13:51
ah ha.... fixed it. The shopping cart I'm using was adding the currency symbol before passing it to the view! Should've checked that first. Thanks for your responses! — Adam
– Adam, Commented Dec 11, 2013 at 13:55

nelag · Accepted Answer · 2013-12-11 13:55:11Z

1

you could use explode() function to get the portions of the string before and after the decimal point. http://php.net/manual/en/function.explode.php

$parts = explode('.', $price);
if($parts[0] >= 75){ echo "free delivery"; }

answered Dec 11, 2013 at 13:55

nelag

486 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

PKolos Over a year ago

It's pointless to explode number to recive int. You don't have to do anything with it.

Adam · Accepted Answer · 2013-12-11 14:06:12Z

0

The shopping cart I'm using was adding the currency symbol before passing it to the view! Should've checked that first. Thanks for your responses!

answered Dec 11, 2013 at 14:06

Adam

1,4852 gold badges14 silver badges17 bronze badges

Comments

kovpack · Accepted Answer · 2013-12-11 14:11:02Z

0

I preferr to store prices in smallest units that are used. If the smallest is cent, so why not just to store cents as normal INT? That will solve many problems and will be fast.

answered Dec 11, 2013 at 14:11

kovpack

5,0658 gold badges41 silver badges56 bronze badges

Collectives™ on Stack Overflow

How to user a 'greater than' PHP statement with MySQL Decimals

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related