StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POValue inserted into MYSQL table differs from original value
primarykey
Id
4081834
data
AcceptedAnswerId
4081866
AnswerCount
4
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2010-11-02T20:32:28.213
FavoriteCount
0
LastActivityDate
2010-11-02T20:38:02.300
LastEditDate
LastEditorUserId
0
OwnerUserId
473549
ParentId
0
PostTypeId
1
Score
2
ViewCount
216
LastEditorDisplayName
text
Body
I'm having the strangest problem with a value changing when I insert it to a MYSQL table. This is for a Wordpress theme. Here's the gist of the code: <pre><code>$user_id = $_COOKIE['user-id']; $wpdb->insert($custom_table,array('user_id'=>$user_id)); </code></pre> The type of the 'user_id' field of $custom_table is int(15). I'm currently testing on myself. The user id stored in my cookie is 4022466561291. It's being stored in the database as 2147483647. I've also tried various combinations of this setup: <pre><code>$user_id = intval($_COOKIE['user-id']); $wpdb->insert($custom_table,array('user_id'=>$user_id),array('%d')); </code></pre> with the same results. Any ideas?
Tags
<php><mysql><wordpress>
Title
Value inserted into MYSQL table differs from original value
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USmjsiemer
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
3. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POValue inserted into MYSQL table differs from original value
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 POValue inserted into MYSQL table differs from original value
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.