StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POPDO binding values for MySQL IN statement
primarykey
Id
1586587
data
AcceptedAnswerId
1586650
AnswerCount
8
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2009-10-19T01:29:40.013
FavoriteCount
21
LastActivityDate
2016-03-23T17:54:40.163
LastEditDate
2015-10-05T11:11:50.833
LastEditorUserId
2704187
OwnerUserId
192165
ParentId
0
PostTypeId
1
Score
66
ViewCount
46327
LastEditorDisplayName
text
Body
I have an issue with PDO that I'd really like to get an answer for after being plagued by it for quite some time. Take this example: I am binding an array of ID's to a PDO statement for use in a MySQL IN statement. The array would be say: $values = array(1,2,3,4,5,6,7,8); The database-safe variable would be $products = implode(',' $values); So, $products would then be a STRING with a value of: '1,2,3,4,5,6,7,8' The statement would look like: <pre><code>SELECT users.id FROM users JOIN products ON products.user_id = users.id WHERE products IN (:products) </code></pre> Of course, $products would be bound to the statement as :products. However, when the statement is compiled and values bound, it would actually look like this: <pre><code>SELECT users.id FROM users JOIN products ON products.user_id = users.id WHERE products IN ('1,2,3,4,5,6,7,8') </code></pre> The problem is it is executing everything inside of the IN statement as a single string, given that I've prepared it as comma-separated values to bind to the statement. What I actually need is: <pre><code>SELECT users.id FROM users JOIN products ON products.user_id = users.id WHERE products IN (1,2,3,4,5,6,7,8) </code></pre> The only way I can actually do this is by placing the values within the string itself without binding them, however I know for certain there has to be an easier way to do this.
Tags
<php><mysql><pdo><sql-in>
Title
PDO binding values for MySQL IN statement
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USDominique
UserOwnerUserId
1. UShd82
plurals
PostLinksPostIdRelatedPostId
1. PL
 singulars
 LinkTypeLinkTypeId
 LTLinked
PostLinksRelatedPostIdPostId
1. PL
 singulars
 LinkTypeLinkTypeId
 LTLinked
2. PL
 singulars
 LinkTypeLinkTypeId
 LTLinked
3. PL
 singulars
 LinkTypeLinkTypeId
 LTLinked
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
 POPDO binding values for MySQL IN statement
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 POPDO binding values for MySQL IN statement
 UserUserId
 USPablo
 VoteTypeVoteTypeId
 VTFavorite
3. VO
 singulars
 PostPostId
 POPDO binding values for MySQL IN statement
 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.