wpdb returns ids as string instead of int

Question

I am trying to get favorite post ids from my table with get_col, but the results return ids as string instead of int. How can i get them directly as int ?

$sql = "SELECT post_id FROM {$table} $where
            GROUP BY post_id
            ORDER BY post_type
            LIMIT $offset, $count";
$wpdb->get_col( $sql );

Image: http://s16.postimg.org/b2khhvlxx/wpdb_Untitled_1.jpg

it returns a string because that's the way this works... it should return a string but with the value you selected. you can just change it to an int: $number = (int)$wpdb->get_col( $sql ); — Eliran Efron
– Eliran Efron, Commented Feb 4, 2014 at 7:08
Because wordpress' WPDB doesn't work with any model like structure, there's no way it knows the data should be INT, so it behaves as any MySQL query, and returns all data as strings. — martinczerwi
– martinczerwi, Commented Feb 4, 2014 at 9:56

Emin Özlem · Accepted Answer · 2014-02-04 16:50:45Z

1

Thank you for the comments. To answer my own question; there is no way to return the result as int, since this is the default behaviour of wp. So you can either use wp's native function: absint($result[$item]), or $result_int = array_map('intval',$result); I went with the latter.

answered Feb 4, 2014 at 16:50

Emin Özlem

8297 silver badges13 bronze badges

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

Collectives™ on Stack Overflow

wpdb returns ids as string instead of int

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related