How to convert Codeigniter DB return string object to int

Question

    $sql = "SELECT catgy.category_id, catgy.category_title 
            FROM categories catgy
              INNER JOIN subj_category_relation scr
                ON scr.scr_id = catgy.category_id  
              INNER JOIN subjects subj
                ON subj.subject_id = '{$sId}'
            WHERE subj.subject_id = '{$sId}'
                AND subj.subject_id = scr.subject_id";

    $res = $this->db->query( $sql );

    if ($res) { 



        $results = $res->result_array();

        echo "<pre>";
        var_dump( $results );
        echo "</pre>"
        exit;

vardump

array(5) {
  [0]=>
  array(2) {
    ["category_id"]=>
    string(1) "1"
    ["category_title"]=>
    string(5) "terms"
  }
  [1]=>
  array(2) {
    ["category_id"]=>
    string(1) "2"
    ["category_title"]=>
    string(6) "people"
  }
  [2]=>
  array(2) {
    ["category_id"]=>
    string(1) "3"
    ["category_title"]=>
    string(8) "places
"
  }
  [3]=>
  array(2) {
    ["category_id"]=>
    string(1) "4"
    ["category_title"]=>
    string(7) "works
"
  }
  [4]=>
  array(2) {
    ["category_id"]=>
    string(1) "5"
    ["category_title"]=>
    string(8) "events
"
  }
}

Getting Database int type in string. What is the proper solution? Instead converting each array may be not good solution.

vote down for no reason – Alizain Prasla Apr 02 '14 at 17:13 — Alizain Prasla, Apr 02 '14 at 17:13

Alizain Prasla · Accepted Answer · 2018-06-13T10:53:47.910

0

Database object should return correct value type in object. there is issue in PHP/MySQL older versions.

https://dev.mysql.com/downloads/connector/php-mysqlnd/

Install php5-mysqlnd driver

apt-get install php5-mysqlnd
service apache2 restart

Reference: MySQL integer field is returned as string in PHP

Check @advait answer

edited Jun 13 '18 at 10:53

answered May 13 '16 at 08:30

Alizain Prasla

744
2
15
37

nanobash · Answer 2 · 2014-03-27T15:18:01.750

-1

Try array_walk to convert string to int:

array_walk($results, function(&$a) {
    $a['category_id'] = (int)$a['category_id'];
});

var_dump($results);

DEMO

When retrieving even integers from DB it is converted to string so you have to manually convert them back to int

edited Mar 27 '14 at 15:18

answered Mar 27 '14 at 15:11

nanobash

5,419
7
38
56

I have list of function like these.. Do i use this solution each time? – Alizain Prasla Mar 27 '14 at 15:25
@AlizainPrasla I can't guess your comment, though like you see you've to pass `array` into function and it will return `int` instead of `string`. Use function based on your needs – nanobash Mar 27 '14 at 15:27
I think iteration is not right way. Its should return INT from database because Primary keys are in Int value. – Alizain Prasla May 13 '16 at 08:19

score -1 · Answer 3 · answered Mar 27 '14 at 15:14

-1

$new_int_array = array();
foreach($results as $value){
    $new_int_array [] = array_map('intval', $value);
}
print_r($new_int_array); //this is new array with int type values.

answered Mar 27 '14 at 15:14

Muhammad Irfan

228
1
8

Unefficient to create new array when you can just change values of elements by reference ! – nanobash Mar 27 '14 at 15:20
try settype function for your array. – Muhammad Irfan Mar 27 '14 at 15:28
It's about to write script short and useful with best performance. Otherwise the same task can be solved with many ways – nanobash Mar 27 '14 at 15:30
foreach($results as $value){ foreach($value as $value1){ settype($value1, "integer"); } } – Muhammad Irfan Mar 27 '14 at 15:31
Can you please explain this code (in your answer)? You might get more upvotes that way! – The Guy with The Hat Mar 27 '14 at 15:34
foreach($results as $value){ foreach($value as $value1){ settype($value1, "integer"); } } --------------------------------------------------------------------- with two loops we get internal values of arrays and than set there type to integer which is required. – Muhammad Irfan Mar 27 '14 at 16:20
are you want explanation of comment code or answer code.? – Muhammad Irfan Mar 27 '14 at 16:23
I think iteration is not right way. Its should return INT from database because Primary keys are in Int value. – Alizain Prasla May 13 '16 at 08:19

How to convert Codeigniter DB return string object to int

3 Answers3