php - mysql PDO SET statement encounter errors -


I was looking for something that is related to a mysql query and I stumbled for this link and stored proc- like Variable Saw setting I have tried to do this in phpmyadmin:

SET @value = 5; SELECT @rank;

And it's working, but when I tried to keep it in the PDO statement, it does not work.

$ value = "SET @value = 0"; $ Stmt = $ this- & gt; _dbHandle- & gt; Ready ($ value); $ Stmt- & gt; Executed ();

Please guide me on what I'm doing wrong.

The answer is, my test environment is using sqlite instead of my query in a test browser A phpunit test is run in stability and it has worked. Friends, missed the lead from the examination environment.


Comments