Preparing and executing two queries

Question

If i have 2 queries like this

$query1 = "SELECT title, content, image FROM table1 WHERE id = :id";
$query2 = "SELECT title, content FROM table2 WHERE id = :id";

Can i prepare two of them at once like something like this

$stmt = $conn->prepare($query1, $query2);
$stmt->execute([':id' => $id]);

You need to prepare the qeuries one by one... there isn't a multi prepare function.. — Raymond Nijland, Jun 15 '17 at 11:43
@AjeetKumar `prepare() expects parameter 2 to be array, string given` — Calibur Victorious, Jun 15 '17 at 11:43
give [this](https://stackoverflow.com/questions/905379/what-is-the-difference-between-join-and-union) a read as well. I think union is what you need. — hungrykoala, Jun 15 '17 at 11:45
Add id 2 times in array ``$stmt->execute([':id' => $id,':id' => $id]);`` — Ajeet Kumar, Jun 15 '17 at 11:47
You can not put 2 queries in prepare(), but you can use join to get values from multiple table — Pankaj Makwana, Jun 15 '17 at 11:49
@CaliburVictorious because both are same key make it different keys and the check, it will work. But its not correct way because both are select Query means 2 views will create — Ajeet Kumar, Jun 15 '17 at 12:02
@AjeetKumar I guess the problem in the prepare`($query1, $query2);` before the `execute()` problem and the `execute()` problem is `Call to a member function execute() on boolean` — Calibur Victorious, Jun 15 '17 at 12:05

score 0 · Answer 1 · answered Jun 15 '17 at 11:51

0

You can do this with MySQL UNION.

answered Jun 15 '17 at 11:51

Sanan Guliyev

The columns numbers isn't matched. – Calibur Victorious Jun 15 '17 at 11:54
It is not problem. In second query you can do like this: SELECT '' AS image – Sanan Guliyev Jun 15 '17 at 11:56
Didn't catch it correctly, so in the 2nd query i'll make it like this? `$query = "SELECT title, content, image FROM table1 WHERE id = :id UNION ALL SELECT title, content, image AS image FROM table2 WHERE id = :id ";` or something like that? If possible put an example using my example – Calibur Victorious Jun 15 '17 at 11:58
You can use it like that: `SELECT title, content, image FROM table1 WHERE id = :id UNION ALL SELECT title, content, '' AS image FROM table2 WHERE id = :id` – Sanan Guliyev May 03 '18 at 20:05

1 Answers1