Prepared statements and floats

Question

I am playing with my own implementation of Google maps and I want to do it properly through prepared statements and mysqli object (not mysql as stated in the linked example) Also, I added "own registration" so I am afraid of SQL Injection. But, how do I bind Float value to the prepared statement?

My table has (among others) FLOAT type columns:

CREATE TABLE `markers` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`name` VARCHAR( 60 ) NOT NULL ,
`description` TEXT NOT NULL ,
`lat` FLOAT( 10, 6 ) NOT NULL ,
`lng` FLOAT( 10, 6 ) NOT NULL ,  
) ENGINE = MYISAM ;

But reading the manual I can see only these types:

Character   Description
i   corresponding variable has type integer
d   corresponding variable has type double
s   corresponding variable has type string
b   corresponding variable is a blob and will be sent in packets

Should I assume that when column is a FLOAT i should use b for a blob? (because its not string and not a double value). And the same for TEXT type column?

In PHP, double is just another name for float. http://www.php.net/manual/en/language.types.float.php At C level they all are stored as double, and the real size of the type depends on the platform. — Ruben Serrate, Jan 28 '14 at 10:23
Ok, so I should assume that using blob is for ... well, blob? :) Makes my life easier :) — Pavel Janicek, Jan 28 '14 at 10:25
Have you tried to change the column type of lat, lng in database to DOUBLE? the prepared statement with "d" worked perfect for me — gyss, Jul 02 '14 at 22:59
I did not, but changing the prepared statement to "d" solved the problem — Pavel Janicek, Jul 03 '14 at 07:14

score 37 · Accepted Answer · answered Jul 02 '14 at 14:14

37

Just use "d" for non integer numbers

answered Jul 02 '14 at 14:14

gyss

1,753
4
23
31

Prepared statements and floats

1 Answers1