SQL / PHP converting a string to float or int

Question

I have this sql query..

select i.invoiceid as transactionid, i.date, i.total, 
'invoice' as transaction_type
from invoice

and I ran it in php and echo out the total in a foreach loop like so....

echo gettype($row['total']) . "<br/>";

and all the totals returned string

how would I convert the i.total in my sql query to int or float?

i've tried

convert(int, i.total)

and that didnt work :(

JoeCortopassi · Accepted Answer · 2012-05-02 19:41:51Z

3

php handles everything (that's not an array/dictionary) as a string unless you specifically tell it not to with something like (int)$row['total'].

http://php.net/manual/en/language.types.string.php#language.types.string.conversion

answered May 2, 2012 at 19:41

JoeCortopassi

5,0939 gold badges39 silver badges65 bronze badges

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

Comments

digital.aaron · Accepted Answer · 2012-05-02 19:40:00Z

1

You could try

select i.invoiceid as transactionid, i.date, CAST(i.total as int) as total, 
'invoice' as transaction_type
from invoice

answered May 2, 2012 at 19:40

digital.aaron

5,7152 gold badges27 silver badges46 bronze badges

1 Comment

user979331 Over a year ago

This gives me an SQL Error(1064)

Collectives™ on Stack Overflow

SQL / PHP converting a string to float or int

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related