How to execute two SQL commands at the same time through PDO?

Question

PHP

Is it possible to execute such a request through PDO (myslqi is not suitable)?

CALL `GET_AVG_SALARY`(@p0); SELECT @p0 AS `result`;

Now it doesn't work for me. Writes SQLSTATE[HY000]: General error . In phpMyAdmin the result is correct.

In the php code itself, I have a class for working with data. It has a method that makes an PDO->prepare()incoming string (I don’t process the string in any way, so I would like to leave the prepare method) and just PDO->execute(). I use it for this request. But it doesn't work for my situation. I read about transactions and it doesn’t seem to work either, because they are not used to return values. Correct if not.

Answer 1

can

$pdo->query("CALL `GET_AVG_SALARY`(@p0)");
$pdo->query("SELECT @p0 AS `result`");

And for mysqli, this code is also suitable.

Answer 2

Do it with a transaction