MySQL int fields -> php strings

[eluser]danmontgomery[/eluser]
PHP's mysql_fetch_assoc and mysql_fetch_object functions return only strings, this is clearly explained both on the page you linked to and the pages for these functions on php.net.

I would do something like:

Code:

$query = $this->db->query('some query');
if($query && $query->num_rows()) {
    foreach($query->result_array() as $row) {
        // Replace integer strings with actual integers
        array_walk($row, create_function('&$val','$val = ( is_numeric($val) ? intval($val) : $val );'));

        // Do whatever you need to do
        $data[] = json_encode($row);
    }
}