PDO Union Where and In

Question

$prepare=$text->prepare("
  select *
  from (
    select text1,text2
    from test1
  union
    select text1,text2
    from test2
  ) as u
  where u.text1 in (?,?)");
$prepare->execute($array);
$fetch=$prepare->fetch(PDO::FETCH_ASSOC);
print_r($fetch);

I have a PDO statement that uses UNION, WHERE and IN all in one. This should be returning a few results. The array contains all datapoints. What might be the issue in the statement?

score 0 · Answer 1 · edited May 23 '17 at 11:44

0

In prepared statements, in IN clause you need to construct the query yourself. See this post for more information. If you got an error, please edit your post and include the error msg.

EDIT:

//Correct use of fetch statement:
$prepare->execute($array);
$results = array();
while( $fetch=$prepare->fetch(PDO::FETCH_ASSOC) ){
    $results[] = $fetch;
}
print_r($results);

edited May 23 '17 at 11:44

Community

1
1

answered Oct 12 '15 at 23:59

Emiliano Sangoi

921
10
20

Ok. But I tried testing out without IN. Just doing "select * from (select text1,text2 from test1) as u" and I only got 1 result when there are over 8 in the database. – Maciek Semik Oct 13 '15 at 00:11
How many rows do you get trying only with "select text1,text2 from test1" ? – Emiliano Sangoi Oct 13 '15 at 00:35
Do you get only one row trying from php or from mysql console? You are using the fetch statement incorrectly – Emiliano Sangoi Oct 13 '15 at 00:39
I just realized I am using "fetch" instead of "fetchall" – Maciek Semik Oct 13 '15 at 00:43

PDO Union Where and In

1 Answers1