Codeigniter: how to convert int to string and then insert into database

Question

i have problem with CI when insert data is integer into database. My field is oauth_uid[varchar(250)], when i use active record insert value is 10205796940433933 into that field, it's become 1.0205796940434E+16

how to fix it!

sorry, my english is not good

Check [this](http://stackoverflow.com/questions/3135804/types-in-mysql-bigint20-vs-int20) question/answer. Also check column [type](http://dev.mysql.com/doc/refman/5.7/en/integer-types.html) in db table. — Tpojka, Apr 22 '16 at 20:40

score 0 · Answer 1 · answered Apr 22 '16 at 23:31

This is from php, if you have a int value and you wold like to convert to make a cast to string you only need to make is

$new_v  = (string) $int_value;

$data_to_insert = array(
                         //other values
                         'oauth_uid'   =>  $new_v
                       );

score 0 · Answer 2 · edited Jul 26 '20 at 14:39

0

I also happened to the same thing and the problem was that I sent GET the form and received it in Controller as POST

edited Jul 26 '20 at 14:39

Dharman

30,962
25
85
135

answered Mar 09 '17 at 22:20

CarlosPinedaT

3,741
1
12
4

Codeigniter: how to convert int to string and then insert into database

2 Answers2